Insert rows in table with Auto Number

[tjbennett]

I have a table with an Auto Number field in it. How can I "automatically" add 100 rows, with it auto numbering them?

 

[Andrzejek]

Did you try to add just 1 row? Even 'by hand'?
If so, did it work?

Have fun.

---- Andy

 

[tjbennett]

Yes I can do that, I want to add 100 more (without doing them one at a time).

 

[dhookom]

Use an append query that has 100 records.

Duane
Hook'D on Access
MS Access MVP

 

[tjbennett]

Where do the 100 records come from? A table from which I manually add 100 records?

 

[Andrzejek]

OK, you can add 'by hand' one record to your table. And you want to add 100 records to it, in code (I assume). Where do you get the information from? Do you make it up as you go? Do you read it from somewhere - if so, from where?

You can do something like:
[tt]
Insert Into tbtMyTable (Select * from tblSomeOtherTable)
[/tt]
or
[tt]
For i = 1 to 100
Insert Into tblMyTable(1, 2, 'abc', i)
Next i
[/tt]

Have fun.

---- Andy

 

[tjbennett]

Thanks, I went blank for a moment.

 

[Gammachaser]

Take that blank and enter it into your table 100 times. ;-)