Printer Problem

  • Thread starter Thread starter dinadvani via AccessMonster.com
  • Start date Start date
D

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
 
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


Allen said:
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,
Click to expand...
[quoted text clipped - 15 lines]
Regards,
DA
Click to expand...
Click to expand...
 
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
 
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.

dinadvani via AccessMonster.com said:
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


Allen said:
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,
Click to expand...
[quoted text clipped - 15 lines]
Regards,
DA
Click to expand...
Click to expand...
Click to expand...
 
Thanks a lot for your help.

Allen said:
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
Click to expand...
[quoted text clipped - 26 lines]
Click to expand...
 
Back
Top