List Macro Objects

asked 2022-06-02T14:41:38.92+00:00
Richard Lee 1 Reputation point

In Microsoft Access I need to Find an Object (query, table, for, function) in side of a Macro. I have hundreds of Macros and I need to find a specific Object within one of the Macros. How do I find this Object being used in side a Macro or Macro's?

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
726 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2022-06-03T13:41:55.707+00:00
    Karl Donaubauer 1,466 Reputation points

    Hi,

    I would use a tool like Find and Replace for MS Access (30 days trial).

    Another method to search in macros is to export them as text using the (hidden) VBA command SaveAsText and then search in the text files.

    Servus
    Karl
    Access News
    Access DevCon

    No comments