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

1540

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

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

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

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

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

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

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