Advertisement
Advertisement
| 07.23.2008 at 01:00PM PDT, ID: 23589955 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: |
=======MODULE THAT SELECTS PRINT FUNCTION===============================
Private Sub cmdPrint_Click()
Dim varResponse As Variant
frmPrint.repPack.SQLQuery = "SELECT QUERY"
frmPrint.Show 1
End Sub
========frmPrint ===================================================
Private Sub Form_Load()
Left = (Screen.Width - Width) / 2
Top = (Screen.Height - Height) / 2
On Error GoTo PrintLoadError
'
' set number of copies to 1 default
'
frmPrint.cbxCopie = 1
'
' if no default printer disable,
' else set as default choice
'
If Printer.DeviceName = "" Then
optPrinter.Enabled = False
Else
optPrinter.Caption = Printer.DeviceName & " on " & Printer.Port
optPrinter.Value = True
End If
Exit Sub
PrintLoadError:
optPrinter.Enabled = False
Exit Sub
End Sub
Private Sub cmdPrint_Click()
Dim varResponse As Variant
Dim PrintDest As Integer
On Error GoTo PrintError
PrintDest = IIf(optWindow = True, 0, 1)
repPack.Destination = PrintDest
'
' Print Preview
'
If PrintDest = 0 Then
frmPrint.Enabled = False
frmPrint.cbxCopie.Enabled = False
End If
'
' Printer
'
If PrintDest = 1 Then
frmPrint.Enabled = True
cmdPrint.Enabled = False
repPack.CopiesToPrinter = cbxCopie
End If
repPack.ReportFileName = "filepath + filename"
repPack.Action = 1
cmdPrint.Enabled = True
Screen.MousePointer = 0
If PrintDest = 0 Then frmPrint.Enabled = True
Exit Sub
Unload Me
PrintError:
Screen.MousePointer = 0
frmPrint.Enabled = True
MsgBox (Err.Number & " - " & Err.Description)
Unload Me
End Sub
|