Printing from a "print preveiw" view

[wolfie78uk]

Hi,

I have been asked to perfom some modifications to an application that I wrote a couple of years ago in Access/VB. Unfortunately, I have spent most of my time since programming in Java and have become VERY rusty in the ways of Access/VB. What I am trying to achieve should be very simple. I have an existing report that serves my client's needs but they wish to select which pages of the report they can print off - currently I have a macro that prints the entire report straight to the printer. This is not a problem as I have written some code to bring up the print dialog instead of printing the report straight to the printer.

However, from an HCI perspective it would be useful for my client to be able to "print preview" the report in order to make the decision on which pages they wish to print off.
This is where my problem lies. I want to view the report in print preview and then give the client "Print" and "Exit" option buttons but I don't want to embed those buttons in the report because I don't like the way they look. So, I either want to a) be able to embed the "print preview" in a form and include the option buttons on that form or b) include some sort of custom toolbar (which I don't know how to do ).

Incidentally, I have removed all toolbars etc from the customers application and made it modal so that they can't alter anything they shouldn't so the normal File,Edit menus aren't there either - it is all customised. Perhaps not what I would do if I had to write it again but that is what I am stuck with.

Thanks in advance,

Simon

 

[batteam]

I believe that once the report is showing (in preview mode) on the users screen, pressing Ctrl + P will open a dialogue box that will let the user choose which (and how many) pages of the report to print. Hope this helps.