Results 1 to 1 of 1
  1. #1
    degras is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Nov 2010
    Posts
    72

    Print report playing up and print button disabled

    I have a report which can be run via a button on a form. The button runs some VBA code:

    If Me.Dirty Then 'Save any edits.
    Me.Dirty = False
    End If
    If Me.NewRecord Then 'Check there is a record to print
    MsgBox "First save this record and then select a record to print"
    End If


    If Me.NewRecord = False Then
    DoCmd.OpenReport "MultiInvoice", acViewPreview, , "InvoiceNo = '" & Me.InvoiceNo & "'", , "NoGroup"
    End If

    Once when I clicked on the button and then clicked "print" on the Access menu, strangely what was printed was the form and not the report.

    Now when I try to repeat this, the Access "print" button is always disabled.

    Any ideas as to why these things are happening?

    ... Update: I restarted Access and tried this again and it worked OK, so it must have been some glitch in Access.
    Last edited by degras; 02-22-2011 at 07:13 AM.

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

Similar Threads

  1. Print Preview different from Print Hardcopy
    By peterc in forum Reports
    Replies: 4
    Last Post: 10-27-2009, 05:35 AM
  2. Error in Print Report Button
    By Robert M in forum Reports
    Replies: 16
    Last Post: 09-23-2009, 03:08 PM
  3. Error when trying to print or print preview
    By TriAdX in forum Reports
    Replies: 8
    Last Post: 08-25-2009, 08:20 AM
  4. add a print button
    By gromit95 in forum Forms
    Replies: 0
    Last Post: 08-13-2008, 07:28 AM
  5. Replies: 3
    Last Post: 03-24-2006, 08:40 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