Dear all
I've a problem with the following code ...
Does anybody see the mistake I Did ?
CurrentDb.Execute ("INSERT INTO tab_Print_Rep (ID_Konsi_Eingang,DruckZusatz) VALUES (" & Me.ID & "," & CStr(n) & " von:" & ")")
Thanks for your help
Dear all
I've a problem with the following code ...
Does anybody see the mistake I Did ?
CurrentDb.Execute ("INSERT INTO tab_Print_Rep (ID_Konsi_Eingang,DruckZusatz) VALUES (" & Me.ID & "," & CStr(n) & " von:" & ")")
Thanks for your help
this bit - you are missing single quotes
"," & CStr(n) & " von:" & ")"
don't know what Cstr(n) is (I presume n is a value assigned somewhere)
try
",'" & CStr(n) & " von:" & "')")
Solved .. Thanks !!
( Name missmatch )
Perfect thanks !!
First I missmatched my tab's
But the '" & CStr(n) & " von:" & "')") did solve the problem
that was quick !
Thanks again !!
CurrentDb.Execute does NOT require brackets.
I recommend you use the dbFailOnError parameter with CurrentDb.Execute
See this for more info