Access Report - Record count for each table
I'm trying to come up with a simple access report that will show just two things:
1) name of each table in the database
2) count of each table in the database (number of records)
I know there is the database documenter, but I'm looking for something much simpler.
Seems easier said than done.
Also, I'm not interested in downloading a third party tool...I am hoping to just have a nice simple solution for my db.
1) name of each table in the database
2) count of each table in the database (number of records)
I know there is the database documenter, but I'm looking for something much simpler.
Seems easier said than done.
Also, I'm not interested in downloading a third party tool...I am hoping to just have a nice simple solution for my db.
ASKER
where would I put the function, or what should call the function...I assume somewhere in the report (on print?)
Sorry I'm kind of a hack at this...so this stuff has to be spelled out like I'm a child.
Sorry I'm kind of a hack at this...so this stuff has to be spelled out like I'm a child.
Sorry ... I missed the 'Report' part ... a Report would be quite different.
You could use that routine to fill a table easily enough, then build a report off the temp table.
Jim.
Jim.
<<I am hoping to just have a nice simple solution for my db.>>
FYI, it's going to be fairly straight forward, but probably not as simple as your going to like.
Jim.
FYI, it's going to be fairly straight forward, but probably not as simple as your going to like.
Jim.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hnasr - thanks for the code. Looks like it works fine....although I had to take out the first line because it didn't know what "from a" was. Code seems to work without it anyway.
However, is there a way to get rid of having to click OK to append to the table after each Next statement. I have like 100 tables and I would like to not have to keep clicking each time my new table is updated.
Also, how would I clear the table at the beginning of the code?
However, is there a way to get rid of having to click OK to append to the table after each Next statement. I have like 100 tables and I would like to not have to keep clicking each time my new table is updated.
Also, how would I clear the table at the beginning of the code?
ASKER
Thanks guys...figured out the rest about clearing the table, and setting the warnings to false, so as to not get the messages.
Function mTableNameAndRecordCount()
Dim tdef As DAO.TableDef
For Each tdef In CurrentDb.TableDefs
If InStr(1, tdef.Name, "MSys") = 0 Then
Debug.Print tdef.Name & " " & tdef.RecordCount
End If
Next tdef
End Function