Autonumbering Field

**LF83** · 09-26-2012, 11:00 AM

Hello, friends!

I have 2 sheets, like front end and back end.

In db sheet, there's a table with a field I need to autonumbering. Actually, I did it and it works, but I'm not sure if the best way, cause it can may be making the adding record query a litle slow.

I did it in two steps:

#1 - Query for get the last id field value then put into a variable plus 1.

Please Login or Register  to view this content.

#2 - Adding Record Query

Is there a optimized way to do it?

Thank's for help!

[]'s

**HaHoBe** · 09-26-2012, 12:33 PM

Hi, LF83,

when using Excel you should be able to use the Max-Function for that:

Please Login or Register  to view this content.

Ciao,
Holger

**LF83** · 09-26-2012, 03:01 PM

HaHoBe,

But the db workbook is closed. I access it trhought ADO.

Thanks for help.

[]'s

**HaHoBe** · 09-27-2012, 12:03 PM

Hi, LF83,

if Excel is always used as Frontend to the Access-db the value could be saved there.

Please Login or Register  to view this content.

where Number should be the name of the field holding the Autonumber and tbltramitacao is the name of the table. This has to be augmented by 1 for the new number.

Ciao,
Holger