I need a way to delete another module inside Access programmatically, and wanted to use DoCmd.DeleteObject acModule. Unfortunatly, it produces a very weird ...

I do not believe Jet (the database engine Access uses) supports table-level triggers, so you'll need to use a macro or VBA code in a form to trigger the extra record.

If you see Microsoft Visual Basic, Run-time error, Class not registered in Office Excel, follow these solutions that have helped many fix the issue.

Method four: How to run a VBA sub procedure by clicking a shape in Excel Office apps offer several shapes that you can use to execute a VBA procedure, similar to the second method outlined above.

If you get Microsoft Access Runtime Errors 2501, 424, 13, 6, 3052, 3146, 3027, 2471, 3343, 3027, etc. while Access is running, see this post.

Learn how to use a data validation control to allow users to select when to run multiple VBA procedures in Microsoft Excel.