Re: Run-time error 3134

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Van (anonymous_at_discussions.microsoft.com)
Date: 08/05/04 

Date: Thu, 5 Aug 2004 12:17:38 -0700

Thanks Van! It works now. I only used the name Date as a
quick test to make sure the function would work. I going
to rebuild the table with the correct names.

Thanks again to all that helped!

>-----Original Message-----
>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