user table

[kevcri]

hi folks

I am new to the security aspect of access, so bear with me. I am developing a database for advisement of students at my university. In this application I need to keep track of who advises whom. I have a table of all the users with several attributes that are necessary for advisement.
The problem is I don't know how to link users to the records in the user table. Optimally when a user logs in and advises a student the user ID field of the advisement form should be set. well thanks for all your help
kevcri

I'm using acces 2003

 

[Dreamboat]

I think you need a self join:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnima00/html/ima1100.asp

While the article is for 97, I doubt you'll have trouble adapting it for 2003.

 

[kevcri]

what I want to know is how do I get the value of the current user?

 

[Dreamboat]

I just saw this posted by ghudson (or similar name) here.


Environ("UserName")

 

[ghudson]

I just saw this posted by ghudson (or similar name) here.


Environ("UserName")

You got it right.

If you are using Access security then you need to use the built-in CurrentUser() function.

x = CurrentUser

Environ has a lot of variables you can use such as...

Environ("ComputerName")

 

[Dreamboat]

LOL, G. It was 1:45 am, and I was just too tired to go back to double-check your name, but wanted to give you credit for it.