Deleted Field in table issue

[Suzanne]

I recently deleted a field in a table and now when i click on that table i
get a message with the subject "Enter Parameter Value" with the name of the
field i deleted. From everything that i see i deleted this field from all
queries and forms, why is this message coming up every time I open my table
and what can i do to about it?? Can anyone help me?

 

[Jeff Boyce]

Suzanne

First, have you made a backup copy and (then) run Compact & Repair?

Next, check for any code and/or macros that might call-out that fieldname.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Spencer]

Open the table in Datasheet view.
Once you have the table open, select Records: Remove Filter/Sort from the
menu. Save the table layout (File: Save).

I suspect that you have either filtered the table or ordered it while in
datasheet view and then when you closed the table, you saved the changes to
the layout.

The other way to detect this problem is to open the table in design view and
take a look at the table's Order By and Filter (and perhaps Validation Rule)
properties. You may see a reference there to the deleted field - clean it out
and save the table.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Jeff Boyce]

Nice!

Gotta remember that one...

Jeff

Open the table in Datasheet view.
Once you have the table open, select Records: Remove Filter/Sort from the
menu. Save the table layout (File: Save).

I suspect that you have either filtered the table or ordered it while in
datasheet view and then when you closed the table, you saved the changes
to the layout.

The other way to detect this problem is to open the table in design view
and take a look at the table's Order By and Filter (and perhaps Validation
Rule) properties. You may see a reference there to the deleted field -
clean it out and save the table.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County