context menu unavailable on report

  • Thread starter Thread starter Randall Arnold
  • Start date Start date
R

Randall Arnold

I'm designing a database for a client and it's working for the most part.
However, there's one strange problem: on my workstation, I can right-click
on a previewed report and get the context menu that lets me print the
report. On the client's pc, the context menu never pops up. I suspect it's
his mouse (Logitech wireless) button settings, but I haven't checked yet.
He doesn't think so. Could there be something in his Access configuration
that prevents the menu from coming up?

On another note, what I'd like to do is add a command button to each report
that executes print code. However, I note the command button events are
unavailable in reports. Has anybody run into this need, and if so, what
methods do you use to print previewed reports? The File/Print menu option
prints the current form instead of the report that has the focus, so that
option is out.

Thanks,

Randall Arnold
 
On another note, what I'd like to do is add a command button to each report
that executes print code. However, I note the command button events are
unavailable in reports. Has anybody run into this need, and if so, what
methods do you use to print previewed reports? The File/Print menu option
prints the current form instead of the report that has the focus, so that
option is out.

Thanks,

Randall Arnold
Click to expand...


I have made a new FORM (i.e. REPORT FORM) with a command
button for each report. You can design the form button
for each report to either preview the report, or print
the report.

Optionally, you can make a user defined tool bar button
for REPORTS that will appear in any view.

From anywhere in your database,
click on the VIEW toolbar button to get the dropdown
menu.
Select CUSTOMIZE
Under the COMMAND tab, left hand side CATEGORIES drop
down to New Menu. On the right hand side COMANDS ,
click on New Menu and drag it up to the end of your tool
bar row, until you get a box named New Menu. Right click
on the New Menu box and get a drop down box that allows
you to name the menu. Left click on the menu button and
a blank dropdown box appears. Leave this open and
continue below.

Again under CATEGORIES select REPORTS and the list of
available reports will show in the COMMAND selection.
Highlight and drag the selected report up to your opened
menu button and place in the drop down box. Release the
mouse and the report now will show on your "new menu"
button. Repeat for any/all reports you want to add to
the button.

This button on your toolbar is now accessible from
anywhere within the database to open a report in preview
mode. If you have a printer icon on your toolbar, just
press the printer button, and the report will print.


I hope this is clearer than mud.

GShockley
 
Thanks, I'll give that a shot!

Randall Arnold

GShock said:
I have made a new FORM (i.e. REPORT FORM) with a command
button for each report. You can design the form button
for each report to either preview the report, or print
the report.

Optionally, you can make a user defined tool bar button
for REPORTS that will appear in any view.

From anywhere in your database,
click on the VIEW toolbar button to get the dropdown
menu.
Select CUSTOMIZE
Under the COMMAND tab, left hand side CATEGORIES drop
down to New Menu. On the right hand side COMANDS ,
click on New Menu and drag it up to the end of your tool
bar row, until you get a box named New Menu. Right click
on the New Menu box and get a drop down box that allows
you to name the menu. Left click on the menu button and
a blank dropdown box appears. Leave this open and
continue below.

Again under CATEGORIES select REPORTS and the list of
available reports will show in the COMMAND selection.
Highlight and drag the selected report up to your opened
menu button and place in the drop down box. Release the
mouse and the report now will show on your "new menu"
button. Repeat for any/all reports you want to add to
the button.

This button on your toolbar is now accessible from
anywhere within the database to open a report in preview
mode. If you have a printer icon on your toolbar, just
press the printer button, and the report will print.


I hope this is clearer than mud.

GShockley
Click to expand...
 
I would suggest that you actually build a custom menu bar for all reports.

In watching users look at, an view reports, 99% of the time, users prefer a
nice large full screen maximized report. In fact, they often whack the max
button.

So, now for a long time virtually ALL of my reports in the on-open event
actually include a:

docmd.Maximize

So, the report goes full screen. The real nice thing is if you include a
nice menu bar for the report, then the user gets nice full screen with JUST
the report, and that nice menu bar. The user is free to print, email, or do
whatever you want them to be able to. In other words, it is up to you to
come with a nice menu bar. Once you make that menu bar, you specify this in
the reports "other" tab.

Here is a screen shot of one my reports with that menu bar.

http://www.attcanada.net/~kallal.msn/test/test.html

If you look closely, most of menu bar is taken from the standard menu bar.
However, I do have some custom options like "email", or print to a specific
printer option.

You can also specify a custom tool bar for a report, but I find that nice
menu bar works well. Further, I set that menu bar to not be moveable, and it
is fixed on the top of screen.

Further, I generally give users a nice form to launch the report. Here is
some screen shots of some reports to give you an idea.

http://www.attcanada.net/~kallal.msn/ridesrpt/ridesrpt.html
 
Back
Top