Using a Common Dialog Box to Print Contents of Various Controls

Posted on 2001-08-24
Last Modified: 2008-02-01

I am trying to print the contents of a RichTextBox using a Windows Common Dialog Box component.

It works to print, if I select OK. If I select Cancel the program crashes with a run-time error #32755.

The name of the common dialog box is 'cmdEd'. It was coded by another developer, without comments, to print the contents of the rtfDisplay RichTextBox control.

The code is as follows:

cdgEd.Flags = cdlPDReturnDC + cdlPDNoPageNums
  If rtfDisplay.SelLength = 0 Then
     cdgEd.Flags = cdgEd.Flags + cdlPDAllPages
     cdgEd.Flags = cdgEd.Flags + cdlPDSelection
  End If
  rtfDisplay.SelPrint cdgEd.hDC

I presently don't understand these 'Flags'. I know how to code the vbOKOnly or vbCancel on a message box.

How does one properly code this dialog component to insure that clicking on cancel truly does cancel and unload the dialog?

Question by:jnowlin
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
  • 2
  • +2

Expert Comment

ID: 6422251
try something like this:

Private Sub Command1_Click()
On Error Goto Problems
  'Other code here
  Exit Sub
  If Err.Number = 32755 Then
    Exit Sub
    MsgBox Err.Description
  End If
End Sub

hope this works!
LVL 28

Expert Comment

ID: 6422257
They have set the CancelError to true.  This allows you to determine when a user presses cancel and take any necessary action, e.g,

Sub PrintStuff()
   On Error Goto PrintStuff_EH


   If Err.Number = cdlCancel Then
      'User pressed cancel
   End If
End Sub
LVL 28

Expert Comment

ID: 6422262
Sorry, CancelError property of the common dialog control.
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

LVL 16

Expert Comment

ID: 6423594
jnowlin, i would like to ask for which reason do you use a commondialog to print richtrextbox.
If i remember well, it has incorporated that funcionality itself:RichTextBox1.selprint
LVL 16

Expert Comment

ID: 6423646
Sorry forget my comment.

Author Comment

ID: 6426398
Hi AzraSound,

I changed the CancelError property of this common dialog control to False. When I ran the program, opened a file into the RichTextBox control, 'rtfDisplay', and selected "Cancel" instead of "Print", I got a different run-time error:

Error #32001
"Invalid HDC"

I don't know what HDC means. It must be some sort of relationship between the common dialog control and the print dialog that opens up within Windows2000 that I'm still unclear about.

Does this Cancel button need to be coded to Exit Sub when a user clicks it?

LVL 28

Accepted Solution

AzraSound earned 150 total points
ID: 6426437
>>Does this Cancel button need to be coded to Exit Sub when a user clicks it?

Yes, otherwise, you have no idea whether or not to proceed with the print operation.  For example, look at this logic:

'Without having cancel throw an error
Show print dialog
Try to print with the selected printer  <~~ If nothing was selected (e.g., they pressed cancel), you have no printer to print to
When you call:
[RichTextBox.SelPrint dialogSelectedPrinter.hDC]
the selected printer is nothing, thus, no valid hDC (handle to a device context) is passed

'With cancel throwing an error
On Error SkipAllCode
You still have all your code from above, but its bypassed if the user presses cancel, and taken to your error handling routine
   If Err.Number = cdlCancel
      'user pressed cancel, you can do nothing, ask if they are sure they want to cancel the print, etc.
   End If

You should be able to trap otherwise, even with CancelError set to False, by testing to be sure the hDC is not 0 before trying to print with it.  However, using the more popular form of error handling is probably the way to go.

Expert Comment

ID: 6431402
When dealing with a CommonDialog Control, I always go something like this

With cdgEd
  .CancelError=True  'always usefull
  .Flags = cdlPDReturnDC + cdlPDNoPageNums
  If rtfDisplay.SelLength = 0 Then
    .Flags = .Flags + cdlPDAllPages
    .Flags = .Flags + cdlPDSelection
 End If
 On Error Resume Next 'just for the dialog
 If Err = cdlCancel Then Exit Sub 'user pressed cancel
 On Error Goto 0 'disable error handler
 rtfDisplay.SelPrint .hDC
End With

This is a bit like the examples above, except that Error Handling is only enabled for the Commondialog Control when showing the Printbox.

After showing the Printbox and checking if the user presses cancel, ErrorHandling is disabled so that you can see other errors, should they occur.

Just scream 4 more ;)

Author Comment

ID: 6448960
Thanks AzraSound,

I'm posting another question involving the common dialog control, as this project has code on it (not mine), is poorly commented and I have next to nothing for documentation on this control.


Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses
Course of the Month4 days, 23 hours left to enroll

635 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