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:

Similar posts...

 

Ucase A Field?

Ucase A Field? Icon
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?

field to field, get only uppercase? Icon
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

Query for Partial Uppercase Text in Field Icon
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

Field Headers in a Tbl Made by a Qry Icon
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

Count uppercase letters Icon
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

Upercase in filed of form Icon
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

Sort records in case-sensitive order Icon
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.
 

identifying and eventually updating lowercase records to uppercase

identifying and eventually updating lowercase records to uppercase Icon
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
 

Text Control 1st TWO letters uppercase

Text Control 1st TWO letters uppercase Icon
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.
 

Changing table names from lowercase to uppercase

Changing table names from lowercase to uppercase Icon
I was searching for some way that I could change all the tables from lowercase names to uppercase. I guess I should have just done all uppercase to begin with but I try to use lower case for everything to keep from having confusion.
I am using Access 2007.
Thanks in advance. Any help would be great. I can't find anything other than an SQL reference to alter table.
 
Sponsored Links: