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
8 2728
You're going to have to provide more information. What are you trying to number? Are you trying to do this on a report?
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
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
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
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
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
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
Solved! Thank you so much. I knew it had to be ridiculously easy!!
You're very welcome...welcome to the Scripts!
J
Sign in to post your reply or Sign up for a free account.
Similar topics
by: shortbackandsides.no |
last post by:
I'm having a lot of difficulty trying to persuade the Google toolbar
autofill to act consistently, for example
=======================
<html><head>
<title>autofill test</title>
</head><body>...
|
by: Rob R. Ainscough |
last post by:
I'm looking into a good Text Editor (either stand alone or can integrate
into VS 2003)
Needs to have the following:
1. Powerful Search & replace
2. column editing
3. macro recording &...
|
by: jdph40 |
last post by:
I have a table with fields EmpID (PK), EmployeeNumber, DateTaken, and
YearTaken to track the dates an employee takes for vacation. I need a
way to distinguish between years because the data will...
|
by: Peter Frost |
last post by:
Please help
I don't know if this is possible but what I would really like to do is
to use On Error Goto to capture the code that is being executed when
an error occurs.
Any help would be much...
|
by: Andre Ranieri |
last post by:
I'm retouching our corporate web site that, among other things, allows
customers to log in and pay their invoices online. I noticed that on the
checkout page, the credit card number textbox...
|
by: Allen Browne |
last post by:
If you are looking for opinon on what's useful in Access 2007, there's a new
article at:
http://allenbrowne.com/Access2007.html
Covers what's good (useful features), what's mixed (good and bad),...
|
by: Emmi |
last post by:
I have a MS Access 2003 database that I have inherited and has been in service for about 2 years now. Suddenly, we are getting a vba runtime error "6". I have done some research and what I have...
|
by: seawolf |
last post by:
Is there a way to create a numbering for the Details in an Access 2003 Report. For instance, if a report has 12 records that make up the Details in a report, can these be numbered, i.e., 1, 2, 3, 4,...
|
by: dekker.erik1 |
last post by:
hello,
I would like to know if there is a way in ms access 2003 to add
consequtive numbers to a new column to 'count' the records. This count
should start over by every by variable. for example:...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |