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: 71
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: 34,135
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: 71
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: 34,135
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    17th December 2018 - 03:07 PM