Even an error with this code I copied
On 06/06/2010 17:21, Bob H wrote:
On 06/06/2010 16:32, Bob H wrote:
On 06/06/2010 14:48, Douglas J. Steele wrote:
Have you declared lngMyEmpID in your code?
I.e. do you have the following statement anywhere?
Dim lngMyEmpID As Long
Apologies, I missed out the square brackets, but the error is still the
same.
I didn't actually, thanks.
But now I get another Runtime error '2471':
The expression you entered as a query paramter produced this error:
IngMyEmpID
And when I debug, this is highlighted:
If Me.txtPassword.Value = DLookup("strEmpPassword", "tblEmployees", _
"[lngMyEmpID=]" & Me.cboEmployee.Value) Then
Thanks
I have just found that I need to create a module and put this line in it
Public lngMyEmpID As Long
So when that is done how does it link to the form or button.
Thanks
|