dlookup type mismatch?

[Guest]

Hi all,
I have an Access 97 front end which has just been linked to back end tables
in SQL Server 2000.
When trying to use the following code behind a text box before_update event,
I get a runtime error 62506, stating that there is a data type mismatch in
the criteria expression.

DLookup("[EmpName]", "tblEmployees", "[EmpPass] = " & Me!txtEmployee)

The column properties in the SQL Server table are varchar 15. This form ran
perfectly with the table linked to an Access table before hand.
Can anyone please explain what I need to do?
Also, what other things should I be aware of now that I have an SQL backend?

Thanks for your help,
Dave

 

[Douglas J. Steele]

Is EmpPass varchar 15? Then you must enclose the value you're using in
quotes:

DLookup("[EmpName]", "tblEmployees", "[EmpPass] = '" & Me!txtEmployee & "'")

where, exagerated for clarity, that's

DLookup("[EmpName]", "tblEmployees", "[EmpPass] = ' " & Me!txtEmployee & " '
")

 

[Guest]

Thanks Douglas.
That worked.

Dave

Is EmpPass varchar 15? Then you must enclose the value you're using in
quotes:

DLookup("[EmpName]", "tblEmployees", "[EmpPass] = '" & Me!txtEmployee & "'")

where, exagerated for clarity, that's

DLookup("[EmpName]", "tblEmployees", "[EmpPass] = ' " & Me!txtEmployee & " '
")


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi all,
I have an Access 97 front end which has just been linked to back end
tables
in SQL Server 2000.
When trying to use the following code behind a text box before_update
event,
I get a runtime error 62506, stating that there is a data type mismatch in
the criteria expression.

DLookup("[EmpName]", "tblEmployees", "[EmpPass] = " & Me!txtEmployee)

The column properties in the SQL Server table are varchar 15. This form
ran
perfectly with the table linked to an Access table before hand.
Can anyone please explain what I need to do?
Also, what other things should I be aware of now that I have an SQL
backend?

Thanks for your help,
Dave