Count records in a query

[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?

 

[RonaldoOneNil]

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

This will give you the number of records in the Query

 

[ryguy7272]

Did you test the query and see if you can speed it up? You can copy the SQL
and post in the Access - Queries DG. Here's an idea for a progress bar:
http://datapigtechnologies.com/flashfiles/progressbar.html