By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,344 Members | 1,965 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,344 IT Pros & Developers. It's quick & easy.

Printer object bug with Access 2003 - confirmed by Microsoft Corporation

P: n/a
- Open Access 2003
- Create new database (2000 or 2002/2003 format)
- Create a report and insert a label in its Detail section
- Save the report as Report1
- Copy Report1 as Report2
- Open Report1 and insert Report2 in it as subreport
- Save Report1
- Create a form and use the wizard to insert a button which can open
Report1 for preview
- Go to VBE and navigate to the Click event of the button
- Change the following two lines
stDocName = "Report1"
DoCmd.OpenReport stDocName, acPreview
with this four lines
stDocName = "Report1"
Printer.PrintQuality = acPRPQMedium
DoCmd.OpenReport stDocName, acPreview
Printer.BottomMargin = 5
- Save form as Form1
- Open the form normally
- Click the button
- Here is the bug
I contacted Microsoft Italia (beacause I live in Italy). They informed
Microsoft Corporation which replied confirming it's a bug for Access
2003 and will be corrected in the future. They didn't tell if the
problem will be corrected with a specific patch or with Service Pack 2
for Office 2003.
You will not find any documentation in internet (neither in Microsoft
web site nor in MSDN nor elsewhere) until a correction will be
developed.
I hope this could help.

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Thanks for posting.

The bug seems to be triggered by this line of code:
Printer.BottomMargin = 5

It crashes Access with a dialog titled:
Microsoft Visual C++ Runtime Library
The dialog message reads:
Runtime Error!
Program: C:\Program Files\...\MSACCESS.EXE

This application has requested the Runtime to terminate in an unusal
way.
Please contact the application's support team for more information.

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

<el******@virgilio.it> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
- Open Access 2003
- Create new database (2000 or 2002/2003 format)
- Create a report and insert a label in its Detail section
- Save the report as Report1
- Copy Report1 as Report2
- Open Report1 and insert Report2 in it as subreport
- Save Report1
- Create a form and use the wizard to insert a button which can open
Report1 for preview
- Go to VBE and navigate to the Click event of the button
- Change the following two lines
stDocName = "Report1"
DoCmd.OpenReport stDocName, acPreview
with this four lines
stDocName = "Report1"
Printer.PrintQuality = acPRPQMedium
DoCmd.OpenReport stDocName, acPreview
Printer.BottomMargin = 5
- Save form as Form1
- Open the form normally
- Click the button
- Here is the bug
I contacted Microsoft Italia (beacause I live in Italy). They informed
Microsoft Corporation which replied confirming it's a bug for Access
2003 and will be corrected in the future. They didn't tell if the
problem will be corrected with a specific patch or with Service Pack 2
for Office 2003.
You will not find any documentation in internet (neither in Microsoft
web site nor in MSDN nor elsewhere) until a correction will be
developed.
I hope this could help.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.