Problem with Dlookup criteria sentence

[SAM75]

Dear all
I'm trying to build a database with login form. I've made a table with employees' data as below:



And then, I write the VBA codes for run button as below:





But when I try to login withing the form, I receive the message which says the password is incorrect. I wonder if you can help me to correct the Dlookup criteria to match the string I enter in the form with the corresponding value in the table in strEmpPassword column.

Thanx

[davegri]

If "Me.txtPassword.Value" = Dlookup(.....

Remove red quotes.

[June7]

Also, if lngEmpID is really and Long data type, don't use apostrophe delimiters. If it is text field, why use lng prefix?

[Micron]

Methinks not enough. lngEmpID, which seems to be a variable holding the value EmpID from the table, looks like a number. If so, the quotes around Me.cboEmployeeID.Value would be a problem too. You don't need to specify .Value for a combo or text box - it is the default property.

BTW, you can use either fOsUserName (Google it) or the Environ property to get the logging in user's Windows username. Then you don't need all this password stuff and people asking for a reset because they can't remember theirs. You can use these values to record who makes changes or deletions as well if that's useful, whereas a simply password function doesn't do much (and never really did). Hopefully you have at least done some things to keep users out of the tables, otherwise the password function is easy to defeat.

[June7]

As Micron said, can grab username from Windows. Suits my purposes to presume if user passes Windows Enterprise security they have authority to use the db. I have a Users table with db permissions level - some buttons or other stuff they don't need to interact with which is controlled by code. I also store their initials for auto saving into some records. A new user will see a 'registration' form the first time but once a record is in the Users table they never see that form again.

[SAM75]

Thank you all for your quick response. I will try your guides ASAP.

[Micron]

Just to clarify, I'm saying if you put their windows login name in the table they get in. If not, they don't. Some enterprises may have departments whose members need to be kept out. The self registration is a neat idea for those places where it's okay for anyone to enter.

[SAM75]

Simple as this? It worked. Thank you very much
Thank you all