I have a huge list of records and deleted a few. This means that the
ID-nummering contains holes. How to get it renummered? With Compact and
Repair Database no success. 5 1542
Access will always use the next sequentially availible number for
autonumber.
Create a new autonumber field - this will number them all sequentially
in order of input. You can then delete the old autonum field and call
the new field the same name as the old one.
But do NOT do this if you have any foreign keys linked to this field
from other tables. In fact if the field is being used as a primary key,
it's probably not a good idea full stop. If it's just something that's
irritating you I suggest you learn to live with it. Why do you need to
do this?
On 15 Jul 2005 03:52:08 -0700, AA Arens wrote: I have a huge list of records and deleted a few. This means that the ID-nummering contains holes. How to get it renummered? With Compact and Repair Database no success.
Don't. The AutoNumber datatype field should be used solely to generate
unique Id's. If you use a number for any other purpose you are using
the wrong method to do so. There will always be holes in the numbering
sequence. So what?
Besides, it is the ID field that is used to identify records. As soon
as you renumber, that record might no longer be associated with the
correct child (or parent) record.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Then it is better to have filed "record number", copied from the
standard record field below each form.
OK, I can see the record number there. But I want to have it on my form
as well.
The ID is then actually an Access internal rerord number.
Then it is better to have filed "record number", copied from the
standard record field below each form.
OK, I can see the record number there. But I want to have it on my form
as well.
The ID is then actually an Access internal rerord number.
The record number in the nav box is generated on the fly - so if you
apply a filter, what was record 10 may now be record 2, or if you sort
the records by a field, they will all change. If you want each record
to have a fixed, unique number that is displayed on the form and has no
"holes" in the sequence, then you will have to create a new field in
your table and have it filled with code. you can write a module to find
the first availible number greated than 1 and apply it to the field.
something like:
Dim i: i = 1
do while isnull(dlookup( "yourField","yo urTable","Field =" & i)
i = i +1
loop
me.myfield.valu e = i
this would be done more efficiently with a recordset, but the above
code would work and it is simple enough to apply. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: jaYPee |
last post by:
I have currently using a dataset to access my data from sql server
2000. The dataset contains 3 tables that is related to each other.
parent/child/grandchild relationship. My problem is it's very slow to
retrieve records from sql server.
I'm using sqldataadapter.fill method to populate dataset.
Parent table contains more than 3,000 records and child table contains
more than 10,000 records and grandchild table contains more than
90,000...
|
by: NTPT |
last post by:
I have this table
content (id int8,owner int8,position int8,timestamp int8,description text,batch int8)
Table is inserted/deleted frequently, 'id' is almoust random.
I insert to the table following set of rows :
|
by: Rob R. Ainscough |
last post by:
VS 2005 I have:
ClickOnce deployment
User's that hate and or don't want to use an IE Client (don't blame them)
I don't see how ASPX web pages are going to survive? With .NET 2.0 and
clickonce deployment my app is 427KB (even with modem dialup speed it
doesn't take long to download) -- the user gets a very friendly secure
WindowsForm app (most of them don't even notice they're not under IE
anymore) that performs considerably faster than...
|
by: DP |
last post by:
hi,
i've got a form, with a subform in it. i've got a delete button in the
subform. the code i;ve got is;
Private Sub cmdDeleteRecord_Click()
msg = "Are you sure you want to delete this film rental record?"
Style = vbYesNo + vbQuestion + vbDefaultButton2
|
by: Ian Davies |
last post by:
Hello
Needing help with a suitable solution.
I have extracted records into a table under three columns 'category',
'comment' and share (the category column also holds the index no of the
record in a hidden field)
I wish the user to be able to edit the data in the table, so I have
extracted the records into hiddenfield, textareas, dropdown list and
checkbox so that they can make changes.
I named these elements as arrays and wish to run an...
| |
by: sparks |
last post by:
I am trying to fix a database that someone did about 4 yrs ago in
access97.
The main table just contains demographics and is on the main form of
the database.
It has a subform on a tab that contains the other information.
it is set 1 to 1 in the relationships.
simplify if I can
|
by: nethravathy |
last post by:
Hi,
The following table namely elcbtripselect contains 5147 records.I want to know wether this table contains duplicate records or not.
I tried with following query
1)SELECT elcbtripselect.ELCBTRIP_voltsMIN, elcbtripselect.ELCBTRIP_voltsMAX, elcbtripselect.ELCBTrip_is_partwinding, elcbtripselect.ELCBTrip_is_ydelta, elcbtripselect.ELCBTRIP_starter_size, elcbtripselect.ELCBTRIP_UnitFunction, elcbtripselect.ELCBTRIP_strcb_speedi_frame_ty,...
|
by: Dave |
last post by:
On my form I have combo boxes. These combo boxes, after updating
them, populate respective listboxes that are located below the combo
boxes on the same form. I am trying to use a "generate report" button
located on my form to print all of the list box values (that have been
updated via selection from combo boxes) from the form to the report.
I've tried using a macro with the code:
Macro Name: cmdGenerateReport : On Click
Action:...
|
by: JHite |
last post by:
I’m using Access 2003 on Windows XP.
I have a Mainform (Staff Entry) which displays an unbound combo box named ChooseStaff. The Row Source for this combo box is a SELECT of the UserIDs and Staffer Names from a table (Staffers) which contains staffers’ names and other info.
When the user actually selects a Staffer Name from the dropdown combo box, the VBA routines for the combo box’s On Enter and After Update events take care of finding and...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| | |