Solved

Problem: Word is currently printing...

Posted on 1998-01-08
1
293 Views
Last Modified: 2012-06-27
Greetings,
I have an  Access97 application which omang other things prints Word97documents based on database member selection information. I am using DDE and if the Documents are short 4-5 pages I don't have a problem. If the Documents are longer I get "Word is Currently printing...." messages. What is the best way to halt the DDE request to open and print until the current document has been spooled.

I know you can set background printing options to hide the message but does this actually halt the DDE request until the job is spooled? If no, what is my best alternative?

Thanks,
Brad
0
Comment
Question by:bhummel
1 Comment
 
LVL 12

Accepted Solution

by:
Trygve earned 50 total points
ID: 1964963
Does the "Word is Currently printing ..." message come as an error message. Is so you make your error trapping check for this particullar error code and make your code loop until it stops.

Example:

On error goto errCheckItOut

' Your code

Exit Function

errCheckItOut:
  If err = <The error code> And error Like "Word is Currently*" then
   Resume 0 ' Try again
  else
   MsgBox(err & " "& error) ' display error information
   End
  End If

If you don't want it to try forever you could also include a counter and make it stop retrying after say 10,50... attempts with some message to the user.


You may also have a look into Automation which is the recommended way of working with other, at least Microsoft, applications.

Feel free to comment if you have any questions.

Hope this helps !
Trygve
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

856 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