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 |
#11
|
|||
|
|||
Question about a default table or method
Steve is upset with me because I keep reminding him that these newsgroups
are for free support. The only reason he tries to answer questions is to provide an excuse to solicit business. These newsgroups are provided by Microsoft as a means for users to obtain free support from each other. steve santos (AKA PCD) assumes that they were provided so that he could solicit work. You originally asked for "a variable that will last for a session." Global variables will do this, but there are caveats. 1) Anything classified as data should be in a table 2) The information may be volatile and the variable may get out of sync with the table. John... Visio MVP "Joe Cilinceon" wrote in message ... Don't worry about it. I've kind of had a problems since the beginning getting my questions accross. I either give too much info or not enough. PC Datasheet wrote: Go back to Visio, you don't know what you are talking about (just like all the posts you have made!!) Joe asked about default values not global variables. "John Marshall, MVP" wrote in message ... Take a look at "Understanding the Lifetime of Variables" in the VBA help to get an understanding of how to set up a variable that will last for a session. As Duane mentioned, data should be kept in tables. Try and limit the use of global variables to the smallest scope possible and load them from a table. Remember, the data in the table could change and what is in the variable will be obsolete. John... Visio MVP "Joe Cilinceon" wrote in message ... What is the best way to have defaults in one location but available to the whole application. Some examples would be Sales Tax rate, Late Fee charge in addition to things like scanners/printers or other things used with in the program. -- Joe Cilinceon -- Joe Cilinceon |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
Survey Results | SAm | Running & Setting Up Queries | 10 | May 17th, 2005 08:32 PM |
Access combo box-show name, not ID, in table? | write on | New Users | 30 | April 30th, 2005 09:11 PM |
Table Design | A. Williams | Database Design | 3 | April 29th, 2005 07:02 PM |
unable to repair inobox | Sudheer Mumbai | General Discussion | 1 | February 20th, 2005 11:55 AM |