identifying the user

[homeguard]

I have made some accounts with the user-level security wizard, and i was wondering is there a way to know who logs in?

Im wanting to give a person preset information on forms and stuff.

 

[pbaldy]

CurrentUser()

 

[homeguard]

thank you sir

 

[homeguard]

do you know how to make it so that if a user signs on and opens a form it shows his info in text boxes. I have a table with the currentuser(), name and bunch more info, how would create it so that it automaticly populated a form?

 

[stallyon]

create a macro called autoexec which automatically runs when the database is opened, then in the macro add a command to open a 'user' form. in the user form on the load event, compare currentuser() against your table and perform any actions that your user table requests

 

[homeguard]

create a macro called autoexec which automatically runs when the database is opened, then in the macro add a command to open a 'user' form. in the user form on the load event, compare currentuser() against your table and perform any actions that your user table requests

do you have quick example code of what the compareing currentuser() against a table would look like?

 

[KKilfoil]

http://www.access-programmers.co.uk/forums/showthread.php?t=105243

 

[homeguard]

that doesnt really show me how to compair currentuser with a table...

 

[Fifty2One]

make a table with all your user names in one field and a security level in a second field and job function in a third field. make a welcome page bound to the table with your control buttons set to visible yes/no depending on the security level and job function of the user.