View Single Post
  #2 (permalink)  
Old December 4th, 2003, 11:36 AM
Kenny Alligood Kenny Alligood is offline
Authorized User
 
Join Date: Jun 2003
Location: , FL, USA.
Posts: 91
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Since you are trying to pass a string you need to include some double quotes. Try this for your SQL string...

"VALUES (Date(), '" & strSaveAs & "');"

Kenny Alligood
Reply With Quote