View Single Post
  #21  
Old November 14th, 2005, 12:43 PM
John Marshall, MVP
external usenet poster
 
Posts: n/a
Default 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