+ Reply to Thread
Results 1 to 8 of 8

Print with Access 2007

Hybrid View

  1. #1
    Registered User
    Join Date
    02-22-2013
    Location
    UK
    MS-Off Ver
    Office 2007
    Posts
    5

    Angry Print with Access 2007

    Hi,

    I created a database with Access 2007. This database is on a network so few different users has got access in the same time.
    I need to print some documents but I have to print them on a special paper.

    At the minute, when we need to print, we need to ask everybody to stop printing ; we insert the special paper in the printer. This is not a long term solution and I can't find the solution with the VBA language.

    I found 2 solutions but I don't know if it's possible and how to do it :
    - There is 4 trays into the printer. I would like that each time we are going to print, the database know to use tray 3 out of the printer. We not need to change the settings every time so need to be set as default printer but only for this database not all access ?
    Is it possible ? If yes, how ?

    - Buy a small printer which has got only 1 tray with the specific paper only. But is it possible to set it up as only this database will use this printer ? Need to be set up the same for the all users.
    Is it possible ? If yes, how ?

    What is the best solution ? Any recommendations ? Or other solutions ?

    Many thanks for your help

    Amelie

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: Print with Access 2007

    Amelie

    What are you printing?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    02-22-2013
    Location
    UK
    MS-Off Ver
    Office 2007
    Posts
    5

    Re: Print with Access 2007

    It's collection note on a carbon paper (3 different sheets)

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: Print with Access 2007

    Is it a report, a form, a query...?

    If it's a report then you can use Page Setup to specify the printer and the tray you want to use for that particular report.

  5. #5
    Registered User
    Join Date
    02-22-2013
    Location
    UK
    MS-Off Ver
    Office 2007
    Posts
    5

    Re: Print with Access 2007

    It's from a report.
    How the Page Setup work please ?

  6. #6
    Registered User
    Join Date
    02-22-2013
    Location
    UK
    MS-Off Ver
    Office 2007
    Posts
    5

    Re: Print with Access 2007

    It's from a report.
    How the Page Setup work please ?

  7. #7
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: Print with Access 2007

    Open the report in Design View.

    Under Report Layout Tools select Page Setup.

    Click Page Setup, select the Page tab and select Specific Printer...

    Choose the printer you want from the dropdown, click Properties... and select the required tray from the Paper Source dropdown.

    Change any other settings you need to and OK back out of all the dialogs.

  8. #8
    Registered User
    Join Date
    02-22-2013
    Location
    UK
    MS-Off Ver
    Office 2007
    Posts
    5

    Re: Print with Access 2007

    Thank you very much !!!
    Just tried and it work !!

    Many thanks again

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Importing latest entry from a field in Access 2007 into Excel 2007
    By swerider in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-29-2013, 11:53 AM
  2. how to obtain database connectivity between Excel 2007 and Access 2007
    By geeta bidwai in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2012, 06:00 AM
  3. [SOLVED] Access 2007 or Excel 2007 Question
    By russkris in forum Access Tables & Databases
    Replies: 2
    Last Post: 10-24-2009, 03:57 AM
  4. how to print single record in report in Access 2007
    By humpz in forum Access Tables & Databases
    Replies: 0
    Last Post: 08-01-2009, 11:24 AM
  5. excel 2007 macro - connect to access 2007 database
    By .paul. in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-17-2009, 01:41 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1