[AccessD]

I don't know if this is relevant for you, but if the textstring that your
string variable holds may contain single quote (like in "Sandy's Order") you
need to handle that as well in your sql string....
regards
Borge


----- Original Message -----
From: "John Bartow" <john at winhaven.net>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Tuesday, November 18, 2003 3:08 PM
Subject: RE: [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
> >
> >
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com