Finding Uppercase Values
Oct 12, 2005Hi All,
How can I report on records which have uppercase values in a record. The data I have in the table is a mixture of Titlecase and UPPERCASE. I need to report on the uppercase values.
Thanks,
Evan
ADVERTISEMENT
Finding The Sum Of The Values In A Field.
Aug 22, 2006I am trying to create a DB that would calculate the totals of different projects and also calculate the global total (i.e. the total of all the projects combined together)
So far I have created a query that can calculate the total of the projects in a field which I have named Total1. But now I want to calculate the sum of the field Total1, i.e. add all the totals of the projects up.
Sorry my explanation does seem quite lengthy, any help would be much appreciated.
ia.:)
Queries :: Finding Top Three Values In Six Fields?
Oct 3, 2013I'm doing a medical db, where I'm trying to calculate ISS
Code:
en.wikipedia.org/wiki/Injury_Severity_Score
There are 6 values, and i have to sum the largest three (squares to be precise). How can I get three highest values from 6 fields in the same record?
Finding Duplicate Values From The Table Having No Primary Key
May 18, 2005Hi All,
I have one table where ID field is autogenerated, and another field orderno which is not primary key. Now it has 2 duplicate values in it so when I try to make field Orderno as primary key, it is not allowing me to do so.
Can any one help me how to find the duplicate values using query.
Thanks in advance,
Jigs
Finding Values That Are Duplicated / Can Create NO DUPLICATES Index
Jun 13, 2013I am using Access 2010 32-bit on a Windows 7 64-bit platform.I have a database that I have imported existing data into. For the most part, I have eliminated duplicate entries in my Item Number field.
Obviously I have missed at least one (or possibly more) duplicates. When I try to create a NO DUPLICATES index, I am informed that there are duplicate entries.I am looking for a quick way to generate a list of values that are duplicated so I can address those and correct them.Item number field is a number field of type DOUBLE with 2 decimal places.
Modules & VBA :: Finding Duplicates In A Table And Recording Values In That Record
May 2, 2014I've been looking everywhere to find a better way of finding duplicates in a table and then recording and adding another value in that record together.
Let me try to explain better.
example:
I have a table that has 2 columns "Name", "DOB". I would like to find all duplicate "DOB" and add all of the "Name"'s together.
Quote:
Name DOB
bob 19800201
Sam 19761211
Jim 19800201
The output I would like is to have Name = bob & Jim DOB = 19800201.
I've tried using the find duplicate wizard in access but I can't seem to group them together and just to find the duplicates it takes upwards of a minute.
Uppercase
Mar 10, 2006Stupid I know...but I forget how to update a Field to itself in Uppercase..
Anyone?
Thanks!
Automatically Increment To Uppercase, How?
Mar 31, 2006in an initials field... i want it so that it could automatically increment the 3 letters to uppercase... how? if it can't be done in a table where can it be made (i.e. in a form, query etc)
View 2 Replies View RelatedUppercase In Lookup Combo Box
Aug 5, 2005I would like all of the text in my database to appear in upper case. I used the > symbol in the format of all controls and in my tables also. However, on my form's lookup combos it doesn't work. When I click the dropdown it shows all selections in upper case, but after I select it turns into lower case again.
I then tried using Ucase and strConv but those don't seem to work with my combos either.
I have searched and these are all the suggestions I could find on how to do this, does anyone know another or possibly what I am doing wrong?
Validation Rules - Uppercase
Mar 11, 2008I am as new to MS Access as you can possibly get so please forgive such a simple question. I created a table in Design View. On one of the fields in the table I want to restrict the values that the user is allowed to enter to either a capital Y or a capital N so I created the following validation rule in design view:
=UCase("Y") Or UCase("N")
No matter what I do, the data sheet view allows me to enter a lower case Y or a lower case n. How can I make sure that this field only accepts a capital y or a capital N.
Thanks
Forms :: First Letter In Uppercase
Feb 12, 2015In a form I have fields name, first name in which I would if necessary want to put the first letter of the name and/or the first name in uppercase. I created for it a buttonUPLOW How to synchronize this action.
Code:
Function MiseEnMajuscule(Chaine As String) As StringDim
nCar As Integer
'Compteur (position dans la chaine traiter)
Chaine = Trim$(Chaine)
[Code] ....
Uppercase Column Names With VBA Or Macro?
Aug 31, 2005Hi Everyone:
I have a project of migrating our Access data to Oracle. One of the pre-reqs the boss wants is to uppercase all of the column names (Field name) for all of the tables. I want to avoid manually going in all the tables and changing the case of the columns because there is like 300 tables where dealing with. I was wondering if in Access..is there an efficient way of converting my column names to upper case via script? VBA or Macro?
General :: Only Last Word In Uppercase (Surname)
Sep 11, 2013I have a textbox called "name", what i am trying to do is have lowercase on first/second names in the textbox except the last word (surname)this i want in uppercase.
View 1 Replies View RelatedQueries :: Need To Set StrConv With First Character Uppercase
Apr 20, 2014Im linking to sql across ms access and I have all records uppercase.I need to set StrConv with first character uppercase and every other lowercase which is not problem.
View 5 Replies View RelatedForms :: Convert Certain Text From Textbox To Uppercase?
Jul 24, 2014I've got an address box on my form. When someone enters 'London' inside the box, I want only 'london' to be changed to all-caps.
View 5 Replies View RelatedReports :: Force Uppercase In Report Label
May 23, 2013I have the following code of my holiday calendar however I would like to convert the month into uppercase. I know about the 'Ucase' function but I am fairly new to this and have tried to place this within the code but with no success:-
With theReport
.Controls("labelMONTH").Caption = Format(StartDate, "mmmm")
General :: Changing Text So That First Letter Is Uppercase
Nov 24, 2012I want to change text in txt boxes. when a new customer is being created we are too lazy to put uppercase in. so i want to change the text so the first letter is uppercase. i have used this on every event and it doesn't change a thing.
PHP Code:
Private Sub txtTown_AfterUpdate()LResult = StrConv("TECH ON THE NET", 3)End Sub
Private Sub txtPostcode_AfterUpdate()LResult = StrConv([txtPostcode], 1)End Sub
Private Sub txtStreet_AfterUpdate()LResult = StrConv([txtStreet], 3)End Sub
Private Sub txtFirstName_BeforeUpdate()LResult = StrConv([txtFirstName], 3)End Sub
I have this at the top
PHP Code : Option Compare DatabaseOption ExplicitDim LResult As StringDim LResponse As Integer
Reports :: Text Box Make Bold Uppercase Text
Sep 18, 2014is it possible with transform, only uppercase text contained in a report textbox, to bold? How? Through VBA?....
View 1 Replies View RelatedFinding Help?
Aug 21, 2007Hi all:)
I am looking for some advise, I work for a small service company and we our trying to computerize our service jobs through the use of access 2007, We have completed 80% of the database but are having a few problems completing, for example the search function on some forms etc, I have searched the web for help and have posted the problem on this forum a number of times but I am still unable to get it to work myself as I am new to access , the problem is I need the database completed asap before we take on a bigger contract and I am running out of time, so I was wondering if anyone knew of anyone / or any company out there that could have a look at the search form, I would obviously pay for it, I have tried to approach a few companies but they will not take on such a small job, they only want to take on the development of the entire database?
Anyone know of anyone?
Jackie :)
Finding #
Nov 4, 2005I'm searching through some text fields like the following:
Ann12 #1
Ann12 #2
Ann12 #3
Ann1 #12
Ann2 #14
ect...
I'm doing a like query
Like "*#*2*"
However, the # is the keyword for Date, so what do I use instead?
Finding ABC
Aug 17, 2006Hi
I hope someone can help with this as I can't seem to get this query to work.
I am trying to use a query to search for the highest value in a column but based upon a specific criteria.
i.e. in the column will be ABC1234, ABC1235, ABC1236 and BBC1234 and I want to get the highes 'ABC' value
I looked on the forum and found this code
Dim strSQL As String
Dim MyValue As DataType 'Replace the proper datatype of field
Dim rs As ADODB.Recordset, Cn As ADODB.Connection
Set rs = New ADODB.Recordset
Set Cn = New ADODB.Connection
Set Cn = CurrentProject.Connection
strSQL = "SELECT tableName.ColumnName FROM tableName ORDER BY tableName.ColumnName DESC"
rs.Open strSQL, Cn, adOpenStatic, adLockReadOnly
MyValue = rs!ColumnName
rs.Close
Set rs = Nothing
I've modified the query to this
strSQL = "SELECT tableName.ColumnName FROM tableName WHERE tableName.ColumnName Like 'ABC*' ORDER BY tableName.ColumnName DESC"
This doesn't bring anything back but I was expecting 'ABC1236'
I'm new to using 'Like' so this could be the problem.
Your help is much appreciated.
Finding BAC-5, BAC-8 And BAC-12???
May 3, 2007Greetings all,
It's been a while since I've had to turn to you for help. I'm usually able to find what I need in searching through previous posts, but no luck this time around.
I am trying to write a query criteria that will return
BAC-5, BAC-8 And BAC-12
I can get the -5 and -8 with:
Like "BAC-[58]"
But I can't figure out how to get the -12...
The actual part numbers are quite a bit longer and there are hundreds where I only need specific dash numbers returned.
I'm sure this one will be simple, I just couldn't seem to figure out how to search for it.
Thanks in advance!
Finding Something Thats Not There?
Sep 27, 2007Hi guys
I have a DB for insurance permits.
tblSubtractors
ID
NAME
ADDRESS
PHONE
tblPolicy
ID
SubbyID
POLICYID
Insurer
PolicyNumber
ExpiryDate
tblPolicyTypes
ID
Name
Most subcontractors will have a policy number for each type of policy in tblPolicy. But is there a way I can run a query to show each subby that doesnt have one of the policies? As an example, the query would show me that ABCcontractors doesnt have Marine Transit insurance. XYZContractors doesnt have Public Liability, etc
I know how to show all the policies that have expired, but I'm looking to identify which ones dont have a policy at all
:confused:
Finding ID
Aug 6, 2006Hello,
I have this code that I use to update a record:
Code:<%Dim idid = session("loginID")Dim rsSaveSet rsSave = Server.CreateObject("ADODB.RecordSet")rsSave.open "log", conn, adOpenDynamic, adLockOptimistic, adCmdTablersSave.find "id=" & idDim Datumlogout, Uurlogout, loggedoutOKrsSave("Datumlogout") = datersSave("Uurlogout") = timersSave ("LoggedoutOK") = ("true")rsSave.updatersSave.closeset rsSave=Nothing%>
Can someone help me please, I would like to have the code changed to:
When the ID not excists, that there is a new record written.
Thanks in advance!
Finding An Average
Aug 8, 2007I have a customer concerns database that contains the dates for when the concerns were reported and tyhe dates for when the concerns were resolved. I am trying to make a query that finds the average of how long it takes for the concerns to be resolved. How can I do this?
View 1 Replies View RelatedFinding The Last Row In Worksheet
Feb 29, 2008Now this is not like me, posing a question, but I thought its about time I codes the app correctly.
My app opens up any given spreadsheet. The first task is to establish the last row used in the spreadsheet. Normally you would loop until there is nothing in a cell in column A, whatever.
However the way the spreadsheets are provided there may be pleanty of blank rows. I have tried using the Edit GoTo Special LastCell and converting it to a macro
But when I run this VB it does not like it for some reason.
I am sure someone out there has come up with a solution by now.
CodeMaster::cool: