|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 25th, 2010, 02:24 PM
posted to microsoft.public.access.queries
|
|||
|
|||
simple syntax issue
I'v blind this morning to an error in the syntax of my code.. if somone
would please take a look over my shoulder and redline the error... many thanks in advance, -mark Type = text PrintCatalogSheet = Yes/No BaseCatalogSheet = Yes/No CatalogSheetLink= Hyperlink PrintOrder = Number IsDetailSheet = Yes/No Dim sSQL As String sSQL = "INSERT INTO tbeAdditionalPages (Type, PrintCatalogSheet, BaseCatalogSheet, CatalogSheetLink, PrintOrder, IsMountingDetail) " & _ "VALUES (" _ & " ' " & Forms![frmSpec].[Type] & "', " _ & true, _ & false, _ & "#'" & CatalogSheetLink & "',"_ & " vPrintOrder, " _ & false _ & ");" CurrentDb().Execute sSQL, dbFailOnError Forms![frmSpec].chldFixtureCuts.Requery 
|
|
#2
February 25th, 2010, 04:17 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
simple syntax issue
& "# ' " & CatalogSheetLink & "',"_
should it be? & " ' # " & CatalogSheetLink & " ',"_ Mark Kubicki wrote: I'v blind this morning to an error in the syntax of my code.. if somone would please take a look over my shoulder and redline the error... many thanks in advance, -mark Type = text PrintCatalogSheet = Yes/No BaseCatalogSheet = Yes/No CatalogSheetLink= Hyperlink PrintOrder = Number IsDetailSheet = Yes/No Dim sSQL As String sSQL = "INSERT INTO tbeAdditionalPages (Type, PrintCatalogSheet, BaseCatalogSheet, CatalogSheetLink, PrintOrder, IsMountingDetail) " & _ "VALUES (" _ & " ' " & Forms![frmSpec].[Type] & "', " _ & true, _ & false, _ & "#'" & CatalogSheetLink & "',"_ & " vPrintOrder, " _ & false _ & ");" CurrentDb().Execute sSQL, dbFailOnError Forms![frmSpec].chldFixtureCuts.Requery -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201002/1
|
|
#3
February 25th, 2010, 06:24 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
simple syntax issue
got it... it should read:
sSQL = "INSERT INTO tbeAdditionalPages (type, printCatalogSheet, BaseCatalogSheet, CatalogSheetLink, PrintOrder, IsMountingDetail) " _ & " Values(" _ & "'" & Forms!frmSpec.Type & " ', " _ & "true, " _ & "false, " _ & " ' # " & CatalogSheetLink & " ', " _ & vPrintOrder & ", " _ & "false" _ & ");" CurrentDb().Execute sSQL, dbFailOnError "NuBie via AccessMonster.com" u42912@uwe wrote in message news:a42b03632daae@uwe... & "# ' " & CatalogSheetLink & "',"_ should it be? & " ' # " & CatalogSheetLink & " ',"_ Mark Kubicki wrote: I'v blind this morning to an error in the syntax of my code.. if somone would please take a look over my shoulder and redline the error... many thanks in advance, -mark Type = text PrintCatalogSheet = Yes/No BaseCatalogSheet = Yes/No CatalogSheetLink= Hyperlink PrintOrder = Number IsDetailSheet = Yes/No Dim sSQL As String sSQL = "INSERT INTO tbeAdditionalPages (Type, PrintCatalogSheet, BaseCatalogSheet, CatalogSheetLink, PrintOrder, IsMountingDetail) " & _ "VALUES (" _ & " ' " & Forms![frmSpec].[Type] & "', " _ & true, _ & false, _ & "#'" & CatalogSheetLink & "',"_ & " vPrintOrder, " _ & false _ & ");" CurrentDb().Execute sSQL, dbFailOnError Forms![frmSpec].chldFixtureCuts.Requery -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/201002/1
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
