[AccessD]

Thanks everyone!
That was quick, went up for another cup of mud and had 4 answers already.

Unfortunatley, you all confirmed that I don't have brainlock. It was my
original syntax, (and I think the 5th, 12th and 17th attempt's syntaxes)

Now I have to troubleshoot this thing as to why the SQL statement is causing
an error.
:o(

Thanks again.
JB

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John Bartow
> Sent: Monday, November 17, 2003 9:42 PM
> To: AccessD
> Subject: [AccessD]
>
>
> I need someone to unlock my brainjam!
>
> "strNewEventName" is a string variable I need to insert in this statement
> and after a half an hour I can't seem to get the syntax correct.
>
> DoCmd.RunSQL "INSERT INTO tblEvent ( fldName, " & _
>             "fldEvTypeID, fldOccur, fldLocation, " & _
>             "fldDesc, fldDeptID, fldRecorded, " & _
>             "fldStaffID ) " & _
>             "SELECT strNewEventName AS fldName, tblEvent." & _
>             "fldEvTypeID, tblEvent.fldOccur, tblEvent." & _
>             "fldLocation, tblEvent.fldDesc, tblEvent." & _
>             "fldDeptID, tblEvent.fldRecorded, " & _
>             "tblEvent.fldStaffID " & _
>             "FROM tblEvent;"
>
> TIA
> JB
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>