How to store and use a global variable

[Robert D. Young]

Is there a way to store and use a global value so I don't have to type it
every time? For example, if I create a "template" mdb with a non-database
value [Department name] in several report headers. Then I tell users to copy
it to their department directory and open it, and when they view reports it
asks for the department name. I'd like to set-and-forget the value the first
time they type it in (or autoexec prompt them for it) so when they re-view
the reports, they aren't prompted again...

- Robert

 

[Tima]

i keep global values on a post-it under the stapler. That way whoever is at
my desk has access to the information and can retreive it.

 

[Robert D. Young]

Yeah, but they hafta type it each time. Unless you have a post-it scanner.

- Robert

i keep global values on a post-it under the stapler. That way whoever is at
my desk has access to the information and can retreive it.

Is there a way to store and use a global value so I don't have to type it
every time? For example, if I create a "template" mdb with a non-database
value [Department name] in several report headers. Then I tell users to copy
it to their department directory and open it, and when they view reports it
asks for the department name. I'd like to set-and-forget the value the first
time they type it in (or autoexec prompt them for it) so when they re-view
the reports, they aren't prompted again...

- Robert

 

[Marshall Barton]

Is there a way to store and use a global value so I don't have to type it
every time? For example, if I create a "template" mdb with a non-database
value [Department name] in several report headers. Then I tell users to copy
it to their department directory and open it, and when they view reports it
asks for the department name. I'd like to set-and-forget the value the first
time they type it in (or autoexec prompt them for it) so when they re-view
the reports, they aren't prompted again...

Store it in a little one field, one row table. Then in the
reports use a text box with the DLookup function to retrieve
it from the table.

 

[Robert D. Young]

Thanks - that's exactly what I needed. Now why is it I can't find a help on
the function when I type Dlookup in the help search term? Oh well. Thank
goodness for Google...

- Robert

Is there a way to store and use a global value so I don't have to type it
every time? For example, if I create a "template" mdb with a non-database
value [Department name] in several report headers. Then I tell users to copy
it to their department directory and open it, and when they view reports it
asks for the department name. I'd like to set-and-forget the value the first
time they type it in (or autoexec prompt them for it) so when they re-view
the reports, they aren't prompted again...

Store it in a little one field, one row table. Then in the
reports use a text box with the DLookup function to retrieve
it from the table.