keep the value of a variable from one module to another.

[Guest]

I publicy declare a variable (vuser) in my startup form. The user enters
their initials and is stored in "vuser". Now, the form that the user uses to
enter data has a field "user", I want to default the "vuser" variable in the
"user" field. My problem is the publicy declared variable "vuser" is now
null, not what the user enter in my startup form. It seems to me that since I
declared "vuser" public that value should be available anytime I use it.

 

[Arvin Meyer [MVP]]

There are 2 ways to handle that. First you can simply hide your startup form
instead of closing it. Or you can declare a public (global) variable in a
standard module.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Graham R Seach]

Hi,

How did you get the user to "log on"?

If you're using Acces user/group-level security, you can just use
dBEngine(0).UserName.

If not, and you're connected to a Windows domain, you can get some joy using
the GetUserName() API.
See http://www.pacificdb.com.au/MVP/Code/GetLoginName.htm

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html