Count records in a query

  • Thread starter AtleDreier via AccessMonster.com
  • Start date
A

AtleDreier via AccessMonster.com

Hello!

I have a query that runs pretty slow, and I'd like to alert the user before
running the query.
So I have a source query for my slow query, and I'd like to count the records
in my source query and estimate the time the query will take to run.

How can I do this in VBA?
 
R

RonaldoOneNil

DCount("*","Your Source Query Name")

This will give you the number of records in the Query
 
Top