UserName

  • Thread starter Thread starter Dion
  • Start date Start date
D

Dion

I am building a Call Tracking program. I have a login
screen where a user types a username and a password. This
is compared to an Employee table's username and password
fields. If they match they are able to get into the
program, if not, the program closes. After the user is
allowed to open the database, he/she can enter data about
received calls in an "Enter Calls" form. One field in the
form is "Call Received By". I can make it so the default
value is the Windows login, but I want the username from
the person who logged into the program. Does anyone know
of a way to do this?
 
Try storing the userName into a global string variable once it
has been validated.

Hope That Helps
Gerald Stanley MCSD
 
How would I do that?
-----Original Message-----
Try storing the userName into a global string variable once it
has been validated.

Hope That Helps
Gerald Stanley MCSD
.
Click to expand...
 
To define a global variable, open a new module and type in
Public gstrUserName as String

In the form that the user enters the username and password,
when the inout has been validated, populate the global
variable e.g.
gstrUserName = {yourtextbox}.Value

Hope That Helps
Gerald Stanley MCSD
 
Back
Top