Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Deleting code for forms that no longer exist

Status
Not open for further replies.

magnys

Technical User
Apr 8, 2002
18
US
I have a database that has had several people over the years hold the position of administrator. I myself am starting just starting to get into VBA, but one of the past administrators did use VBA quite a bit, but not necessarily on a completely succesful level. There were many FORMS as switchboards for user interface, but they did not work well. At one point all of those forms were deleted by the small group of actual users in favor of working in the tables and queries directly. There is still a great amount of code for the deleted forms in VBA, and you can trip an error sequence depending on what you click on that will trigger what seems like 100 error messages in a row. All saying

"The form name 'blahblah' is misspelled or refers to a form that doesn't exist."

The deleted forms still exist in the project in VBA. How can I go about deleting these forms in VBA?

Any help is greatly appreciated.

Magnys
 

A recent post to gather all VBA and SQL used for objects in a MS Access

thread705-1175611
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top