borderAndreaVB free resources for Visual Basic developersborder

AndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2012 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 16-04-2011 VBA - Search for a field and display all the fields by eliteraj
icon 10-08-2010 error running crystal report by VYX
icon 15-04-2009 Re: checking several columns before update by GeoffS
icon 10-10-2008 Re: what is intstatus for? by Keithuk
icon 21-01-2008 Re: Find record, multiple result by noknok
Partners: Download Actual Software | Free Software Download
borderAndreaVB free resources for Visual Basic developersborder

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