J
Jay
I have an Access project and am simply trying to get a list of all the
query/views, so have the following bit of vba:
Public Sub PrintQueryNames()
For Each AccessObject In CurrentData.AllQueries
Debug.Print AccessObject.Name
Next
For Each AccessObject In CurrentData.AllTables
Debug.Print AccessObject.Name
Next
For Each AccessObject In CurrentData.AllViews
Debug.Print AccessObject.Name
Next
End Sub
But when I run it in the immediate window I can see it cycle through all
1000 queries/views, but when I copy the list it only contains 199 rows.
It's as if the Immediate window is just a 199 row view.
Is there a limit to the output size of the immediate window? and if so,
how can I get all 1000 query names out?
Any help greatly appreciated.....Thanks, Jason
query/views, so have the following bit of vba:
Public Sub PrintQueryNames()
For Each AccessObject In CurrentData.AllQueries
Debug.Print AccessObject.Name
Next
For Each AccessObject In CurrentData.AllTables
Debug.Print AccessObject.Name
Next
For Each AccessObject In CurrentData.AllViews
Debug.Print AccessObject.Name
Next
End Sub
But when I run it in the immediate window I can see it cycle through all
1000 queries/views, but when I copy the list it only contains 199 rows.
It's as if the Immediate window is just a 199 row view.
Is there a limit to the output size of the immediate window? and if so,
how can I get all 1000 query names out?
Any help greatly appreciated.....Thanks, Jason