Adding new record into a table by using code

[Art Vandaley]

Hi,

I want to add new records into a table's fields by using code. Can anybody
help me to have an idea how such a code should be? Regards.

 

[Steve Schapel]

Art,

It would depend a lot on what the data is that you want to add to the
table, where it comes from, and when you want to perform this. But it
may be a job for an Append Query, so it may help you to have a look at
this for a start.

 

[Art Vandaley]

Hi,

I need to do it by using code. I have a command buton in a form which will
start the code (command_click()). Say I have fields "number", "name" in
table t1. I want to add 10 new records automatically with the command button
clicking. The fields woulb be filled like:

number------name
100---------Tom
101---------Tom
102---------Tom
.......
.......
.......
110---------Tom

I'll appreciate having your answer. Regards.