Printer Problem

[dinadvani via AccessMonster.com]

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

 

[dinadvani via AccessMonster.com]

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?

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

Hi All,

[quoted text clipped - 15 lines]

Regards,
DA

 

[Allen Browne]

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

 

[Allen Browne]

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia

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

Regards,
DA

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

Hi All,

[quoted text clipped - 15 lines]

Regards,
DA

 

[dinadvani via AccessMonster.com]

Thanks a lot for your help.

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

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]