Results 1 to 7 of 7
  1. #1
    omer123456 is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Sep 2017
    Posts
    13

    auto print

    Hi,

    If you look at the report in this file, I have to manually open it, manually print 2 copies, & then manually close this report.

    Can this be automated.......once report is open , it prints X copies (user defined) & closes the report.



    thanks
    Attached Files Attached Files

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    This is Access 101, and your database is so simple it barely exists. You have no forms to display/edit/add to your table. You have no form to present any print options to a user for the report.
    Suggest you spend a bit more time on database design, form design, and User interface. Use Google.

  3. #3
    omer123456 is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Sep 2017
    Posts
    13
    I am looking for functionality...........not critique

    thanks anyway

  4. #4
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    This is untested, but usually you can set up print options in the design view of the report. This works for orientation and margins, etc, but don't know about number of copies. Then create a macro to print the form, you can additionally create a form with a button which runs the macro. You can make it do it twice!

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    One way would be to put the OpenReport command behind a button, twice. You could also use a form textbox for a variable number of copies.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  6. #6
    omer123456 is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Sep 2017
    Posts
    13
    thx , I will try

    Quote Originally Posted by aytee111 View Post
    This is untested, but usually you can set up print options in the design view of the report. This works for orientation and margins, etc, but don't know about number of copies. Then create a macro to print the form, you can additionally create a form with a button which runs the macro. You can make it do it twice!

  7. #7
    omer123456 is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Sep 2017
    Posts
    13
    that's a good idea. thanks

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

Similar Threads

  1. Replies: 5
    Last Post: 07-29-2014, 01:05 PM
  2. Replies: 6
    Last Post: 03-01-2014, 07:07 AM
  3. How to print receipt with auto number
    By jalals in forum Programming
    Replies: 1
    Last Post: 04-05-2013, 06:46 AM
  4. Replies: 5
    Last Post: 10-26-2011, 02:59 PM
  5. Auto Print Report for each record in table...
    By access32 in forum Reports
    Replies: 1
    Last Post: 12-17-2010, 11:46 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