Read a macro line by line from VB?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This arises from the unhelpful way in which Access runs queries and macros -
the status line says something like 'Processing query' with a time bar, but
does not say which query!

I got fed up with this over-discrete approach and in a few cases have
stuffed the actions (eg action type, object name) of macros into a table - a
prcedure ploughs through the table and reports the action being performed and
the numbers of records affected. All very nice, but why not process the
original macro to do the same thing?

I have more than a sneaking suspicion that an Access macro is actually a
table, with columns for action, objectid, comments etc. Any ideas?

Ys H

Programming is a hobby!
 
MSysMacros

I never used Access 1.0, but in Access 2.0, most things were tables,
the forms were Access forms, and the utilities were written in Access
Basic.


The developers had obviously been influenced by the ideas of relational
database design (the database system stored in the database), and
were open to the idea that Access might be used as a tool to develop
applications. Also, the application was multi-user because the data
was stored in a multi-user database.

In A2K, none of the utilities or wizards are written in Access, the
application forms aren't Access forms, and you need exclusive access
to modify the vba project.

And you won't see that table.

(david)
 
David
Thinking about your reply - possibly MSysMacros is no more, but the macros
are listed in the system table MSysObjects, all with a common ParentId
(-2147483644 = Scripts). Access must have a way of "reading" a particular
object ....
 
Back
Top