Toggle between Print and View report?

[Franky G]

Hi,

I have 8 reports launched from my main form, at the moment I have two command buttons for each report, one for viewing and the other for printing.

Is there a way to have a toggle button (or similar) which will toggle between Print and View for all reports? This would allow just one button per report. It would also have to toggle the icons on the buttons from view to print etc.

Thanks for any help,

Franky G

 

[Chris RR]

My suggestion is entirely different.

Open the reports in print preview, and give the user a custom menu bar with the print key on it. They can look at the report, then print or not print as they see fit.

Usually, I do this by setting up a macro with "run Command"s for the "Print" and "Close" options. I set up a second macro that does an "AddMenu" using the first macro.

In the report properties, I put the name of the second macro in "Menu Bar".

Look up "menubar" in the Access Help before you try it...

 

[Franky G]

Thanks for the suggestion, although this would take to long for the users.

The Database queries a rather large oracle database, so even a print preview can take 3 or 4 mins. To mave to the last record(in print preview) takes a while to. To then print the report would just try everyone's patience a little!

So that's why I was looking for an option to go straight to print, just to save some time for the user who knows that he'll need to print the report.

Ta

Franky G

 

[Chris RR]

Why not have one combo box that lists all your reports, and two buttons, one to view, one to print?

Also, if your reports are based on regular Access queries, you might consider using SQL passthrough queries to save time.

 

[Franky G]

Thats an idea..I might do that.

As for SQL passthrough query...um..I haven't learned anything about that yet! What's it for ?

Franky

 

[Chris RR]

A SQL pass-through query is processed directly by the underlying database (in your case, Oracle). There are a couple of wonderful things about that. One is that the processing occurs at the table level...you're working with your million-row-table right there, not after you've sent all that data down through the network. Another thing is that you are working with real, genuine SQL code (and there are lots of things that you can do with that...)

Look up "pass-through_query" or "SQL_pass-through_query" in the Access help.