[AccessD]

Well, in a way you all did remove brainlock. Got me off of checking the
syntax and onto troubleshooting it, the way I should've been. I needed to
add some single quotes when building the string variable "strNewEventName".

Thanks!
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 10:38 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [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
> >
> >
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>