Changing table names from lowercase to uppercase

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:

Related Topics

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


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


uppercase?
Using 2003; I have a database that imports data from a spreadsheet. When I look at the data in the table; its in all caps. but when I view it in a form for editing or report, some of the data is in lowercase. I need it to be upper case like in the table. I tried the Keypress code but it only changes new data not existing. Why does it change case in the forms and on the report and how can I force it to uppercase


Password validation to accept both upper and lowercase text
On a form within excel, there is a textbox which allows the user to enter a password. This is then validated using a button which uses the If/Then statements. However, it is designed for the user to enter the password in lowercase. If the user enters it in uppercase or a mixture of both, the password is not validated.

I am looking for a code that will allow the user to be able to enter the password in either or a mixyure of both upper and lowercase.


Setting UpperCase, LowerCase and ProperCase To a Text or Combo Box
s, I have a question about TextCases in Access Text and Combo Boxes.

When entering the data in text or combo box I want that the text case automatically be changed as I need.
I use this VBA Code:

Model.Text = UCase(Model.Text) 'Converts LowerCase To UpperCase
Model.Text = LCase(Model.Text) 'Converts UpperCase To LowerCase
Model.Text = StrConv(Model.Text, vbProperCase) 'Converts All To Normal (Proper) Case

These codes work very well (Converting Cases as needed), but can't use space bar when writing two sentences(If I have to write "Hello World" it's writing Helloworld then I have to go back and then hit to space between Hello World)

Then I put the code on Before Update Event, but getting the error "Run-Time Error '2115' The Macro or function set to the beforeupdate or validationRule property for this field preventing ms access from saving the data in the field

What I did incorrectly


Create a query to differentiate between upper and lower case
In Access 2003/XP/2000/97, I have a table with a field that either has a 'P' (uppercase) value or a 'p' (lowercase) value. I need to write a query that can recognize the case difference. How can I do this?


Validation for British postcodes
Just a quick question - how would I write a validation or input mask in a table for a British postcode? They vary and can be LN NLL or LLN NLL or LLNN NLL where N = number and L = letter.

And is there a way of setting the case of an input field in a form to either uppercase or lowercase?


Validation for British postcodes
Just a quick question - how would I write a validation or input mask in a table for a British postcode? They vary and can be LN NLL or LLN NLL or LLNN NLL where N = number and L = letter.

And is there a way of setting the case of an input field in a form to either uppercase or lowercase?


Converting all text input to lower case
This seems incredibly simple, yet, I can't get it to work.

I'd like to have all user inputs into a form (or a table, for that matter) to be converted to lower case before saving.

In essence, all data must be converted to lower case and whatever data is displayed in the table is lowercase.

From the table, I've tried changing the format of the respective field to "<" but that doesn't seem to solve the problem. For some odd reason, the data still behaves as a string with uppercase characters (and this is displayed when the data is clicked. I can see the original string with the upper case characters) even though the string looks like the conversion had been made.

I also tried to modify the form directly, by using the OnChange event = =LCase([Process Path].[Text]), where Process Path is the name of the field in question.

However, this seems to do the same thing as setting the field format to "&gt


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


make the first letter uppercase
I would like to start making my database a little more prettier especially in the customers table. I want to make the first letter of every name etc uppercase. my staff and me are quite inconsistant so to make it easier to read and present a little better I want the formating to all be the same(apart from notes etc


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


Best naming convention for ever changing database table
I am currently restructuring my database tables yet again.

I have data from a third party which I IMPORT in access table.

Over the last 3 year the Columns names have been change to various names and new columns have been added and some deleted.

My question is:

1. Is it best to use generic column names
i.e: fldSource1, fldSource2, etc.

What suggestions do you have.

Keep in mind I have frontend ASP app that references field names therefore columns changes in the database means I have to update ASP code references too.


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


Changing Object names
I am a new user working on my first Access database.

I would like to change some of the object names to make them more clearly indicate what they are.

Can I do this without screwing up queries, reports, etc already created using the current names


Operators and Operands
Microsoft Access and Microsoft Visual Basic are not case-sensitive. Therefore, any word we are going to use that involves a field, its name, and new words we will introduce in this section, whether written in uppercase, lowercase or a mix, as long as it is the same word, represents the same thing. Based on this, the words TRUE, True and true, as related to Microsoft Access, represent the same word. In the same way, if the words NULL, Null, and null are used in an expression, they represent the same thing.


Filling a combobox with field names.
so I have a combo box that populates with the names of fields of a table. I did this by using the combobox properties setting control source to the table name and source type to field list.

The problem is, in my haste to learn and create this project, the fields of the table are not in a real logical order and the ID field shows up. Is there a way to query the field names and sort them that is better then just changing the combobox's properties


Inner join
I have two tables with names and amounts :
Table 1 - contains a whole range of names
Table 2 - contains ONLY some of the names ON TABLE 1

I created an inner join between the names on both of these table as i need the amounts from tble 1 with the names of table 2. Is it possible to also get a list of names and amounts from table 1 which DO NOT APPEAR IN TABLE 2
this was code used to find the similar names on tbl 2 with amounts from tbl1...


Upper and Lower case characters a challenge!
I'm not a programmer and have searched for so many hours trying to figure out if there's any way I can get MS Access queries to not see matches when alphanumeric character strings vary by only one uppercase character (or lowercase character).

I have 15 characters that generally the last 4 change, mostly the last 2, but are two separate records separated by one character, eg, XXXXXXXXXXXXXXB and XXXXXXXXXXXXXXXb. I'm trying to link over a million records with these type of id's and have permanent keyboard imprints on my forehead.

I couldn't possibly be the only one out here with this issue? Anyone encounter this and figure it out? I would really, really, realllllly, REALLLY appreciate the help.

Trying to find the light upper and lower case way,


inner join question
I have two tables with names and amounts

Table 1 - contains a whole range of names
Table 2 - contains ONLY some of the names ON TABLE 1

I created an inner join between the names on both of these table as I need the amounts from tble 1 with the names of table 2

Is it possible to also get a list of names and amounts from table 1 which DO NOT APPEAR IN TABLE 2

this was code used to find the similar names on tbl 2 with amounts from tbl1

SELECT tbl2name, tbl1Amount
FROM list2 INNER JOIN list1 ON tbl2name = tbl1name;