borderAndreaVB free resources for Visual Basic developersborder

AndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2008 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 21-01-2008 Re: Find record, multiple result by noknok
icon 16-01-2008 Re: Find record, multiple result by yronium
icon 16-11-2007 Datareport Question by daggerass
icon 14-11-2007 Getting Compile Error using Database Object in VBA by BlackDuck603
icon 10-06-2007 Re: Queries using global variables by GeoffS
Partners: Il portale per lui e lei | Download Actual Software | Free Software Download
borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2008 Andrea Tincaniborder