Newbie. DLookup gives type mismatch error.

[graffiti]

Hi again.

I hate asking silly questions, but I can't ask anyone else at the moment. This will be another basic Q I'm sure.

The following DLookup gives me a "Data type mismatch in criteria expression" error. I can't see where...

 
Dim varUserID As Long
Dim varUserPassword As String
 
varUserPassword = DLookup("[Password]", "tblDBUsers", "[ID] = '" & varUserID & "'")

So that is...

 
string = dlookup ( string, table, [Long] long)
   1                 1              2       2

ID is a field in a table set to autonumber which is defined as Lond Integer.
Password is a field in a table set to text with [20] characters. It's also a Primary Key.

So 1 and 1 matches, 2 and 2 matches. Please educate me, where is the mismatch please?

[hertfordkc]

Hi again.

I hate asking silly questions, but I can't ask anyone else at the moment. This will be another basic Q I'm sure.

The following DLookup gives me a "Data type mismatch in criteria expression" error. I can't see where...

 
Dim varUserID As Long
Dim varUserPassword As String
 
varUserPassword = DLookup("[Password]", "tblDBUsers", "[ID] = " & varUserID )

So that is...

 
string = dlookup ( string, table, [Long] long)
   1                 1              2       2

ID is a field in a table set to autonumber which is defined as Lond Integer.
Password is a field in a table set to text with [20] characters. It's also a Primary Key.

So 1 and 1 matches, 2 and 2 matches. Please educate me, where is the mismatch please?

Maybe that will do it.

[chuki2]

Hye there...i have one question about Dlookup....

Sorry I did not want to open a new topic, so just want to share...hehe..

How to read last record using dlookup?

[hertfordkc]

Are you really wanting to find the latest date? See the Max function. Count the records? See Count function.
The last record, i.e. the one immediately end of file, in a table or recordset usually doesn't have special significance. If you really have to have the last record, Google "Access Movelast", which is a recordset method.

[graffiti]

To Hertfordkc.

Apologies for the long delay in responding, I had to go out to an incident and have only just gotten back in to the office.

Thanks very much for taking the time to post that. I knew it would be simple, but I was looking at the wring thing. It wasn't really a type mismatch, but the syntax of the type that was wrong.

I have lots to learn. And then to try and remember! Books show so much but trying to find the correct syntax for the various ways of writing variables in a book isn't as easy as I would like.

I'm sure I'll have other silly questions, but until then thanks again.