By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,551 Members | 2,741 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,551 IT Pros & Developers. It's quick & easy.

How do I know if a recordset has been filled?

P: n/a
I use Access 2003 and WinXP.

I have a recordset declared:

Dim regValuation As Recordset

Later, I may, or may not, fill it (for a certain csql string) like
this:

Set regValuation = CurrentDb.OpenRecordset(csql)

How can I test if the recordset has been filled or not?

I have tried, unsuccessfully:

vartype()
regValuation.EOF and .BOF.

Regards,

Jan Nordgreen

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

"damezumari" <ja**********@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
I use Access 2003 and WinXP.

I have a recordset declared:

Dim regValuation As Recordset

Later, I may, or may not, fill it (for a certain csql string) like
this:

Set regValuation = CurrentDb.OpenRecordset(csql)

How can I test if the recordset has been filled or not?

I have tried, unsuccessfully:

vartype()
regValuation.EOF and .BOF.

Regards,

Jan Nordgreen


Something like this:

If regValuation Is Nothing Then

'Code if not yet assigned

End If

Regards,

Wayne Phillips
http://www.everythingaccess.com/forums
Nov 13 '05 #2

P: n/a
Thanks!

It worked like a dream!

Regards,

Jan Nordgreen
http://simpler-solutions.net/pmachin...thinkagain.php

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.