Need a Record Count Summary

[JMM9000]

I know that this issue will not be SOLVED with a query, but I am basically looking for a way to display the total number of records for a selected number of tables and queries in my database on one screen or on one single page view. The problem with using reports or forms is that they tend to bind you to a single table as a record source. This summary would require multiple tables and queries. The summary data would look something like this with a total coming from a Count() or count type function:

# of records: 3000
# of records to insert: 500
# of records to delete: 400
# of records to update: 2100
# of records changing location: 100

and so on. One from each table or query. If someone were to have a plausible suggestion or solution, that would make it look great!!

 

[vbaInet]

Welcome to the forum!

# of records to insert: 500
# of records to delete: 400
# of records to update: 2100
# of records changing location: 100

How do you determine the above from a table?

 

[plog]

This will get you the total number of records in all tables and queries:

SELECT MSysObjects.Type, MSysObjects.Name, DCount("*",[Name]) AS Records
FROM MSysObjects
WHERE (((MSysObjects.Type)=1 Or (MSysObjects.Type)=5) AND ((MSysObjects.Name) Not Like "MSys*"));

You'll have to explain how to determine all the records to Insert/delete/update/etc.

 

[JMM9000]

the results are basically just the total number of records in each query or table. It's really as simple as that. I can get those numbers other ways, just not all at once.

 

[vbaInet]

It still doesn't make much sense to me. How does Insert/delete/update/etc relate to a table?

 

[AC5FF]

vbaInet:
I tried this code on one of my databases. Quite neat. Although it took forever to run!
(Monster database)
I did get numerous results that gave "Error" ... not sure why. But again; it's a monster that is linked all over the place to XLS, TXT, and other MDB files on numerous different computers here.

JMM9000; I think i understand what you are looking for; but the number of records in a query will very when the query is run. So, looking for a count of records a query will update/delete/etc - i don't think that's possible....

 

[vbaInet]

vbaInet:
I tried this code on one of my databases. Quite neat. Although it took forever to run!
(Monster database)
I did get numerous results that gave "Error" ... not sure why. But again; it's a monster that is linked all over the place to XLS, TXT, and other MDB files on numerous different computers here.

I think you mean plog!

But if it's running slow then you can change the DCount() to a subquery.

 

[AC5FF]

OOPs! Yep. Sorry Plog!