Modifying field names

[Guest]

Okay, so I come back from my first design Access class where I'm told it's
best to standardize the way to name my fields, tables and other objects,
i.e., fields should be "WithoutSpaces", tables should be 'tblLikeThis', etc.

I want to get my existing table to conform with this standard. I don't mind
changing field names, and redoing the few reports and forms, and even some
code.

I have done this, but apparently this causes some problems. When I want to
open a form, I am prompted to enter a specified field which should not exist
anymore.

Are field names hidden somewhere which I haven't changed yet?

Are there any tips for doing such housekeeping? Does Access 2002 offer any
utilities for this? Or should I just start from scratch with a new database
and then append the old info into it?

What would you recommend? I want to build several more forms and reports
from this data and I want the db to conform to a proper standard.

Thank you.

 

[Guest]

You did not mention Queries. Maybe that is where the field name is.

You can utilize Access's TOOL - Analyze - Documentor.

 

[Guest]

I'm certainly not as expert as most who help out here, but let me give this a
shot -

You have your original table, "Like This"

You create a form for that table, "MyForm", and the first text box maps to
[Like This]![Field 1]

You go to normalize your names, "Like This" becomes "tblLikeThis", "Field 1"
becomes "Field01".

When you do that, I don't think Access automatically looks for all instances
of the tables and fields, and it doesn't automatically update them to the new
ones.

So.... yes, your form is looking for fields that no longer exist, just as
you said. You need to go in and fix the names you changed on all your forms,
queries, VBA code and formulas, as well.

Since it's looking for the old names, and can't find them, it prompts you to
enter them manually.

Or so I think.