Results 1 to 2 of 2
  1. #1
    gavparker is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    1

    Access beginner - using a report to print a record

    Hi there



    I'm new to this site and new to Access. I've created a basic database which requires a user to enter data before allowing them to print this data in a formatted report.

    I can not quite get the report printing feature working properly. I have created a query enterAJobNumber which requires the user to enter the invoice number (primary key). When this is entered, the relevant invoice appears and the user can save/preview/print it. This is too long-winded. I have a form named maintenanceIndexOli. When in this form, I'd like a Print button which produces a report based on that record and prints it automatically.

    I guess this would be achieved by taking the Invoice Number field data and copying this into the query enterAJobNumberautomatically. Quite how to do this is beyond me. I would be grateful if someone could help me with this.

    I'd also like the user to be able to save a report as a PDF. Is this possible with Access? I'd like a button on the form maintenanceIndexOli which opens the relevant report and allows the user to save it as a PDF.

    Any help is much appreciated.

  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
    Maybe this link will get you a little further along: http://access.mvps.org/access/reports/rpt0002.htm

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

Similar Threads

  1. Print Report from Current Record
    By hnkford in forum Reports
    Replies: 15
    Last Post: 05-22-2015, 08:08 AM
  2. =Report won't Print each record on page
    By ashbear in forum Reports
    Replies: 17
    Last Post: 06-13-2013, 04:04 PM
  3. Print current record to a report
    By drawc in forum Access
    Replies: 2
    Last Post: 01-15-2012, 12:48 AM
  4. Print Report by clicking record
    By jamil_kwi in forum Reports
    Replies: 1
    Last Post: 10-05-2010, 08:23 AM
  5. How to print a single Record's report?
    By yes sir in forum Access
    Replies: 7
    Last Post: 09-20-2010, 07:31 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