Hi All
What I have is a table with a list of Function, what I'm trying to do is loop through the table an CALL each Function in turn if it is marked as "Active".
My idea was instead of Function names, have Macro names, these macros would contain the Function I want to run. I could then pass the Macro name into the run code & use docmd.run macro.
So my questions are....
is there a better way to do the above?
and
is it possible to build an Access Macro using VB?
Hope this makes sense
Thanks
Jon
What I have is a table with a list of Function, what I'm trying to do is loop through the table an CALL each Function in turn if it is marked as "Active".
My idea was instead of Function names, have Macro names, these macros would contain the Function I want to run. I could then pass the Macro name into the run code & use docmd.run macro.
So my questions are....
is there a better way to do the above?
and
is it possible to build an Access Macro using VB?
Hope this makes sense
Thanks
Jon