Hide Macro activity and show timer

[humph]

Hi folks I have a macro that opens and closes a number of forms and then prints. The screen shows what is happening very quickly and annoyingly.

Can I hide the actions and possibly show the timer.

Thanks again

 

[pbaldy]

I would first wonder what it's doing when it opens and closes forms. It could be that there's a more efficient way of accomplishing the goal that avoids all that.

 

[humph]

Hi Paul

It is an auction database and using the macro I am running some update queries and then printing two different forms and then reseting various indicators.

Query updates the invoice number and date to one table, adds other data input immediaitely prior to the macro to another and then prints two different forms from queries using combinations of data. Bit difficult to explain in words but hope you get the gist.

It is possible there is a better way but thats the current approach Database has grown somewhat since first inception and possible beyond original design. It does all work but just the continual screen flickering looks wrong.

 

[pbaldy]

Well, look at the Echo macro action and see if it does what you want.

 

[Singh400]

Isn't there an option to hide the form in OpenForm arguments in the macro settings?

 

[humph]

Had a quick look and found the setting but now seems to want to print the macro definition. Appreciate the speed of response and will look at this again tomorrow in case I have done something silly. .

Thanks

David

 

[humph]

Hi The echo options works - apparently can't hide the printing flash.

Thanks again