error in printing

I have a form that users are printing and sporatically they get a runtime error.  I think I narrowed it down to this section of code:

If MsgBox("Would you like to print this record?", vbYesNo Or vbQuestion, "Print Record") = vbYes Then
Me.PrintForm
Printer.Print ""
Printer.PaintPicture Picture2.Picture, 0, 0, 12000, 12000
Printer.EndDoc
End If

Open in new window


When they click Yes, they get an error sometimes.  Is there  a better way to print Picture2?
al4629740Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
What error do they get?
0
al4629740Author Commented:
I wish I could get them to write it down, but it is a runtime error.  I don't get an error.
0
Martin LissOlder than dirtCommented:
Some thoughts:
What's different about your customer(s) with the problem? Different OS? Different printer?
Is it always the same customer?
Is it always the same picture?
There's code out there that you could add to your project that would send you an email containing the error information when the error occurs.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

al4629740Author Commented:
Can I send the code to the database when An error occurs
0
Martin LissOlder than dirtCommented:
You can do anything you want.
0
al4629740Author Commented:
Can you provide a good example that would retrieve the error and send to db by chance
0
Martin LissOlder than dirtCommented:
No I can't but if you are already writing to a database from the application then it should be easy to add a new table for the errors and in that table include things like the user's name, err.number, erl (the line number where the error occurred), and the name of the procedure where the error occurred. For help with the latter take a look at my Automatic Insertion of Procedure Names add in.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Martin LissOlder than dirtCommented:
I'm glad I was able to help.

In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.