borderAndreaVB free resources for Visual Basic developersborder
AndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2017 Andrea Tincani
:: Check if a RecordSet has Data

AndreaVB Monthly Tip Award

Author  

Brian Gillham

Language  

VB5, VB6

Operating Systems  

Windows 95, 98, NT, Me and 2k
Module
Public Function EmptyRS(ByRef adoRS As ADODB.Recordset) As Boolean
    'Checks for an EMPTY RecordSet
    On Error GoTo ErrHandler
    EmptyRS = True
    If Not adoRS Is Nothing Then
        EmptyRS = ((adoRS.BOF = True) And (adoRS.EOF = True))
    End If
Exit Function
ErrHandler:
    EmptyRS = True
End Function
:: Navigation

Home

Database Management

Previous Tip

Next Tip

:: Search this site
Google
:: Related Topics
icon 09-05-2014 INSERTING IMAGE FILES DYNAMICALLAY IN CRYSTAL VIEWER USING VB6 AND MS ACCESS by vikasjains
icon 10-12-2012 Re: Please help me to solve this problem???? by sulikan
icon 10-12-2012 Have some problem with My Program by sulikan
icon 02-08-2012 Re: Sql server 2005 Speeding up Script by GeoffS
icon 16-04-2011 VBA - Search for a field and display all the fields by eliteraj
borderAndreaVB free resources for Visual Basic developersborder
borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2017 Andrea Tincaniborder