[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


"4120: Bad parameter" error when printing Word-based report from VB app

Posted on 2007-04-10
Medium Priority
Last Modified: 2008-01-23
I have an application that uses a locked Access 2000 database and is built in VB.  Reports for the data are generated in MS Word.  I have Office 2007 installed on WinXP SP2.  When I try to print or preview a report from the application, I get "4120: Bad parameter".  The application has multiple Word template styles available; I've tried all of them and get the same result.  The only way I can print reports from this app is by using the "dot matrix" style, which does not use MS Word and can only be printed (no preview).  

Outside the 3rd party app, Word opens normally, and new or saved documents print normally.  The only time the error occurs is when trying to print or preview reports from this 3rd party application.  

I'm happy to provide more specific information as soon as I know what is needed.  Thanks!
Question by:enkotec
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 13

Expert Comment

ID: 18882764
My suggestion would be to temporarily remove error handling in the VB app for the mod that is used to print the report, then run again and see which line breaks. then post the line. (along with the rest of the code) you said it was written in VB. VBA? VB6? VB.net?

LVL 39

Accepted Solution

stevbe earned 1000 total points
ID: 18884474
have you asked them if they are supporting Word 2007?

Author Comment

ID: 18938224
I'm not sure which version of VB it's written in, and I have no way to open the app in VB since it's a vendor's product.  The vendor insists they tested it with Office 97 and they've never seen this error.  It works with Word 2003, but as soon as I re-install Word 2007 I'm back to the "4120" error.  Event Viewer doesn't show anything related.  I'm trying to find out if there are relevant error logs for the app that might shed light on the problem.
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

LVL 13

Assisted Solution

adraughn earned 1000 total points
ID: 18938808
if you don't have access to the code, you are not going to be able to fix this issue unless you just avoid using it with 2k7. My suggestion would be to contact the developer and, like steve said, ask them if they are supporting 2k7. my guess would be no, since you are getting an error, but they will be able to tell you when/if they are planning on testing on 2k7 and sending out another build.


Author Comment

ID: 19087884
No access to the code.  Vendor says they tested on Office 2k7 and haven't seen this error.    Error log for app just says "4120 Bad parameter".  I guess I'm at a roadblock.  There's no information from MS about this error with Office 2k7, so it's either an app-specific problem or an as yet unknown issue with Word 2k7.  Thanks for the input.

Author Comment

ID: 20723599
Actual solution found:  
The cause of the error was what appears to be a bug in Word 2007.  If the User Name field in the Word Options > Popular pane is not populated, or contains only spaces, the error occurs.  Populating the User Name field resolved the problem.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question