rst.recordcount & verify docmd.sendobject

[Guest]

Hi

I read the help files a few times, and i don't understand why my recordcount
in ado recordsets return -1. basically i run in to the problem of knowing
whether the recordset has opened. what am i doing wrong?

also, i would like to verify if the docmd.sendobject excuted. basically i
send some stuff to outlook, and i set Edit Message= true. i would like that
the user can click away to something else, and more importantly, cancel the
email with out causing some error. in other words i would like to do this:
DidISend = docmd.sendObject( etc...
however, this doesn't work. what can i do?

thanks,

sam

 

[Van T. Dinh]

For the first part, RecordCount of ADO Recordset may returns -1 to simply
indicate that the Recordset is not empty and not the actual number of
Records /rows in the Recordset.

Check the Help topic for ADO RecordCount. IIRC, it has explanation on the
type of Recordset and the corresponding RecordCount return value.