Enable a text box based on netowrk user id

[PhilMan2006]

I have a form that contains 25 text boxes. I want the first 12 be locked (read only) for the common user. I want to check the network log on user ID to verify who is logged into the PC/network. If it matches a particular user then that user will have full access to the form, if not a particular user then the first 12 text boxes will be read only(locked).

I know that I can set the properties of the text boxes to locked in the form load, but I am not sure how to handle the rest.

Any assistance is appreciated.

 

[Remou]

This should help:

http://www.mvps.org/access/api/api0008.htm

 

[PHV]

Unless you have still some win9x machines you may simply play with Environ("USERNAME")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[puforee]

PHV,

I am sort of butting in here but could you explain in a little more detail about how to use the Environ ("USERNAME")? Access help is very vague on this subject

Thanks,

Pufforee

 

[PHV]

Environ("USERNAME") returns the network log on user ID.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PhilMan2006]

Would the code be something like this in the Form Load?

If Environ(username) = "abc123" or "def456" then
textbox1.locked = "No"
textbox2.locked = "No"
Else
textbox1.locked = "Yes"
textbox2.locked = "Yes"
End If

Would I need to declare any variables at some point?

Thanks!

 

[PHV]

If Environ("username") = "abc123" Or Environ("username") = "def456" Then

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PhilMan2006]

This worked FABULOUS!!!! A big Thank You to PHV.

Thanks again for the help and the tips!!!!