4
4547
I'm developing a tool in VBA to help me debug the various Access databases I
am asked to support. More specifically, I want to know what Access objects
depend on each query and table. I have already figured out ways to do this
for queries and reports. Now I want to enumerate the Macros collection and
parse each row of the macro to see if the Object Type = "Report" and then
get the Object Name. The problem I've run into is the AccessObject of
dbs.AllMacros does not contain this detail and unlike reports with the
Reports() collection, there is not a collection available of the open
Macros.
Does anyone have information on how to get the details of a macro through
VBA in Access 2000? I've searched thourgh a lot of forums and haven't come
across any question close to this one.
Thanks,
Ben
Pittsburgh, PA
am asked to support. More specifically, I want to know what Access objects
depend on each query and table. I have already figured out ways to do this
for queries and reports. Now I want to enumerate the Macros collection and
parse each row of the macro to see if the Object Type = "Report" and then
get the Object Name. The problem I've run into is the AccessObject of
dbs.AllMacros does not contain this detail and unlike reports with the
Reports() collection, there is not a collection available of the open
Macros.
Does anyone have information on how to get the details of a macro through
VBA in Access 2000? I've searched thourgh a lot of forums and haven't come
across any question close to this one.
Thanks,
Ben
Pittsburgh, PA