Macro Creation

[lucy1216]

I have my report built and is tied to a query. Some background on this: I need to send out approval reports to supervisors for telecom bills. The query is built so that no criteria is specified in the Approver field.

I want to build a macro that will process all approvers, one at a time, and generate reports to the snapshot viewer.

I am pretty new to access and I am not familiar with VB or XML coding. I have the macro built for the first record, but I don't know how to "do until end" type scenario.

Can this be done using the macro actions and not writing code? I am on Access 2003.

[HiTechCoach]

I do not think it is possible to do it with just macros in Access 2003.

Macros are very limited in error handling. For this type of task, I do believe that VBA code would be best.

Will you consider using VBA code?

[lucy1216]

Yes, but I know nothing on how to use it. Can you assist me?

[HiTechCoach]

If you are willing to try VBA code, then I will be glad to assist you.

Would you like to see a working example?

[HiTechCoach]

For a Snapshot file see:

Batch Printing

For Access 2007/2010 to a PDF see:

Batch Printing and Save As PDF