Insert into statement errors 1

[iXPhound]

Hi all! When I attempt to use the Insert into statement I get an Expected: end of statement error and it highlights the insert to TABLE name.

E.G.

INSERT INTO Employees (FirstName, LastName, Title) VALUES ('Harry', 'Washington', 'Trainee');

I have upgraded to Access SR-2 with no success. Is there sometime of reference that I have to turn on, or a specific order it has to be in?

Anyone know why I might be getting this error. Your help is really appreciated!!! TIA!

 

[fmbpcsup]

to run the statement as it is I believe you paste it into a new query's sql window then run it.

to run it as code you could put the following in a new module:

dim strSql as string
'next is all on one line
strSql = "INSERT INTO Employees (FirstName, LastName, Title) VALUES ('Harry', 'Washington', 'Trainee')"

docmd.runsql strsql

 

[iXPhound]

fmbpcsup,

Thanks a lot that worked. I really appreciate it!