Delete TMP form only found in VBA (1 Viewer)

[jco23]

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.

 

[isladogs]

This was also covered recently as part of a thread in the code repository:
"How to remove 'deleted database objects' from the MSysObjects table"

https://www.access-programmers.co.uk/forums/showthread.php?t=293579