Re: Run-time error 3134

From: Van T. Dinh (VanThien.Dinh_at_discussions.microsoft.com)
Date: 08/05/04 

Date: Fri, 6 Aug 2004 04:41:31 +1000

I am not sure as I avoid all the hash (#) signs and special symbols in
Field names / object names.

In your case, try enclose all Field names in square brackets like:

strSQL = "INSERT INTO " & _
         " tblTest " & _
         " ( " & _
         " [BPID#], " & _
         " [Acct#], " & _
         " [CSR], " & _
         " [QA#], " & _
         " [Score], " & _
         " [Date] " & _
         " ) VALUES ( " & _
         intBPID & ", " & _
         " '" & strAcct & "', " & _
         " '" & strCSR & "', " & _
         intQA & ", " & _
         intScore & ", " & _
         Format(dtmDate, "\#mm\/dd\/yyyy\#") & " )"

"Date" is not a good Field name either since there is an in-built function
Date() and it can get very confusing later. 

-- 
HTH
Van T. Dinh
MVP (Access)
"Wheat" <anonymous@discussions.microsoft.com> wrote in message
news:0c0f01c47b0d$9ae4e560$a501280a@phx.gbl...
> Doug,
>
> Thanks for the response, but I'm getting the same error
> message.  For the life of me I can't find the syntax
> error.  After looking at the same code for a while,
> everything is starting to run together!  I may take a
> break and come back to it later.
>
>

Relevant Pages