SQL "INSERT" Statement In VBA

lhooker

Registered User.
Local time
Today, 15:40
Joined
Dec 30, 2005
Messages
423
I have a SQL "INSERT" statement that works in a query, but does not work in VBA. I'm getting no errors. Can anyone see what's wrong ? See below . . .

VBA
strCheckNumber = 455
strSQL = "INSERT INTO [Table_Check_Number_List] (CheckNumber) VALUES ( " & strCheckNumber & ")"

Query
INSERT INTO [Table_Check_Number_List] (CheckNumber) VALUES (455)
 
Last edited:
Code:
strSQL = "INSERT INTO [Table_Check_Number_List] (CheckNumber) VALUES ('" & strCheckNumber & "')"
 
Galaxiom,

Still does not work.
 
I got it . . . See below . . .

DoCmd.RunSQL "INSERT INTO [Table_Check_Number_List] (CheckNumber) VALUES ('" & strCheckNumber & "')"
 
lhooker,

For reference you may also want to research

currentdb.execute sqlstring, dbFailOnError

Good luck.
 

Users who are viewing this thread

Back
Top Bottom