Make Auto Number Serial

[carl024]

Table1 data
ID_No(AUTO NMBER)
01
02
03
04

IF I AM DELETE ID_NO 03 & 04
AUTO NUMBER START 05 AND MY DATA SHOW IN THIS STYLE
AND ALL DATA DISTURB
Table1 data
ID_No(AUTO NMBER)
01
02
05
06

NEED ID_NO SERIAL WISE NO ANY DISTURB IF I DELETE ANY
RECORD

 

[Catalina]

Please do a search here on this topic, it has been discussed numerous times.

Catalina

 

[carl024]

sir i search but not found my answer you give any link and sample mdb file about my question

 

[Galaxiom]

AutoNumber cannot be controlled.

Search the forum for:
DMax + 1

 

[Pat Hartman]

Whether you use an autonumber or generate your own sequence number, if you delete records, YOU WILL HAVE GAPS. If you can't have gaps, you MUST create your own sequence number and you cannot delete records. In a multi-user environment, you need to worry about users generating the same sequence number. The best solution is to use a table to control the sequence number. When you need a new number, read the last issued number from the table and increment it. This still runs the risk of the current record never being saved and so the sequence number never used so you will have to program around this.