UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> List Of Macros From Access Form Procedure, Access 2013    
 
   
highnndry
post Jan 17 2018, 02:48 PM
Post#1



Posts: 64
Joined: 9-October 13



Hi,

I have a form in Access that triggers events when I run it. Is there a way to get the list of Macros for that specific event.

So I have 3 text box with selection:
Module
Process
Action

After I select from those three box it starts a list of macros that run one after another. I would like to find out which macros are running?

Hope I explained it.
Go to the top of the page
 
GroverParkGeorge
post Jan 17 2018, 04:53 PM
Post#2


UA Admin
Posts: 32,787
Joined: 20-June 02
From: Newcastle, WA


Since you are using Macros, rather than VBA, this is more difficult to do, but feasible.

One thing you could do is add a line that creates some sort of output as each macro runs so that you can review those outputs at the end of the processing cycle.

Maybe write a record to a table.


Another option is to step through the macros one action at a time, manually.


--------------------
Go to the top of the page
 
highnndry
post Jan 17 2018, 05:07 PM
Post#3



Posts: 64
Joined: 9-October 13



That is where I'm having the problem, because I do not know which Macros to step thru? That is why I want to find out which Macros are triggered when I click run in the form.
Go to the top of the page
 
GroverParkGeorge
post Jan 17 2018, 07:12 PM
Post#4


UA Admin
Posts: 32,787
Joined: 20-June 02
From: Newcastle, WA


Then the first option would be the best.

Create a table and use a macro action to write the name of each macro to that table as it runs, along with the date and time.

--------------------
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    19th June 2018 - 05:18 PM