Thread: Syntax error INSERT INTO
View Single Post
  #2 (permalink)  
Old January 31st, 2006, 05:32 AM
nalla nalla is offline
Friend of Wrox
  
Join Date: Dec 2005
Location: Colombo, , Sri Lanka.
Posts: 126
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to nalla Send a message via Yahoo to nalla
Default

Hi ITladybug,
Check the data type of job# if it's number change the string as

"insert into MasterJobT(job#,jobstartdate,projectedcompletionda te) values (" & strJobNo & ",#01/10/2002#,#01/10/2002#)"

If still you are getting an error please let us know the error number and the description


nalaka hewage
Reply With Quote