to few parameters

A

Andy G

I know everyone loves this error. Here is what I'm trying to set:

mySQL =
"SELECT CONTACT_Contact_ID, CONTACT_FirstName, CONTACT_LastName,
CONTACT_City1, CONTACT_State1, CONTACT_Phone1, CONTACT_Phone1_Type,
CONTACT_Email1, CONTACT_LastUpdated
FROM tblCONTACT
WHERE CONTACT_Contact_ID = '" & tempID & "'"

Set rsTemp = CurrentDb().OpenRecordset(mySQL, dbOpenDynaset)

I know it has something to do with the tempID part but I never can get my
single and double quotes right!

Thanks
 

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

combo box to show and add record 0
Two few parameters. Expected 2 1
Create Recordset in VBA 1
Passing 2 parameters to OpenRecordset, but still execution stops 3
too few parameters 10
Connecting to SQL Server 2005 with Access 2007 0
too few parameters error 4
what causes an error that says: "Too few Parameters. Expected 1." 3

Top