• Home
 · 
• Miscellaneous
 · 
• This is just a sample code using DATA Control on how to check if there's existing Record of Zero re

This is just a sample code using DATA Control on how to check if there's existing Record of Zero re

This is just a sample code using DATA Control on how to check if there's existing Record of Zero record within a Database using MS Access

API Declarations


' Add a Data Connection Control within your forms
' Setup its configuration
' Then put the following code in you form Load or Command Button



Rate This is just a sample code using DATA Control on how to check if there's existing Record of Zero re

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

  Dim Ptr as Integer
  Dim x as String
    Ptr = .RecordCount ' Count # of Records in a Table
       ' Test if there's Zero or Empty Record in the Table
        If Ptr = "" Or Ptr = 0 Then 
            x = MsgBox("Empty Database.", vbExclamation, "Message")
            Exit Sub 
        End If
End With