For those that are having trouble deleting that ~tmpclp#### form or report that only shows in VBA module and NOT as an object in the navigation pane.
I created a new blank form (but did NOT save it).
created a button, assigned a macro to it and gave it the following code:
docmd.rename "frm_deleteme", acform, "~TMPCLP2228231"
docmd.deleteobject acform, "frm_deleteme"
I can then click on the button and it is gone. remember, do NOT save the newly created form. even if you do, deleting it will cause problems that not even a compact/repair or decompile can fix.
hope this helps others.
I created a new blank form (but did NOT save it).
created a button, assigned a macro to it and gave it the following code:
docmd.rename "frm_deleteme", acform, "~TMPCLP2228231"
docmd.deleteobject acform, "frm_deleteme"
I can then click on the button and it is gone. remember, do NOT save the newly created form. even if you do, deleting it will cause problems that not even a compact/repair or decompile can fix.
hope this helps others.