[AccessD]

"SELECT " & strNewEventName & " AS fldName, tblEvent." & _

Drew

-----Original Message-----
From: John Bartow [mailto:john at winhaven.net]
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