467,080 Members | 1,081 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,080 developers. It's quick & easy.

Access 2003 Autofill Numbering

Hello,

I am new to Access, I'm trying to make the switch from Excel to Access as the databases I'm working with have over 200,000 records.

In excel, when you want a field to autofill numbering, it's easy. You type in 1,2,3,4 etc. highlight this and drag or double click and magic the rest of the records are filled in for this field with the continued counting.

How the $#^%&$%#@ does one do this in Access. I have 2003.

Please Help!

And thanks!

Jenny
Sep 13 '07 #1
  • viewed: 2439
Share:
8 Replies
Expert 100+
You're going to have to provide more information. What are you trying to number? Are you trying to do this on a report?
Sep 13 '07 #2
JConsulting
Expert 512MB
Hello,

I am new to Access, I'm trying to make the switch from Excel to Access as the databases I'm working with have over 200,000 records.

In excel, when you want a field to autofill numbering, it's easy. You type in 1,2,3,4 etc. highlight this and drag or double click and magic the rest of the records are filled in for this field with the continued counting.

How the $#^%&$%#@ does one do this in Access. I have 2003.

Please Help!

And thanks!

Jenny
Hi Jenny,

If you're trying to fill down records in a table, then you have to create an update query to do that. Access doesn't play like Excel. If you're trying to create an index of autonumbers, then create a field in your table for that.
A little more info might help us help you create a query if that's what's needed.
J
Sep 13 '07 #3
MGrowneyARSI
You could use a loop in the VB Code
"I am new to Access, I'm trying to make the switch from Excel to Access as the databases I'm working with have over 200,000 records."
Excel is a spredsheet Glad to hear you switched to Access you'll love it
Dim rec
Dim mysql$


mysql$ = "SELECT name of field FROM table name"
Set rec = CurrentDb.OpenRecordset(mysql$, dbOpenDynaset)

rec. move first
do while not rec.eof
rec=rec+1
rec.movenext
loop
Sep 14 '07 #4
Thanks so muchly. Yes, I'm excited about this switch, but so unfortunate we couldn't learn this matrix styles! I have heard much about the beauty of Access. Last night I went through about 8 lessons on the training website. All the ones about queries etc. The VBE is something I'm excited about, but honestly I'm not quite there. I will play with what you have written me to see if I can get this to work.

Thanks again.





You could use a loop in the VB Code
"I am new to Access, I'm trying to make the switch from Excel to Access as the databases I'm working with have over 200,000 records."
Excel is a spredsheet Glad to hear you switched to Access you'll love it
Dim rec
Dim mysql$


mysql$ = "SELECT name of field FROM table name"
Set rec = CurrentDb.OpenRecordset(mysql$, dbOpenDynaset)

rec. move first
do while not rec.eof
rec=rec+1
rec.movenext
loop
Sep 14 '07 #5
Thanks for the replies!

I am in need of creating a field that is numbered from 1 through to the end of my records ~60,000, just so I can have a unique ID associated with each record I can bring along and be able to pick up info from original database through the unique ID.

I will see if I can get the code someone so graciously supplied on a reply to work. I have only gotten as far as the queries and expressions in the training programs on the website!!!

Thanks All,
J
Sep 14 '07 #6
JConsulting
Expert 512MB
Thanks for the replies!

I am in need of creating a field that is numbered from 1 through to the end of my records ~60,000, just so I can have a unique ID associated with each record I can bring along and be able to pick up info from original database through the unique ID.

I will see if I can get the code someone so graciously supplied on a reply to work. I have only gotten as far as the queries and expressions in the training programs on the website!!!

Thanks All,
J
You don't need code for that. if you already have the data in a table, just go to design view and insert an ID field. Make it an Autonumber type then save it. When you open the table, it will automatically create your unique id numbers.
J
Sep 14 '07 #7
Solved! Thank you so much. I knew it had to be ridiculously easy!!

You don't need code for that. if you already have the data in a table, just go to design view and insert an ID field. Make it an Autonumber type then save it. When you open the table, it will automatically create your unique id numbers.
J
Sep 14 '07 #8
JConsulting
Expert 512MB
Solved! Thank you so much. I knew it had to be ridiculously easy!!
You're very welcome...welcome to the Scripts!
J
Sep 14 '07 #9

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by shortbackandsides.no@spam.hairdresser.net | last post: by
3 posts views Thread by Rob R. Ainscough | last post: by
1 post views Thread by jdph40@yahoo.com | last post: by
6 posts views Thread by Peter Frost | last post: by
2 posts views Thread by Andre Ranieri | last post: by
49 posts views Thread by Allen Browne | last post: by
3 posts views Thread by dekker.erik1@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.