Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2007
    Location
    Harrisburg, PA
    Posts
    44

    Unanswered: How do I add a menu to a print preview window?

    Good Morning,

    I am using an example from the code bank to hide the access background:
    http://www.dbforums.com/showpost.php...9&postcount=51

    I have altered it to also hide the background when I show a report's print preview. My only problem with this, is that when you show the print preview w/o any access background, you lose ALL menus as well. I need a print button or print option for some of my less computer literate users. I personally use Ctrl+P but is there any way to get a Print option to MANUALLY show up?

    Let me know, THANK YOU!

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Using the background method in the code bank, locks the menu's at the top unless this form is closed (verses hidden). You can close the background form and re-open when the report closes, or you can setup a print menu and use that for the reports. You can create your own Print Menu via the Tools -> Customize and select that for the report's menu. Sometimes it's easiest to just close the background from and reopen when the report closes (or not use it and go the route of setting the database window to false.)
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Oct 2007
    Location
    Harrisburg, PA
    Posts
    44
    Where would I find the 2007 Tools -> Customize menu?

    I know it is in there... just cant find it.

  4. #4
    Join Date
    Nov 2003
    Posts
    1,487
    I don't know about 2007 but I'm sure it's the same as Access XP.

    - Right-Click in the Access Toolbars area;
    - Select Customize;
    - Select the Toolbars tab;
    - Select the New button;
    - Enter the name you want to call you Popup Menu (don't put spaces in);
    - A small toolbar box is displayed on screen. For now....it's a Toolbar;
    - Select the Commands tab in the Customize dialog window;
    - Select File located within the Categories List on left side of dialog;
    - Scroll down the Commands List on right side until you see Page Setup;
    - Select Page Setup and Drag it into you new Toolbar;
    - Continue locating the commands you want and drag into your Toolbar;
    - Now close you new toolbar (small X in right corner of bar)
    - Select the Toolbars tab. Notice your Toolbar name at the bottom.
    - Click on the name so that is is highlighted then select the Properties button;
    - You are now in the Toolbars Properties dialog window;
    - In the Type ComboBox, select Popup.
    - A msgbox is displayed indicating that the Toolbar will be changed to a Shortcut menu. Select the OK button
    - Close the Toolbars Propeties dialog window.
    - Now look down and select (check mark) then item named Shortcut Menus;
    - The Shortcut Menu bar is displayed on usually at top of screen;
    - Select the Custom menu bar item on right side of bar and go down the list;
    - Select your new Shortcut menu then select an actual menu item in your menu;
    - Right-Click on the menu item - you can change properties etc. here. If you select Properties then you can place one of your Code Functions into the OnAction property if you are making your own menu item...perhaps fire a Query etc.
    - When you are finished, Close the Customize Dialog window.

    Now make sure you select the name of your new Shortcut Menu into the Shortcut Menu Bar property of your Report Form.

    There

    .
    Environment:
    Self Taught In ALL Environments.....And It Shows!


  5. #5
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Before you go through all the trouble of creating a full print menu, you may want to create a small one and test it to make sure it will work. I'm still thinking you may have to close the background form but I can't remember.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •