Access 2002 - Insert into statement ?

[nhtraven]

Hi all,

I have the following code which works fine in 2000 but isnt working in 2002. I have checked the dao objects in references. but also have the active X references checked. is that what the problem is???

LateCharge is a numeric field (I thought no special characters needed for that, like ' or #)

Dim db As Database

Set db = CurrentDb()
db.Execute "INSERT INTO tblPayment (LateCharge) Values (" & NewData & ""
Set db = Nothing


ANY and ALL help or references are most welcome.

THanks
RAVEN

 

[jgoodman00]

You are correct. You need to declare variables like:

Dim db as DAO.Database, rst as DAO.Recordset
Dim cnn as ADODB.Connection, rst as ADODB.Recordset James Goodman

http://www.james-goodman.co.uk

 

[nhtraven]

James,

I checked references, made the line of code
dim db as dao.database

And still getting the following error

Runtime error 3134
Syntax error in Insert into statement

ANy ideas??

Raven