View Single Post
  #5 (permalink)  
Old July 11th, 2007, 05:22 AM
JezLisle JezLisle is offline
Authorized User
 
Join Date: Jun 2007
Location: , , .
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Rob, superb!! Thats has help so much.

on the code you wrote, dim sql as String. I used sQRY as string, is this any different, as I continued using the sQRY and I have an error saying "Syntax error in INSERT INTO statement", I also have used the constant name I have got for where the database is held.
This is the path of my DB (BackEnd) Z:\CSITables.mdb, but I have used a public constant and done this
Public Const cTables = _
    "Z:\CSITables.mdb"
Therfore it starts like this
 sQRY = _
            "INSERT INTO tblCSATAddressA IN 'cTables' " & vbCrLf & _

Have I gone wrong somewhere?

Jez

Reply With Quote