I have problems with importing macros (and other objects) from another db and finding that a macro, somehow refers to a non-existent field, expression, table, etc. It would be nice to have a routine that examines all macros for the text string that you suspect is missing.

Short of buying a copy of "Speed Ferret", is there any way to have a VBA procedure cycle through all macros and retrieve any useful information about each of them?

I know that you can do something like the following:

-- (the syntax may be off ... I am doing this from memory:

Dim obj as AccessObject
dim dbs as Access.Application

Set dbs = Application.CurrentProject

For Each obj in dbs.AllMacros
     Debug.Print obj.Name
next obj

etc.
---------------

What I don't know is what other info you can retrieve from a macro such as: Date Created, Date Modified, Conditional Expression, Action, Arguments, etc.

Can you suggest a method?



--- Tom

__________________
--- Tom