Results 1 to 5 of 5
  1. #1
    HybridOzone is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Posts
    5

    Exclamation Help needed when printing - Printing always opens the Navigation Pane, How do I stop this?

    Hello....

    I have built a database to look after our company Customer Details and Quality Complaints.
    The database is split into Front/Back end and the FE application is distributed between users.
    It is limited on the FE application so it only allows a startup form which then drives all other forms, queries & reports.
    The Navigation Pane is hidden as default in File/Options/Current Database.
    Many of the forms/reports are printable and have a button that has been autogenerated (add button) during the design phase.
    As soon as anything is printed the Navigation Pane opens and becomes accessible for all.

    I have looked at many forums and cannot find anything that remotely associates with this problem.
    I also cannot find any VBA that will stop this happening only VBA to hide the Pane.

    Please see pictures below:

    1. Before clicking "Print" on form


    Click image for larger version. 

Name:	Capture2.PNG 
Views:	15 
Size:	10.8 KB 
ID:	38102
    2. After clicking "Print" on form
    Click image for larger version. 

Name:	Capture3.PNG 
Views:	15 
Size:	25.1 KB 
ID:	38103

    I will appreciate any/all solutions, ideas or assistance with this issue as the last thing I want is to give basic users access to the various forms, queries and reports in the FE application.

    Thanks

  2. #2
    Minty is offline VIP
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    2,991
    What is the code behind the print button ?
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    HybridOzone is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Posts
    5
    As this is a macro from the built in Macro builder>

    Click image for larger version. 

Name:	Capture4.PNG 
Views:	14 
Size:	7.1 KB 
ID:	38111

    I know I should really be using VBA. I am relatively new and self taught in Access and only just started using VBA.
    If there is a VBA alternative then I would be very happy to know about it c",

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,752
    Well, I can't fix the macro but VBA does not open the pane.

    DoCmd.PrintOut acPrintAll
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    HybridOzone is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2019
    Posts
    5
    Perfect June7!!!
    So simple and yet so effective.....I really need to do a VBA course as this simple line has totally removed my issue.

    Thanks for your support this is solved

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 08-28-2016, 03:52 PM
  2. Printing macro help needed.
    By UnclearMist in forum Macros
    Replies: 1
    Last Post: 08-03-2014, 02:11 PM
  3. Help with Form navigation and printing
    By Ak619mcc in forum Access
    Replies: 1
    Last Post: 03-25-2013, 02:22 PM
  4. help needed with printing individual forms
    By mattijsstu in forum Forms
    Replies: 1
    Last Post: 03-15-2013, 08:08 AM
  5. Replies: 1
    Last Post: 11-10-2009, 03:03 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums