Topics Search

View only records with uppercase letters for a certain field

View only records with uppercase letters for a certain field
Views: 72
If I wanted to view only the records with Uppercase letters for a certain field, how would I do it?
Sponsored Links:

More topics

 

Ucase A Field?

Preview
I want to automatically convert all letters entered in a postcode field on a form to uppercase. I'm not sure of the syntax. In VBA I have :

Public Sub uppercase()
 

field to field, get only uppercase?

Preview
I am building an inventory list for my business and I am trying to generate a unique 'ItemID' field.
I want to get only the uppercase letters from my BandName field and a random 5 digit number to make up the ItemID field.

How do I do this. I have been trying for days
 

Query for Partial Uppercase Text in Field

Preview
I know there are several ways to just convert from lower case to uppercase and I know there are things like Expr1: Asc([CountLocation]) you can use with 80 to find all uppercase records in a query, but mine is a bit different and I'm wondering if it's even possible.

I have a text field called CountLocation. The format for this should be as follows:

MAIN STREET NAME: Cross Street Name

So what I want to do is search all the records that do not have all caps before the :

Then I want to search for all the records that only have all caps after the :

The only way I could think of doing it is, text delimiting the field in say Excel by the : and then putting that as a new table in access and searching that way. Too much work I think and not very efficient. So anyone have a clue how to do a partial search for uppercase and lower case as in my example above?
 

Field Headers in a Tbl Made by a Qry

Preview
I have a table that is created by a MakeTable qry. After the table has been created, one of the field names is in lowercase. If I change that field name to all uppercase in Design View of the table, save and close, the field name reverts back to lowercase when the table is reopened. If I change the field name to uppercase when the table is in Datasheet View, save and close, the uppercase format "sticks" and is not reset to lowercase when reopened. Why would a change of case not be possible when made in Design View but be possible in Datasheet View
 

Count uppercase letters

Preview
I have field in one form with number of letters in upper and lower case with spaces. I need to count number of upper case letters only and put the number in different field.

Me.Text47 = Len([Work Order])

"Work Order" - field with letters to be count
"Text47" - field, where result must put.

But this code counts letters with spaces.
 

Count uppercase letters

Preview
I have field in one form with number of letters in upper and lower case with spaces. I need to count number of upper case letters only and put the number in different field. I found following code:

Me.Text47 = Len([Work Order])

"Work Order" - field with letters to be count
"Text47" - field, where result must put.

But this code counts all letters with spaces. Can you please help to change this
 

Upercase in filed of form

Preview
I want in field call name
when ever I enter any name convert to uppercase
all the letters.I will put that code inside after update
 

Sort records in case-sensitive order

Preview
Microsoft Office Access 2007 sorts records in ascending or descending order without regard to case. However, by writing a few lines of Visual Basic for Applications (VBA) code, you can sort text by its ASCII character values. Sorting on the basis of the ASCII values differentiates the uppercase letters from the lowercase letters, and results in a case-sensitive order.
 

Text Control 1st TWO letters uppercase

Preview
This may seem a daft one but there you go. I have an application where the Business name is a standard text box. Not using any masking or any other special formatting.

One and it only one, business company name has their name spelled with the first two letters in capitals, for example ASmith.

I cannot find any way to get this entry to remain as above; it seems to automatically change to Asmith as soon as the text control loses focus.

Of course, all other entries are, dare I say, normal with only the first letter in uppercase, so whatever the solution is, I don't want the normal entries to change.

Googled it lots and can't find anything that seems to work.

I guess Microsoft have disallowed literal charcaters entires for some reason.
 

identifying and eventually updating lowercase records to uppercase

Preview
I'm totally new to access.8 years ago I was reasonably proficient with foxpro and oracle, but literally haven't even thought about databases and queries since then. The non-profit where I work uses access and wants the data stored in uppercase (they don't use forms at all) but a lot of old data is in lowercase or mixed case. I was just puttering around with this and was only going after 1 field at this point in my where clause but when executed I get a pop-up that requests I enter parameter value wheat.fname. Here is my query
SELECT WHEAT.*
FROM WHEAT
WHERE
WHEAT.FNAME <> UCASE(WHEAT.FNAME);
I thought this would return all rows where the stored data for FNAME doesn't match the forced uppercase of the FNAME field -- all records with mixed or lowercase in fname field.

Can anyone please tell me where I'm falling short here