VBA Recordsets

[pcdaveh]

What is the proper syntax to use to check if a record set has any records if the answer is no I don't want the error messages.

rst.nomatch 'didn't work for me.
rst.movefirst 'didn't work because there are no records.

 

[klasse]

Hi,

I would do:

if myrecordsetname.recordcount = 0 then exit sub

yourrecordset.recordcount will give you the number of records in the recordset.

Rgds,

Klasse

 

[jgoodman00]

I always use teh following method:

Dim db as DAO.Database, rst as DAO.Recordset
Set db = CurrentDB
Set rst = db.OpenRecordset("Select * FROM Source&quot
If rst.RecordCount > 0 Then
'Add all code here
Else
MsgBox "No records found!", vbExclamation
End If

HTH James Goodman

 

[jebry]

Hi!

Checking EOF and BOF is probably the surest method:

If rst.EOF = True and rst.BOF = True Then No records.

hth Jeff Bridgham
bridgham@purdue.edu