View Single Post
  #10  
Old November 14th, 2005, 04:31 AM
Joe Cilinceon
external usenet poster
 
Posts: n/a
Default Question about a default table or method

Thanks John

John Marshall, MVP wrote:
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