Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Manchester, Gtr Manchester, England
    Thanked 0 Times in 0 Posts

    Printer wierdness (XP/2000)

    I've found some code a colleague wrote a couple of years ago.

    Basically it looks through a recordset, opening the report for a single record at at time and uses an attribute of the record to set part of the report caption.

    For each record, the report is opened in preview mode, its caption is set to be a path and file name (complete with file extension '.pdf') and then it is printed using DoCmd.Printout. The report is then closed and the loop repeats.

    By using Jaws pdf as the default printer, correctly named pdfs are then created in the correct folders without any user intervention. This handy quirk didn't work with any other pdf printers/writers.

    I though this would be useful for something I'm doing now, however, Access is behaving a little oddly.

    The report is being sent to a printer I don't have on my system, even though its print settings are set to 'use default printer'
    The printer appears to be one in a different office (where my colleague who is using the db works).

    Any ideas?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Printer wierdness (XP/2000)

    Try setting the report for a specific printer, then set it back to the default printer.
    If that doesn't help, try changing your default printer in the Printers and Fax Devices control panel, then set it back to the original one.
    Sometimes actions like these help to restore things to normal.

Posting Permissions

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