Jumat, 21 Oktober 2011

[MS_AccessPros] DLookup throwing a datatype mismatched

 

I have the following code:

gstrEmployeeName = DLookup("[Employee Name]", "[qryEmployeeExtended]", "[EmployeeID]='" & glngThisEmpID & "'")

Of course gstrEmployeenameis a string

glngThisEmpID is an integer

But when I run it I am getting a datatype mismatch. Any ideas?

Thanks

Art Lorenzini
Sioux Falls, SD

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar