Auto Number

[TINA BEARD]

Auto Number PLease Help ME

I have an access data base and every year I (only my second year making it-ex-employee use to make it) need to make a new one to start off the year for all our new work orders.

but any way I have the form made looks exactly like the previous years but I can not get the work order box to become an auto number and I need it to tart of at 12601 and I had it so that when I put in the date the next work order # would pop in the box, and I need to get all the hours and part totals to add up.

PLease help.

Tina

 

[neileg]

Try this post for some code to reseed the autonumber. Pat Harman takes all the credit.

However, you should probably not be using an autonumber for any ID that has a meaning. Autonumbers are really mean for IDs that are not seen by the user.

 

[TINA BEARD]

huh!

Tina BEard

 

[neileg]

I guess you're struggling a bit here. I've picked up on your other thread with the database file attached.

 

[Rickster57]

Autonumber

I had posted to this before but will gladly do it again...

1.Create a temporary table with just one field, a Number field; set its FieldSize property to Long Integer and give it the same name as the AutoNumber field in the table whose value you want to change.

2.In Datasheet view, enter a value in the Number field of the temporary table that is 1 less than the starting value you want for the AutoNumber field. For example, if you want the AutoNumber field to start at 100, enter 99 in the Number field.

3.Create and run an append query to append the temporary table to the table whose AutoNumber value you want to change.

Note: If your original table has a primary key, you must temporarily remove the primary key before running the append query. Also, if your original table contains fields that have the Required property set to Yes, the Indexed property set to Yes (No Duplicates), or field and/or record ValidationRule property settings that prevent Null entries in fields, you must temporarily disable these settings.

4.Delete the temporary table.

5.Delete the record added by the append query.

If you had to disable property settings in step 3, return them to their original settings.