Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Problem: Word is currently printing...

Posted on 1998-01-08
1
Medium Priority
?
299 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 100 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
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…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

580 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