Results 1 to 7 of 7
  1. #1
    Drisconsult is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Jul 2010
    Posts
    15

    Problem with Print Preview

    Hello All

    I have a problem with print preview. The problem is that this particular issue does not occur in 20 other print programs on my school database using the same procedure.

    I can load the Report from the Navigation Pane in Print Preview, but when loading from a Macro on a Form, it goes straight to Report View and I cannot print the Report. If you want more details, please let me know. I have set the Default View to Print Preview in the Query.



    Driving me nuts.
    Terence Driscoll

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,859
    Well, as it behaves completely differently to those of your other reports, why not compare what might be different?

    What you have supplied is pretty much useless? How is anyone meant to guess anything from what you have posted?
    You need to help us to help you?

    Supply a DB with enough data to replicate the problem and explicit instructions on how to replicate the issue.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I have set the Default View to Print Preview in the Query.
    I had to look - have never heard of opening a query in print preview. Turns out it is a thing (in macros).
    Maybe that's your issue, but I don't see the connection between opening a query and the problem you're having with opening the report in print preview.

    What are "print programs" ?
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    The underlying query is irrelevant.
    When you use a macro to open a report, set the view to print preview and the window mode to normal.
    The preview should then appear.

    I suspect you wrongly set the window mode to dialog in which case the report opens in report view as a popup with no ribbon. That is intended behaviour

    However, end users should never open anything via the navigation pane.
    All interaction should be via forms only

    I suggest you scrap the macro. Use code from a form button to open the report
    Code:
    DoCmd.OpenReport "ReportName", acPrintPreview
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    Drisconsult is offline Novice
    Windows XP Access 2002 (version 10.0)
    Join Date
    Jul 2010
    Posts
    15
    Why am I having to continuously login. After virtually every time I try to insert a PDF, I have to login again.

  6. #6
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,859
    Crossposted at https://www.access-programmers.co.uk...report.325572/

    Crosspost reply appears to have the solution as well?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  7. #7
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Why have you cross-posted at AWF & completely ignored the answer I gave in post #4?
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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

Similar Threads

  1. Replies: 1
    Last Post: 06-21-2022, 02:39 AM
  2. Replies: 4
    Last Post: 12-18-2015, 06:58 AM
  3. Print preview problem
    By Delacour in forum Access
    Replies: 5
    Last Post: 01-09-2012, 01:26 PM
  4. Replies: 1
    Last Post: 01-10-2011, 01:08 PM
  5. Form print preview problem
    By kloss1a in forum Forms
    Replies: 3
    Last Post: 01-03-2011, 12:12 AM

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