Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Printing Crystal in VB

Status
Not open for further replies.

JDPurtell

Programmer
Aug 13, 2001
9
0
0
US
I have the below code:

Do Until rsSQL2.EOF
cmdCorrective.ActiveConnection = Plant_SQL
cmdCorrective.CommandType = adCmdStoredProc
cmdCorrective.CommandText = "AT_Corrective_Action"
cmdCorrective.Parameters("@EndDate") = dtEnd
cmdCorrective.Parameters("@ClockNo") = rsSQL2!ClockNo 'InputBox("Please enter a valid employee clock number.", "Milwaukee Absence Tracking")
cmdCorrective.Execute

Set crpParamDefs = Report5.ParameterFields
For Each crpParamDef In crpParamDefs
With crpParamDef
Select Case UCase(.ParameterFieldName)
Case "DTENDDATE"
.SetCurrentValue dtEnd
Case "STRCLOCKNO"
.SetCurrentValue CStr(rsSQL2!ClockNo)
End Select
End With
Next
Report5.PrintOut
rsSQL2.MoveNext
Loop

Each and everytime it loops through I get prompted for my printer information. How can I shut off the prompt?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top