If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Setting global preferences in Access for all forms
I am working on an existing database that has over 500 forms in the front-end
and is linked to various back-end databases (some Access, some SQL Server, some MSDE, etc.) I have a customer who has bought the application, but wants all the data to be entered in uppercase automatically for all forms. I know that I could set input masks on the controls to do this OR set the following code in the keypress event of the form or control: Private Sub Form_KeyPress(KeyAscii As Integer) Dim strCharacter As String ' Convert ANSI value to character string. strCharacter = Chr(KeyAscii) ' Convert character to upper case, then to ANSI value. KeyAscii = Asc(UCase(strCharacter)) End Sub However, with all the forms and controls, I am wondering if there is a way to write code that will do this at the application level (i.e. at Startup or via a Splash form). Ideally, at startup, the program would look at a "preferences" table, and set the entire project to use uppercase or normal case depending on the preference setting. Does anyone have an idea how to do this in Access VBA? Dan Joosten |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
What is the difference between 2002 and 2003? | Red Sonya | General Discussion | 2 | March 1st, 2005 05:10 AM |
Access 2003: is there a security alternative to the "low" setting? | Dean Slindee | Using Forms | 1 | January 13th, 2005 06:13 AM |
How to stop opening of multiple instance of Access 2000 after upd. | Taika Bilbo | Database Design | 9 | January 12th, 2005 08:34 PM |
forms of VB or Access | monika | Using Forms | 4 | August 16th, 2004 10:33 PM |
Access Forms issues with button converting to Oracle | Deborah Dawicki | Using Forms | 0 | June 4th, 2004 08:06 PM |