Commands in Reports

G

Guest

I want to display a report, then give the person viewing the report options
such as print, exit, return to formx, etc. With a form I would simply put in
a command button. How do I do this on a reprt?
 
G

Guest

Hi, ANStech.

The way I do it is to display an input form with the various options and a
command button to preview the report.

Sprinks
 
V

Van T. Dinh

Not in the Report. However, in the Procedure that you use to open the
Report, you can also open a small Pop-up Form with CommandButtons for Print,
Exit, etc ...
 
G

Guest

You can also create a custom toolbar with the desired buttons that is only
visable when the report opens in preview.
 
G

Guest

Hi! This is exactly what I'm looking for. Has locked the entire application
with the
'AllowByPassKey'-routine and want a custom toolbare when any report is
visible. By default ALL toolbars are off, and all functions I want the user
to have are made available through buttons on the form.

How do I do this in detail?


Thanx,
JK
 
G

Guest

I want to do a similar thing (I think). I have a switchboard set up, one of
the buttons is set to Preview a certain report. When the button is selected,
a parameter query appears and the report parameters are selected, then the
report is displayed, no issue there. I want to be able to have users Print
the report (as it appears) or to close the report and return to the
switchboard form.
I've been working on this database for months and am just tying up the loose
ends for a presentation next week.
Help!!!
 
G

George Nicholson

The best answer I've ever found is to create a "Custom PrintPreview" toolbar
and then specify your toolbar in the Report's Toolbar property (read that
as: specify it as the Toolbar property for each and every report). At it's
simplest, you can simply copy the pieces from the built-in one onto a custom
one (maybe modify "Close" to a more explicit "Return To Form"?). The Access
Print Preview toolbar is similar enough to Print Preview in Excel and Word
that user's should be able to easily grasp the operation.

In addition, if you rely on the built-in PrintPreview toolbar, a user
(assuming if you allow them customization privledges) might "uncheck" the
regular PrintPreview toolbar (why they would knowingly do this is a mystery,
but they *could*...). This would mean that it might not appear the next time
the report was opened which might prevent them from having any option to
Print. By specifying your own toolbar as a property of the report, it's
guaranteed to appear regardless of what the user might have done, or how
you've set "Allow BuiltIn Toolbars", etc.

And if you are designing for Runtime users, none of this would be optional.
You'd have to create your own anyway, so it sort of becomes standard
procedure if you do a lot of Access developement.

Plus, AFAIK, the Print Preview interface doesn't really allow you to do much
of anything else :)

HTH,
 
G

Guest

George, you are a genius! I know I had tried that before, but wasn't
specifying the printer toolbar in the report properties. Duh! It works just
fine, thank you so much!

Linda
 
G

Guest

I appreciate the help on this topic, but I've run into a snag - when I close
out of my report, the switchboard is not fully open. Where do I add the
 
G

Guest

Whoops - I posted before I finished typing...

Where do I add the code to maximize the switchboard document? I couldn't
find the proper place in the switchboard code. Is there code for the tool bar?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top