Conditional printing

[brumshine]

This is a good one, get ready.....

The problem: I'm hoping it is possible to print selected pages from a single report pending weather a certain condition is met.

The details: The users of my report are being dispatched from 2 locations instead of 1. Both groups need only parts of the report pertinent to the units that report at that location. This report needs to be started by one location and print unit specific information at both. This is a very large report and it's not an option to just print the whole thing at both locations, also having the user change printers or print seperate reports is not an option.

The solution: I'm relying on your leet access skills to help me out! Any ideas/suggestions/solutions appreciated.

Thanks for your time,

BRUMSHINE

 

[HiTechCoach]

I would use two separate reports.

... having the user change printers or print seperate reports is not an option.

The user does not have to. Do it with VBA code. It can all be done with the click of a single command button. It would not takle a lot of VBA code.

Since you want one report, it may be possible with lots of vba coding and time to test it.

 

[brumshine]

Thank you very much for your suggestion Coach.

My users are use to clicking the report in the mdb file. I know it's not the best way but for them it's all they know how to do.

I really would prefer them clicking the report and hitting print then bam! it works!

 

[HiTechCoach]

I know of no way to do what you want do from the database window by just clicking on a single report.

IMHO, the users show never have to see the database window. It only makes their life harder not better.

 

[brumshine]

I agree whole heartedly. The organization I work for has a very obtrsive change control process or else that would change today! If I figure this one out on my own I will put the code up for everyone to see. Thanks for the effort Coach.