Macro Question

[Ray1127]

I have a macro that creates 4 tables from 4 queries. I have a 2nd macro that outputs those tables to excel spreadsheets. I would like to be able to combine everything into 1 Macro but the issue is that the macro would have to be paused so the user can validate the tables that were created and then ok the output to excel. Is this possible within a single macro?

Almost forgot this is Access 2000

 

[PHV]

I'd use VBA.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[acent]

I don't think I've ever used a macro. Even with Acc2007 trying to force you to.

I second PHV's motion on using VBA.

"If it's stupid but works, it isn't stupid."
-Murphy's Military Laws

 

[lameid]

I would probably use a popup / modal form that shows the data in a hidden sub form. Then the user would create the tables on a button click which would also makes the sub form visible and requeries the subform. Once validated, the user would click another button that closes the form.

Like the others I would use VBA... You can convert a macro to VBA code. That way you can copy and paste it to where you want it for later use.

Use the visible property to make a subform visible / not visible (invisible). Use the Requery method to update the data in the subform for viewing.

 

[Ray1127]

Thanks all, I thought I would have to do it in VBA. Thanks again

 

[randy700]

Although I also agree that I would use VBA, I fail to see the problem here. If you have a system that's working, what's the advantage to combining the two macros into one? Since the user needs to review / approve of the tables before creating the spreadsheets, there must be a button he/she must click to continue the process. Calling a 2nd macro would do the same thing as continuing the current process, would it not? In addition, it would seem that, if the user must review them first, it must be possible to reject them. Would that not be easier by having a 2nd process available?


Randy