RecordCount Property

  • Thread starter Thread starter Kayda
  • Start date Start date
K

Kayda

Hi:

I have code that does two separate queries via ADO and then prints out the
results. The first query is standard and if no records are returned it
prints nothing as expected. The second query contains a SUM function in the
query and if there are zero records I get the following error:

Error Type:
(0x80020009)
Exception occurred.

I tried using the RecordCount property which is returning -1. I've seen
articles about this but didn't want to test it because I didn't feel I
should need to test for zero records.

BTW, I am using Access and we're only talking about 30 records at the most
at a time here.

Thanks,

Blair
 
Back
Top