Results 1 to 4 of 4
  1. #1
    nick243 is offline Competent Performer
    Windows 7 64bit Access 2002
    Join Date
    May 2016
    Posts
    185

    Print Preview

    I am trying to change a report to go into print preview instead of printing right away on clicking the command. I added into the code acPreview and it goes into preview mode in my copy but when I add the same code in the network copy it prints right away.



    Copy

    Private Sub Command30_Click()
    DoCmd.OpenReport "LocationAuditPrintOutRacks", acPreview
    'DoCmd.close
    DoCmd.close acForm, "LA-SearchForm"
    End Sub

    Network

    Private Sub Command30_Click()
    DoCmd.OpenReport "LocationAuditPrintOutRacks", acPreveiw
    'DoCmd.close
    DoCmd.close acForm, "LA-SearchForm"
    End Sub


    Is there a property I can Change?


    Any Suggestions?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Is acPreview spelled correctly in the network version?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    nick243 is offline Competent Performer
    Windows 7 64bit Access 2002
    Join Date
    May 2016
    Posts
    185
    It was a spelling mistake, thanks for the help.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    No problem.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 4
    Last Post: 01-20-2016, 02:24 PM
  2. Replies: 5
    Last Post: 07-29-2014, 01:05 PM
  3. Replies: 6
    Last Post: 03-01-2014, 07:07 AM
  4. Print & Print Preview Differ
    By IDH in forum Reports
    Replies: 3
    Last Post: 07-25-2012, 09:50 AM
  5. Print Preview different from Print Hardcopy
    By peterc in forum Reports
    Replies: 4
    Last Post: 10-27-2009, 05:35 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