deleting ~tmp forms

[Sergey Poberezovskiy]

I am trying to create a wizard that creates a form in code.
I use Application.CreateForm and Application.CreateControl
to accomplish the task. After saving the form I have
a "fantom" object called "~TMP###" left in the database,
that is visible in the Object Browser and in the Project
Explorer, but not in the database window.

Question: is there any way (in code) to get rid of this
form, as I cannot just re-import all the objects into a
new database (that defeats the purpose of the Wizard)

Any help is greatly appreciated.

 

[M.L. Sco Scofield]

If I remember correctly, it should go away automatically when the database
is closed and reopened. If not then, it should definitely go away when you
Repair/Compact the database.

If not, take a look at the DeleteObject method of DoCmd.

Happy New Year!

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

 

[Sergey Poberezovskiy]

Neither closing and opneing nor compacting the database
did remove the ~tmp objects.

DeleteObject worked!!!

Thanks a bunch!

Happy New year!

 

[M.L. Sco Scofield]

You're welcome.

Glad it worked.

And thanks to you.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com