Removing Microsoft Office Access Class Objects

[MSAccessRookie]

When I open the Visual Basic Editor to view my project, the first item in the project list is titled "Microsoft Office Access Class Objects". It contains a list of VB Objects with naming conventions similar to Form_{FormName} and Report_{ReportName}. Some of these entries have become obsolete. Can they be removed?

 

[Banana]

Two ways:

1) Deleting the forms themselves from the database windows.

2) Alter the form's property "HasModule" under (Other) tab to "No".

 

[MSAccessRookie]

Two ways:

1) Deleting the forms themselves from the database windows.

2) Alter the form's property "HasModule" under (Other) tab to "No".

Holy Smokes! This has got to be the fastest turnaround I have ever had in this forum. I cannot choose Option 1, because I cannot remove the Form, since it is not obsolete. The VB Code behind it went PUBLIC as part of my Macros to VB Conversion Process, and was moved to a module that contains common subs. I will try the HasModule Method as described in Option 2.

 

[Banana]

Just be aware that setting it to "No" will remove *all* code behind this particular form/report, so if you have at least one sub that's not already in a public module or somewhere, proceed with caution.