Results 1 to 4 of 4
  1. #1
    justphilip2003 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2013
    Location
    Ohio
    Posts
    125

    Help, acViewPreview not executing as expected

    I have a form with a button that invokes the Event Procedure


    Private Sub Command25_Click()
    ' print report on wood types
    DoCmd.OpenReport"TypesofWoodR", , , , , acViewPreview
    End Sub
    I expected the acViewPreview to cause an options previewbefore printing. It did no pause but printed directly. Is my understanding of this constant wrong or have I erred in my coding? TIA Phil

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    expression.OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs)

    Try:
    DoCmd.OpenReport"TypesofWoodR", acViewPreview

  3. #3
    justphilip2003 is offline Competent Performer
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2013
    Location
    Ohio
    Posts
    125
    Thanks for responding. I made the change and it works as expected. Thanks again. Phil

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Glad we could help.

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

Similar Threads

  1. acViewPreview command suddenly not working
    By kelann in forum Reports
    Replies: 2
    Last Post: 10-16-2012, 07:38 AM
  2. Need Help executing an update in form
    By ismith in forum Forms
    Replies: 17
    Last Post: 01-20-2012, 08:42 AM
  3. Executing Query to Excel?
    By objNoob in forum Programming
    Replies: 1
    Last Post: 03-17-2010, 04:59 PM
  4. Executing .BAT file from Access
    By NoiCe in forum Programming
    Replies: 23
    Last Post: 03-02-2010, 09:36 PM
  5. How get path of executing database?
    By mscertified in forum Forms
    Replies: 3
    Last Post: 11-09-2005, 03:56 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