SQL Access 2007 VBA codering, syntax?

[lili1964]

Hello,

I want to use the VBA coding in Access 2007 to code some sql commands as for example:
insert into personeel values (1, "jan","jansen",1090);
insert into personeel values (2, "truss","janen",1198);
insert into personeel values (3, "piet","jen",1187);

How can I do this and where do I place the code in the form? Which event?

Where can I find the syntax of the SQL coding within VBA Access 2007? Or even the syntax of the VBA coding? Is there a manual or a tutorial for?

Thanks and kind regards,

Lili

[semiSkim]

It's been a long time since iv used Access so I can't actually help with the syntax I'm afraid. What I can suggest is that you create a query in Access manually to find out, just switch from design view to code view. Make sure you create the right type of query.