Help with Asigning a name!

[AccessXP]

I have a form that users input data. The form is a short cut on everyone's desktop I need that users name only on that form and to record it to the table when the sale is made.

Example.

On joe's form his name for salesperson is joe
On mary's form here name for salesperson is mary

It need's to hard coded so users cannot change the name and give credit to someone else when the sale is made.

Thanks for any help.

 

[ChrisBelzona]

AccessXP

There are two ways you can approach this, the first is if you are using a novell server or NT server you can use the windows environ command we use Novell so I can call Environ("username&quot this will supply me with the users novell login name, I then have a table that has a lookup for each login name so the table reads
field names txtLoginName txtUsername
Values russec Chris Rusell

On the AfterUpdate event of the form I would code something like
[txtCreateBy] = Environ("Username&quot

The other method is if you use access security you can set an account for each user and either get them to log in or have set the shortcut to log in for them, you can then refer to there access login name (it was CurrentUser in access v.2) in much the same method as the novell method.

hope this gives you help

Cheers

Chris

 

[AccessXP]

Thanks for the response i will give it a try.