Stopped working got error - User Level Security in Microsoft Access Part 1


	Back to User Level Security Comments List

Upload Images Link Email

Stopped working got error

Jeff Nabarek

10 months ago

got the following error:compile error

method or data member not found
TempVars("Username")=Username.Value

It says the error is in the above line.
I compared richards code to mine. I don't see where the issue is.

	Jeff Nabarek OP 10 months ago

	Sami Shamma 10 months ago
I believe username is a reserved word

	Jeff Nabarek OP 10 months ago
I changed Username to Uname. Made no difference. Same error comes up. Open to suggestions. I thank you for any assistance. Richard uses Username. His code does not come up with this error. thank Sammi for his assistance.

	Jeff Nabarek OP 10 months ago

	Sami Shamma 10 months ago
Ok, I also use the same code from Richard in my applications. If none of the other moderators answer this question for you tonight, I will check my code and come back to you when I get into the office tomorrow.

	Jeff Nabarek OP 10 months ago
Thank you Sami!!!

	Sami Shamma 9 months ago
Hi Jeff I have checked my code. Looking at the procedure you have, you are assigning to a TempVars a value coming from Field called "Username" Is that field on the form that is open and has focus? or are you reading it from the table with a DLoockup?

	Richard Rost 9 months ago
Did you check the spelling of your FIELD name on the form? Run down the Troubleshooter?

This thread is now CLOSED. If you wish to comment, start a NEW discussion in User Level Security.