Advertisement
Guest User

Untitled

a guest
Sep 18th, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
ASP 1.29 KB | None | 0 0
  1. Private Sub update_status_display()
  2.     Dim szTmp As String
  3.     Dim szMessage As String
  4.    
  5.     PRINT_MODE = Form_CustomerPrint4UP.PRINT_MODE
  6.     SINGLE_CUSTOMER_NUMBER = Form_CustomerPrint4UP.SINGLE_CUSTOMER_NUMBER
  7.    
  8.     On Error Resume Next
  9.     szMessage = "Will print last 4 draws in new 4 UP Booklet for "
  10.     cmdPrint.Enabled = True
  11.     If PRINT_MODE = SINGLE_CUSTOMER Then
  12.         szTmp = DLookup("[FirstName] & "" "" & [MiddleInitial] & "" "" & [LastName]", "Customers", "CustomerNumber=" & SINGLE_CUSTOMER_NUMBER)
  13.         szMessage = szMessage & vbCrLf & szTmp
  14.     ElseIf PRINT_MODE = SEARCH_RESULTS Then
  15.         '//SELECT COUNT(*) AS cnt FROM (SELECT DISTINCT CustomerNumber FROM TempSearchTable);
  16.         Dim rsCount As ADODB.Recordset
  17.         Set rsCount = CreateNewADODBQuery("SELECT COUNT(*) AS cnt FROM (SELECT DISTINCT CustomerNumber FROM TempSearchTable);")
  18.         szMessage = szMessage & rsCount("cnt") & " customers."
  19.         chkCustomerReceipt.Enabled = False
  20.         rsCount.Close
  21.         rsCount = Nothing
  22.     Else
  23.         szMessage = "*** ERROR *** This form was opened in a wacky way and will not function!"
  24.         cmdPrint.Enabled = False
  25.     End If
  26.     lblStatus = szMessage
  27.     Form.Refresh
  28.     Debug.Print "update_status_display " & lblStatus.Caption
  29. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement