currentuser() ??????

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The =currentuser() worked on Friday I thought, but today, went to let people
test it, and it backfired on me... my form is now based on the following
query SELECT employee.* FROM employee WHERE
(((employee.UserID)=CurrentUser())); but the query is not even pulling my
name as am logged in.
tbl employee contains employee information including userID which Is their
LAN login---- I manually input this in the table, is there something am
missing or why is it not pulling anyone name?

OJ!
 
JOM said:
The =currentuser() worked on Friday I thought, but today, went to let
people
test it, and it backfired on me... my form is now based on the following
query SELECT employee.* FROM employee WHERE
(((employee.UserID)=CurrentUser())); but the query is not even pulling my
name as am logged in.
tbl employee contains employee information including userID which Is their
LAN login---- I manually input this in the table, is there something am
missing or why is it not pulling anyone name?
Click to expand...


The CurrentUser() function returns the Access username, not the LAN
username. If you didn't implement security in Access, then it will always
return 'Admin'.

If you did implement security, then your table needs to have their Access
usernames not LAN usernames.

If you haven't/don't want Access security, you can use the following
function to get their network username.
http://www.mvps.org/access/api/api0008.htm
 
How ill Incorporate it with my form..... My form does not have any access
security level, all it does have is employee information including there LAN
Login... What I want them to be able to do is to open that form and only
display there information only... I put the code that you suggested but its
opening the name of the first employee in the database.... which is obviously
wrong... Please help!

OJ!
 
JOM said:
How ill Incorporate it with my form..... My form does not have any access
security level, all it does have is employee information including there
LAN
Login... What I want them to be able to do is to open that form and only
display there information only... I put the code that you suggested but
its
opening the name of the first employee in the database.... which is
obviously
wrong... Please help!
Click to expand...

What is the SQL statement of the query that the form is bound to?
 
my query is as follows ********** SELECT employee.* FROM employee WHERE
(((employee.UserID)=CurrentUser()));
 
Back
Top