Novice
Windows 10 
Access 2019
Hi,
HELP PLEASE! I'm amending an Access database, and i've deleted some fields from the Tables that we don't need anymore. Unfortunately i didn't realise that these fields were present in some queries and forms, and now when i try to open the corresponding queries and forms, this brings up an "Enter Parameter Value" error for the fields that i deleted. How do I sort this out? The database has a back and front end.
Many thanks in advance
Access Developer
Windows 10 Access 2016
Revert to the backup you made before you started deleting things.
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
VIP
Windows 10 Office 365
No quick and easy way without using a third party tool like V-Tools which has a deep search & replace function.
The manual method is to edit the queries and simply remove the fields.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Novice
Windows 10 Access 2019
How do i manually edit the queries. When i look in the queries, in the datasheet and SQL view the deleted items still appear, but in the design view they don't appear...
VIP
Windows 10 Office 365
They will have been replaced with something like
Expr1: [YourDeletedFieldName]
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Moderator
Windows 10 Office 365
Go back to your backup as Bob suggested. Make a plan for what changes must be made and follow it. Your backup seems to be the only stable/consistent part of this project.
Do some research to understand how forms and queries make use of table fields and values.
Don't start by deleting fields in table(s) that you don't think are needed. And, always make sure you protect your frequent backups.
Good luck.
Posting Permissions
Reply With Quote