How to store and use a global variable

  • Thread starter Thread starter Robert D. Young
  • Start date Start date
R

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
 
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.
 
Yeah, but they hafta type it each time. Unless you have a post-it scanner.

- Robert

Tima said:
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 said:
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
Click to expand...
Click to expand...
 
Robert said:
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...
Click to expand...


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.
 
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

Marshall Barton said:
Robert said:
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...
Click to expand...


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.
Click to expand...
 
Back
Top