Excising a query from a MS access 2010 db

[Lou_Reed]

When one makes an INSERT INTO query, I would like to know if also creates a macro. I am trying to get rid of a outdated query and I noticed that
there is a macro in the macro section that is very similar to parts of the query. I just want to know if getting rid of the query, that I can get rid of the
macro as well.

Any help appreciated. Thinks in advance.

Respectfully,



Lou Reed

[JoeM]

No, deleting a query with not delete a Macro, or vice versa. They are independent objects.
Nor will running an INSERT QUERY create a Macro. Macros are created manually.
You will need to delete both the Query and Macro. VBA code could be created to delete objects.

[Lou_Reed]

Thanks for your help. The statement that you made:

 VBA code could be created to delete objects.

Do you have a reference for this? I am going to be cleaning up a project by removing all of the extra tables, forms and queries that I put in.

They are obviously not needed. However in this process of cleaning up unneeded controls, I do not want to eliminate needed controls. I have a good
idea of what is in the db and what is needed and what is not needed. But it is not perfect.

Thus some system might work and if I use VBA code with this system, then that would be even better.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[JoeM]

Sure. Use the DeleteObject command. Actually, it looks like it can be used in Macros as well as VBA.
See:
https://msdn.microsoft.com/en-us/lib...ffice.14).aspx
and note this link how to reference the different object types:
https://msdn.microsoft.com/en-us/lib...ffice.14).aspx