Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Insert Into Command
Message
De
23/10/2001 15:50:13
 
 
À
23/10/2001 15:39:27
Information générale
Forum:
Microsoft Office
Catégorie:
Access
Divers
Thread ID:
00572148
Message ID:
00572272
Vues:
47
Run-time error '3134'

Syntax error in INSERT INTO statement

I was trying to give an example of my INSERT INTO statement to keep it short, but here is the actual statement:
DoCmd.RunSQL (" insert into labels (trknum, BC2, Date, catalog, intid, _
cavity, pressnum, cyclenum) values (" & mtxt0 & ", '" & mtxt9 & "', _
#" & CStr(mtxt2) & "#, '" & mtxt4a & "', " & mtxt6a & ", '" & mtxt8a & "', _
" & mtxt14 & ", " & mtxt18 & ")"
sorry about the length of this
Here's to alcohol...the cause of ... and solution to ... all of life's problems - - Homer J. Simpson
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform