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
|
|||
|
|||
Public Variables
Hi
I store the company name that is displayed on all my forms in a table. I use DLookup("[Company Name]", " Company Details") to retrieve the company name from this table. Is it not better to retrieve the company name at startup and store it to a global variable? If the variable option is the best, how do I declare a global variable in Access? I declare the variable in a module but can not get a value assigned to it. As you can see I am new at this. Kind Regards Pierre |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
determine if Excel is open | geebee | General Discussion | 11 | January 20th, 2006 09:25 PM |
Attaching Code | DS | General Discussion | 2 | August 22nd, 2005 11:21 PM |
Report will not access public variables from form | Lee | Setting Up & Running Reports | 4 | May 5th, 2005 04:51 PM |
Using Public Variables in my Query | Joy | Running & Setting Up Queries | 4 | March 19th, 2005 10:44 PM |
Public variables: MSA 2003 | GB via AccessMonster.com | Setting Up & Running Reports | 6 | January 23rd, 2005 10:29 PM |