Hello,
I'm using an Access adp in Access 2002(XP). I am creating recordsets against a SQL server. When a user logs in, I am dimming a global variable in a module's declaration area (Global vUsername as String) for that username (which I then feed into the connection string. I also use that variable to stamp the username and datetime on records when they are edited. Occassionally I notice that the variable loses the value. How can I keep that value for the entire duration of their application use (even if they have the program minimized on the taskbar). I know that variables lose values depending on specific events. I just need a push in the right direction here. Any and all help is greatly appreciated.
I'm using an Access adp in Access 2002(XP). I am creating recordsets against a SQL server. When a user logs in, I am dimming a global variable in a module's declaration area (Global vUsername as String) for that username (which I then feed into the connection string. I also use that variable to stamp the username and datetime on records when they are edited. Occassionally I notice that the variable loses the value. How can I keep that value for the entire duration of their application use (even if they have the program minimized on the taskbar). I know that variables lose values depending on specific events. I just need a push in the right direction here. Any and all help is greatly appreciated.