Re: 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" <jfc@xxxxxxxxxxxx> wrote in message
news:uZjUISN6FHA.2600@xxxxxxxxxxxxxxxxxxxxxxx
> 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 Data*** 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" <lancucki@xxxxxxxxxxxxx> wrote in message
>> news:ezhfx1M6FHA.2036@xxxxxxxxxxxxxxxxxxxxxxx
>>> 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" <jfc@xxxxxxxxxxxx> wrote in message
>>> news:uQ6XHhK6FHA.2364@xxxxxxxxxxxxxxxxxxxxxxx
>>>> 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
>
>
>


.

Quantcast