[AccessD] Access confused about its own objects

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


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