Auto Number

[TINA BEARD]

I make a data base every year for work orders that my work does for our customers, I have every thing set up and it looks great except for one field, last year I was able to make it do an auto number once I put the date in. for example first box work Order # ___ second box date once I put in the date an work order # would fill in the w/o# box and it would follow what ever the last work order # was (12600). for example I need the year 2006 TO START OFF WITH # 12601, What querie/option do I need to accomplish with this info.


Thanks Tina

 

[raskew]

Frequently Asked Questions (FAQ)

Tina -

This forum is where contributors post explanations to Frequently Asked Questions. You're more likely to receive some responses if you delete your post in this forum and repost it in a more likely forum, e.g. tables, queries, etc..

Bob

 

[Rickster57]

Reset autonumber

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.