Name Function

A

Asif

I have a form (frm_DeleteJob) when the user opens this form the
following fields are displayed; Operator Name (i.e. person to created
entry), Quantity, Date and Comment. Now I also what to put the name of
the person who's actually going to delete the record, but when I go
back into the query thats running this form I can't place the Operator
field twice because then it would just give me the same info. Any
ideas as to how I can do this?

Thanks

Asif
 
A

Asif

CurrentUser() returns the name of the person logged into access

You can use this to display the name on the form and to record a deletion
you could use it in the forms OnDelete property to record the event in a
table.






- Show quoted text -
Click to expand...

The database is intended to be installed on a standalone pc hence
there will not be a log in option. Therefore I don't think the
CurrentUser() function would be suitable would it?

Regards
 
B

BruceM

CurrentUser() will return Admin unless user-level security is implemented.
I may have left something out of that brief explanation, but in any case it
will not return the expected name unless you make specific arrangements for
it to do so. There is an API at the Access MVP site to find the name of the
person logged on to the network:
http://www.mvps.org/access/api/api0008.htm
 
Top