Reset Auto Number? 6

[PepperPepsi]

Hi,

i wanna know how to reset the auto number,
what happen is, if i delete all my records, the auto number field did not change back to zero.

thanks, Chiu Chan
WebMaster & Software Engineer
emagine solutions, inc

http://www.emagine-solutions.com

cchan@emagine-solutions.com

 

[JoeMiller]

Run a compact on the database after deleting the records, then the autonumber will reset.

Joe Miller
joe.miller@flotech.net

 

[Aivars]

Hi!

By using of Autonumber proceed lot of problems when you are needed to export/import data as well as reset of autonumber. Because I never use autonumber but always use Long or Integer data type fields. For new record update from form I write in the procedure Form_BeforeInsert following codes:

private sub Form_BeforeInsert(cancel as integer)
if dcount("MyField","MyTable&quot=0 then
me.MyField=1
else
me.MyField=dmax("MyField","MyTable&quot+1
endif
End Sub

Aivars

 

[PepperPepsi]

Hi guys,

Joe, it works great, thanks~
Alivars, thanks for the advise, i will consider it~

thanks, Chiu Chan
WebMaster & Software Engineer
emagine solutions, inc

http://www.emagine-solutions.com

cchan@emagine-solutions.com