Printer Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dinadvani - 02 Jan 2007 07:04 GMT

Hi All,

Firstly thanks for helping me and wish you a great New Year

I have a form that contains 5 different reports with command buttons"Print",
"Preview" and "Cancel"

Now everything is working fine only problem is when i select 1 report and say
"Print" it goes to Microsofte image witer. Although I changed my default
printer to the printer i desire to print the report, but still no use. Note:
printer is on network

Please Help.

Regards,
DA

Reply to this Message

Allen Browne - 02 Jan 2007 07:39 GMT

What version of Access is this?

Name AutoCorrect can give this problem. Uncheck the Name AutoCorrect boxes
under:
Tools | Options | General | Name AutoCorrect
Then compact the database:
Tools | Database Utilities | Compact/Repair
More information about this bug:
http://allenbrowne.com/bug-03.html

Access 2007 has a bug where it fails to even store a specific printer for
the report.

In Access 2002 and later, there is a Printer object you can set to the
printer you want before you OpenReport. Just:
Set Application.Printer = Application.Printers("xxxx")
where xxxx is the name of the printer as known to Access. Example:
http://allenbrowne.com/AppPrintMgtCode.html#UsePrinter

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi All,
>
[quoted text clipped - 15 lines]
> Regards,
> DA

Reply to this Message

dinadvani - 02 Jan 2007 08:27 GMT

Thanks for your reply, It is Access 2000 version. I tried unchecking Auto
correct and then Compact/Repair but its no use. Please advice

Regards,
DA

>What version of Access is this?
>
[quoted text clipped - 20 lines]
>> Regards,
>> DA

Reply to this Message

Allen Browne - 02 Jan 2007 09:55 GMT

Okay, let's try to be specific here.

1. Open the report in *Design* view.
2. Chose Page Setup from the File menu.
3. On the middle tab of the dialog, click button for Specific Printer.
4. Choose the printer you want, and click Ok to close both dialogs.
5. Back in report design view, click Save.

The report should now go to the specific printer.
If not, something else is wrong.

There is another solution you can download here:
http://www.members.shaw.ca/AlbertKallal/msaccess/printch2k.zip

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Thanks for your reply, It is Access 2000 version. I tried unchecking Auto
> correct and then Compact/Repair but its no use. Please advice
[quoted text clipped - 26 lines]
>>> Regards,
>>> DA

Reply to this Message

dinadvani - 02 Jan 2007 11:07 GMT

Thanks a lot for your help.

>Okay, let's try to be specific here.
>
[quoted text clipped - 15 lines]
>>>> Regards,
>>>> DA

Reply to this Message