Auto Number

[Guest]

I started using the Recipe Wizard which included the RecipeID field that is
an Auto Number. I entered 96 records and then accidentaly pressed something
(not sure what) and the field is still there but it now a Number, not Auto
Number. It will not let me change this to an Auto Number field, not will it
let me create another RecipeID field (even if I change the name) to make it
an Auto Number. Any ideas? Thanks

 

[jahoobob via AccessMonster.com]

If you haven't closed and saved the design you can either close and select No
when asked if you want to save your cahnges or use the Undo.

 

[Al Camp]

Linda,
Try a Compact and Repair.
Of course, if that works, and you can now create a new autonumber field, and assign all
new IDs, you may lose your realtionship to any related tables that used to synch via the
old auto ID.

IF... your "old Auto, now Num" ID is still correct, and maintains it's relationship to
any sub tables you had in the past... (ex. Recipes to Ingredients)...
One workaround is to use the "old Auto, now Num" ID field, and create your own ID
"generator."
On your recipe form, in the default value for your old ID field (now a number), you
could use this DefaultValue...
= DMax("[YourNumIDField]","tblRecipes") + 1
Every time you create a new record, an new ID will be generated. (A number field
"acting" like an Autonumber)

IF this is an unrelated "stand-alone" table, and the Compact and repair now allows you
to create a new Auto field, then by all means, use your original method (add a new Auto,
then delete the old ID field, then rename the Auto)