Results 1 to 5 of 5
  1. #1
    Kundan is offline Competent Performer
    Windows XP Access 2013 32bit
    Join Date
    Mar 2018
    Posts
    155

    Printing of Report


    In attached DB I have written a code on Frm_Regn to print a report. But it is giving error. Please guide me. Also I would like to know how the code should be to print the report directly without print Preview.
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Maybe if you just post the code and error details, won't have to take time and effort to download db and run procedure.

    Direct to printer (acViewNormal) is the default if destination not otherwise specified.

    DoCmd.OpenReport "report name"
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Minty is offline VIP
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    I've made some changes to your code and added a commented out example of how to print directly.

    As June pointed out you'll get a much better response by simply posting up your code.
    HMS.zip
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  4. #4
    Kundan is offline Competent Performer
    Windows XP Access 2013 32bit
    Join Date
    Mar 2018
    Posts
    155
    Quote Originally Posted by June7 View Post
    Maybe if you just post the code and error details, won't have to take time and effort to download db and run procedure.

    Direct to printer (acViewNormal) is the default if destination not otherwise specified.

    DoCmd.OpenReport "report name"
    Thanks a Lot!!! GOD BLESS YOU!!!!!!!!!!

  5. #5
    Kundan is offline Competent Performer
    Windows XP Access 2013 32bit
    Join Date
    Mar 2018
    Posts
    155
    Quote Originally Posted by Minty View Post
    I've made some changes to your code and added a commented out example of how to print directly.

    As June pointed out you'll get a much better response by simply posting up your code.
    HMS.zip

    Thanks a Lot!!! GOD BLESS YOU!!!!!!!!!!

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

Similar Threads

  1. Printing A Report
    By Eranka in forum Access
    Replies: 1
    Last Post: 05-31-2018, 10:33 PM
  2. Report printing extra pages of the same report.
    By khughes46 in forum Reports
    Replies: 5
    Last Post: 06-19-2014, 07:39 AM
  3. Printing report
    By undee69 in forum Forms
    Replies: 1
    Last Post: 06-26-2012, 08:10 PM
  4. Report printing
    By Andrevw in forum Reports
    Replies: 1
    Last Post: 01-16-2011, 06:08 PM
  5. Report Printing
    By newtoAccess in forum Reports
    Replies: 5
    Last Post: 12-02-2009, 07:46 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