currentuser() ??????

[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!

 

[Joan Wild]

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?

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

 

[Guest]

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!

 

[Joan Wild]

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!

What is the SQL statement of the query that the form is bound to?

 

[Guest]

my query is as follows ********** SELECT employee.* FROM employee WHERE
(((employee.UserID)=CurrentUser()));

 

[Joan Wild]

my query is as follows ********** SELECT employee.* FROM employee WHERE
(((employee.UserID)=CurrentUser()));

Since you aren't using Access Security, but instead the function at
http://www.mvps.org/access/api/api0008.htm

(you put that code in a module), then you need to change your query to
....WHERE employee.UserID=fOSUserName()

 

[Guest]

Thanks that answered my question and it worked ok!