Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Weird Printing Problem (2003 sp1)

    Well, not sure how to explain this, but its definately something to do with ms access.

    On the site server, is a ms access database, shortcuts are on approx 10 PCs spread around the site.

    2 pcs in a Lab refuse to print ms access reports (they used to ok), to a local printer, however, they will print to a network printer some distance away.

    I had one of our IT chaps reinstall the printer drivers, but no joy. I've search on Woody's and Google for anything even remotely similar and came up with a big blank nothing.

    All other people trying to print can print ok.

    The local printers are modern HP inject printers.

    I'm totally stumped, anyone have any experience of this sort of thing, or, what to check?

    The code in the database itself, to print, is:-

    <font color=blue>DoCmd.OpenReport "Report", acViewPreview</font color=blue>

    Then users are using FILE > Print.. etc.

    Then nothing is happening, no error message, nada..

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Weird Printing Problem (2003 sp1)

    What is the default printer on the problem PCs? The local printer or a network printer? Does it make a difference if you change the default printer?

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Weird Printing Problem (2003 sp1)

    Have you tried setting a breakpoint and stepping thru.

    I also notice you are up to SP1, you should probably go toat least SP2, or SP3 if you can apply the hotfix s well. I am still on SP2.

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Weird Printing Problem (2003 sp1)

    If I read your post correctly, your users can preview the report, but it won't print. Correct? What happens when they do same thing from Word?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

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