Switchboard Question In 2007

  • Thread starter Thread starter Jeff Garrison
  • Start date Start date
J

Jeff Garrison

All -

In Switchboard Manager, there is an option to Open Report. On the Report
I'm trying to open, I have set the default view to Print Preview and Allow
Report View and Allow Layout View to No, as I want the user to see the
Report and print it. When I try to open the Report using the Switchboard I
get an error saying "Report view is not available for this report." I don't
want the Report View, just the Print Preview. Is there a way to have the
Switchboard open the Report in Print Preview vs it trying to open in Report
View?

Thanks

JeffG
 
Hi Jeff

The switchboard is rather limited in its built-in capabilities, but I
believe it does have an option to run some code.

With code, you can do *anything*, so just write a VBA function to open your
report as you require, and then run that function from the switchboard
button.
 

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

Switchboard not opening report in print preview 1
Report opens behind switchboard 1
Creating a table in switchBoard 0
How do I open my report in print preview mode in Access? 3
Print view using switchboard in Access 1
Error "The OpenReport" action was canceled" 1
Maximize Switchboard - Access 2007 3
custom switchboard with parameter query command 1

Back
Top