create next highest number

[Guest]

Could someone give me an examble of how to use a VBF to create the next
highest number in the database. I can not use Auto Number as the table
sometimes needs to exported and then imported back in

 

[Stefan Hoffmann]

hi Burt,

Could someone give me an examble of how to use a VBF to create the next
highest number in the database. I can not use Auto Number as the table
sometimes needs to exported and then imported back in

As query:

INSERT INTO Table (ID, Field1, Field2)
SELECT Nz(Max(ID), 0) + 1, Value1, Value2 FROM Table


mfG
--> stefan <--

 

[Fred Boer]

Dear Burt O:

There are two sample databases illustrating that technique here:

http://www.rogersaccesslibrary.com/download3.asp?SampleName=AutonumberProblem.mdb

HTH
Fred Boer