auto fill numbering

[Guest]

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

 

[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.

 

[Guest]

Thank you. I didn't think that it was possible.

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.