Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Print Preview Report (Access 2000)

    Could someone take a look at this code and tell me how to phrase the report to open in PRINT PREVIEW mode instead of Print mode? Right now it's shooting right to the printer, and need a Print Preview instead.
    Thanks so very much.
    NMPadgett
    Attached Files Attached Files
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print Preview Report (Access 2000)

    .
    ...
    If strPasswd = "barton" Then
    DoCmd.OpenReport "rptSupplies", acViewPreview
    Else
    MsgBox "Sorry, you do not have access to this form", _
    vbOKOnly, "Important Information"
    Exit Sub
    End If
    ...

    Use acViewPreview as the argument for DoCmd.OpenReport. Your argument acNormal should be acViewNormal BTW.

    HTH
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print Preview Report (Access 2000)

    Thank you Steve...VERY much.
    NMPadgett <img src=/S/salute.gif border=0 alt=salute width=15 height=20>
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

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