[AccessD] Access confused about its own objects

Bill Benson (vbacreations) vbacreations at gmail.com
Fri May 21 13:38:06 CDT 2010


And if I try to delete the for manually Access tells me

The Search Key was not found in any record.



-----Original Message-----
From: Bill Benson (vbacreations) [mailto:vbacreations at gmail.com] 
Sent: Friday, May 21, 2010 2:36 PM
To: 'Access Developers discussion and problem solving'
Subject: Access confused about its own objects

Access 2003 continues to plague me, I am getting this message now:

The Microsoft Jet database engine could not find the object
'~sq_fBILL__subfrmControlsList'.  Make sure the object exists and that you
spell its name and the path name correctly.

When I am trying to delete (for the second time) the form named

BILL__subfrmControlsList

This is my process, to delete a form (if it exists), rebuild it, attach it
as a sourceobject to s subform, set that subform sourceobject back to "",
delete the form, repeat ... as often as required. It does not help to have a
command which says

?DoCmd.DeleteObject acForm, MyForm

Where MyForm is BILL__subfrmControlsList

And have access (1) not do it and (2) tell me that what it tried to delete
was ~sq_fBILL__subfrmControlsList.

Does someone know why this is happening?





More information about the AccessD mailing list