Compact and Repair Error - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Compact and Repair Error

John Stewart

2 years ago

Hi Team, Compact and Repair error is 'Could Not fine field Notes01" On the access website it states "A column name that does not exist is being referenced. I have searched all the VBA in the file and the prob not there. Is there a quick next step or should I check all queries in design view

	Sami Shamma @Reply 2 years ago
Check the following locations: 1- the master field and child fields in the subform and subreport 2- in forms and reports the name of the field matching the control source 3- any aliases in queries.

	John Stewart OP @Reply 2 years ago
Thanks Sami . Not sure if I should be posting Thank you replies in the Forums..

	Sami Shamma @Reply 2 years ago
Thank you is always welcome

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View