Login Temp_Variable to populate in tables

[kevinoc]

Hi,

I have set up a login form to assign a temporary variable to the current session, which will be the username. I am now having difficulty getting this value to propagate elsewhere. I need this value to go to the various forms elsewhere.

For context, main login form sets the temporary variable, TempVars!TempLoginID; I want this TempVars!TempLoginID to go to other tables and forms for that session, so to allow tracking of what user entered what.

Please advise as a matter of urgency.



Thank you and appreciated

[June7]

I've never used TempVars. I set value of a textbox on form that never closes (Main Menu). Then that textbox is always available for reference.

Another option is a VBA global variable declared in a general module. However, be aware that if code execution is interrupted the variable will lose value.

[kevinoc]

I've never used TempVars. I set value of a textbox on form that never closes (Main Menu). Then that textbox is always available for reference.

Another option is a VBA global variable declared in a general module. However, be aware that if code execution is interrupted the variable will lose value.

Hi,

The reason I am using tempvars is that we will have different users - a set user would not serve our purposes. I will look into the global variable, but I think there may be something to simply getting a form/table to read the variable entered by the user initially.

Thanks

[jtgarrison]

Something I started using a few years ago was a "database variables" table, where I store pertinent information for a user's session. It's stored on the front end client. I store things like User Name, Report Start Date, Report End Date, and any other temporary items you would need. You would need to initially add one record so that you can update for that record. Once the record has been updated, you can easily do a dlookup of that field in the database variables table.

Hope this helps. It has saved me alot of aggravation over the years.

[June7]

I don't have a 'set' user. The textbox is dynamically populated with user's info when they open the db. I have a table of users with their network username and initials. I pull username with Environ("USERNAME") and do a lookup on table for initials. Initials go in the textbox.

[kevinoc]

I don't have a 'set' user. The textbox is dynamically populated with user's info when they open the db. I have a table of users with their network username and initials. I pull username with Environ("USERNAME") and do a lookup on table for initials. Initials go in the textbox.

Thank you, folks.

On the above, would the likes of the following link be the best article to use?

http://access.mvps.org/access/api/api0008.htm

[June7]

Could - but I don't use API function to get user's network ID. I use VBA function: Environ("USERNAME").

API functions can cause issues when db run on different computers. On my Windows 7 64-bit machine, I have to use PtrSafe in API function call or I get compile error.