auto number in access - Microsoft Access / VBA

auto number in access always increase whether the record are save or not...how to make the number maintain until we save the record?

For example, if I want create something and the number 14, then I want to cancel it...after that, I want to create again and the auto number become 15...how to make it 14 back..

Apr 18 '15 #1

Subscribe Post Reply

1541

Aftab Ahmad

32bit

You can set "Indexed" setting as No (Duplicates OK) in Table Design View but in that case whenever you deleted any record, new record will replace on that number i.e. you deleted No.2, after that you will entered a new record, it will be replace as 2.

Apr 18 '15 #2

zmbd

5,501

Expert Mod 4TB

mrijet:
This behavor is by design. The autonumber was and is not intended to be used as a sequential numbering system. The purpose of this datatype is to provide a unique, unrelated, record-id for use as a primary key.

If you need a sequential number, there are several threads covering this topic (for example this thread covers a method for sequential with year looping; however, we do have simpler "check" number solutions in the forum too :-) ) If you have something more specific and an example of your work-flow, someone here can help steer you in the right direction.

Aftab Ahmad
Removing the [indexed no duplicates] is highly inadvisable unless one is aware of the consequences of such an act on the autonumber field.

Apr 18 '15 #3

Similar topics

auto-number/Identity column

by: Larry Rekow | last post by:

I am migrating a web application I wrote from ASP to ASP.Net, and from Access to MS SQL server. In the Access version, I did not use the auto number for creating invoices and other documents,...

Microsoft SQL Server

Auto Number or Identity Seed on Oracle Database

by: Ken | last post by:

Need help on the Auto Number or Identity Seed on the Oracle Database I got an Access database that need to be converted to Oracle 9i. Somehow the Trigger we created to simulate the "AUTO NUMBER"...

Microsoft SQL Server

Auto number field display question

by: Irwinsp | last post by:

Hi All, I have a form with an auto number field displayed. The field looks great except when the user is entering a new record. The field then has the text "auto number" in it. Is there a...

Microsoft Access / VBA

Using an auto-number as a primary key

by: Geoff Cayzer | last post by:

At http://www.blueclaw-db.com/tips_tricks.htm I came across a section which is included below and was hoping for some comment on the article. -------------- Almost never use this auto-number...

Microsoft Access / VBA

What is the largest "auto number" that can exist in an Access database? How to reset autonumber to start at 1?

by: John Baker | last post by:

Hi: I know this is a strange question, but I have inherited a system where files are copied and records re auto numbered (as an index field) )frequently, and I am wondering how high the number...

Microsoft Access / VBA

Auto Number

by: Mike N. | last post by:

Hello- I have a database that uses an auto number field type that goes out of sync periodically. My customer gets a "cannot add record, number already in use" error message. I dump the records...

Microsoft Access / VBA

Getting auto-number with DataSet

by: Shahar | last post by:

Hi I need to get a field name 'ID'(that is an auto-number field) right after I add a new row to table, it's work like that: myCommand.ExecuteNonQuery(); myCommand.CommandText = "SELECT...

C# / C Sharp

auto number by category?

by: Marina | last post by:

Can anyone tell me if there is a way to auto number by category? I have 2 tables, ExpenseCategories and Vendors. Each there are many vendors to each expense category, but each category has a...

Microsoft Access / VBA

Auto Number mysql

by: S.Dickson | last post by:

I had an access database that i use as an ordering system. I have a form for entering customer details. When i add a new customer on the form the customer number is an auto number that appears when...

MySQL Database

Auto Number field and ReSet used only for export files

by: Wayne L | last post by:

Ok now everyone has mentioned not to use auto number if it means anything to the user. My application uses the auto number for exporting only. I append the mastertbl column with my starting number of...

Microsoft Access / VBA

Navigating the Data Structures and Algorithms (DSA)

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

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

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

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

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

General

Problem With Comparison Operator <=> in G++

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

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

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

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice