Access Autonumber

[TheSponge]

Hi there,
My database is a returned goods database, it has a logID as the primary key (AUTONUMBER). What I need is a text box and a button called "Create RMA" that when clicked access creates another autonumber and stores it in the text box for that record.

Then if an RMA number is needed for another record say record 56, you can click "create RMA" again, and access creates the next autonumber in sequence for that record..

Not sure if I need a seperate table for the RMA or how to even create the code for this operation.

Hope you understand...

Thanks

JAMES

 

[Golom]

You don't need any code. Just set up your RMA table with a field whose type is "AutoNumber". Whenever you add a new record to the table, Access will generate the next value in sequence as the value of that field.

You can retrieve the number of the last one created with some SQL like

Select MAX(NumberField) As [LastNumber] From RMA

 

[MichaelRed]

... but be aware that a 'busy' data base may (WILL) occassionally fail to return the correct value in the scenario described. (Busy) Multi-User systems often have problems using the integer version of "AutoNumber", as the number is obtained/retrieved as soon as the new ("tenative&quot record is created, but not actually included in the db until the record is committed. See faq700-154 for a version which overcomes this -to some degree.




MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[Golom]

MichaelRed
The FAQ that you gave is something about "Setting up partitioning for installing Linux". Is that what you intended?

 

[MichaelRed]

sorry, a bit of a type / fumble fingers faq700-184




MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[danvlas]

You can also check thread702-610276

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[TheSponge]

Thanks guys,

The other thread was very useful. Its doing what I want now..