Preview/Printing Reports

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • drtitus7759
    New Member
    • Nov 2007
    • 10

    Preview/Printing Reports

    I have an access database with an extensive amount of VBA. I am creating reports based on queries and parameter forms. In the production database everything is modal and accessed via forms. No access is given to the ms-access screens. I control all access via forms with buttons, etc. When running a report I would like to display a preview, then print if the user wishes. I do not give the user any menu bars or toolbars. How can I accomplish. Currently after displaying the report, and the user closing it, I ask if they want it printed, but of course it re-prompts with the parameter form. Is there a way around this?
    Dave
  • ADezii
    Recognized Expert Expert
    • Apr 2006
    • 8834

    #2
    Originally posted by drtitus7759
    I have an access database with an extensive amount of VBA. I am creating reports based on queries and parameter forms. In the production database everything is modal and accessed via forms. No access is given to the ms-access screens. I control all access via forms with buttons, etc. When running a report I would like to display a preview, then print if the user wishes. I do not give the user any menu bars or toolbars. How can I accomplish. Currently after displaying the report, and the user closing it, I ask if they want it printed, but of course it re-prompts with the parameter form. Is there a way around this?
    Dave
    Why not assign a Custom Menu Bar or Toolbar to the Report which consists of only 2 Options, namely, Print Report or Exit?

    Comment

    Working...