asset tracking database using own ID numbers

[Guest]

I want to use my own property ID numbers to track assests in a manufacturing
facility. Is there a way of doing so without using auto numbers the program
assigns. The ID Tags I have start with numbers 10000. That is the number I
want to enter into my data table.

 

[Douglas J. Steele]

Change the data type of the field from AutoNumber to Number.

 

[Centaur]

If I understand you correctly is that you want to still have an Auto Number
Facility but you don't want to use the AutoNumber function in the table.

If my
Table Name is ASSETS
Form Name is ASSETSENTRY
Field for Assets ID is IDTAGNO

I would have a button on my form "ADD ASSET" that adds a new record then add
to the ONCLICK event procedure the following line


Forms![ASSETSENTRY]![IDTAGNO] = DMax("[ASSETS]![IDTAGNO]", "[ASSETS]") + 1

This will look up in the table the highest number you used and then it will
add ONE to it and put it in the IDTAGNO field.

In order for it to start at 1000 I would hand make a dummy record with the
IDTAGNO as 9999
then open the for and press the ADD ASSET button. it will then create your
first record 10th 10000. After doing this you can delete the dummy record.

It has worked for me.

Centaur