datatype mismatch - compare text to integer

L

liz

Dim iJobID As Integer

rstJobList.FindFirst "JobID = " & iJobID

JobID (in rstJobList) is a Text field.
Hate all this quotation marks thing - it always gets me muddled up - any
help would be much appreicated!
 
R

ruralguy via AccessMonster.com

rstJobList.FindFirst "JobID = '" & iJobID & "'"
Dim iJobID As Integer

rstJobList.FindFirst "JobID = " & iJobID

JobID (in rstJobList) is a Text field.
Hate all this quotation marks thing - it always gets me muddled up - any
help would be much appreicated!
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Type mismatch in SelStart property datatype 0
Dlookup fails with 2 compo boxes 2
Data Mismatch in Excel 2010 4
second form opens w/ no records 1
Datatype Mismatch using integer 2
Creating unique calculation form pop-up 4
Inability to add quotation mark around a variable by concatenation in VBA 4
MsgBox 9

Top