A VB expression to return the number of entires in a query. 1

[avayaman]

I need to have a condition happen if a query contains any entries.

Or alternatively & better still, have an action occur if a docmd.runsql of the database finds at least one entry in the databse where a certain field (check box) is set to true.

Paul Beddows

Consulting, Avaya/EAS implementation, Training
Vancouver, Canada
E-mail paul at natcoa.com

 

[dhookom]

You can test a query for records using code like:

If DCount("*","YourQueryName")>0 Then

End If

Duane
Hook'D on Access
MS Access MVP

 

[avayaman]

Sounds good, I will try it out.

Paul Beddows

Consulting, Avaya/EAS implementation, Training
Vancouver, Canada
E-mail paul at natcoa.com

 

[avayaman]

Worked great. Thanks

Paul Beddows

Consulting, Avaya/EAS implementation, Training
Vancouver, Canada
E-mail paul at natcoa.com