Access 2003 Autofill Numbering

jcoleshill

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

mlcampeau

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

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

jcoleshill

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

jcoleshill

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

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

jcoleshill

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

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