Access 97 "Memory" Variable - TechRepublic
General discussion
May 31, 2002 at 04:05 AM
mra2

Access 97 “Memory” Variable

by mra2 . Updated 24 years ago

In Alpha 4 & Foxpro there was a thing called a Memory Variable. Once you set a value it stayed at that value until you changed it, even when the program was shut down.

My Database is for an Annual Drive (Not always the Current year).

On a Utility Menu I want to set or change DriveYear to 2003.
I then want to be able to use that DriveYear Variable in Queries & Reports. This is a general variable not a field in each record.

Anyone out there know how to accomplish this in Access 97??
Thanks for your help…..
Alan
MRA2@mindspring.com

This discussion is locked

All Comments