auto fill numbering

C

Chris

I'm using access 2000 and I'm wondering if it's possible to do something like
excel does. What I'm looking to do is to be able to highlight a few serial
numbers that have already been put into the table and just drag down so that
they numbers will continue withhout having to type them all. I can't use
Auto number because the serial numbers will repeat themselves when I change
part numbers. Any suggestions??

thank you
 
A

Allen Browne

No, you can't do that in Access.

You can add records programmatically though.
See the MakeData() function here:
http://allenbrowne.com/ser-39.html

The example adds the numbers from 1 to 1000.
You can change the code to add the numbers you want.
 
Top