[AccessD] MZ Tools question

You may need to loop through all documents in the forms container, open them
in design view before counting the objects. If you are doing this from a
running application, I kinda wonder what would happen if some of those forms
were already running. So I am not sure this is a routine I would encourage
be run while a database is running, but rather I would use a dictator
application to read from the target database what was necessary.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Saturday, March 09, 2013 8:31 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] MZ Tools question

You were right, Doug. I emailed them and got a reply in less than 7 hours.

For anyone curious about this, that column is there for VB6 forms etc.
Apparently they cannot get at the corresponding data. I'm not sure why that
is. I think I know how to do what I expected.

<air code>
for each form
    create a controls collection
    report its itemcount
next
</air code>

That could go further and report the count of each type of control, and that
might be useful as an appendix to the MZ stats report.

Maybe when I've done my chores today, I'll write that. It doesn't seem
difficult.

A.


On Sat, Mar 9, 2013 at 1:10 AM, Arthur Fuller
<fuller.artful at gmail.com>wrote:

> I'll that. Thanks!
>
> A.
>
>
> On Fri, Mar 8, 2013 at 11:59 PM, Doug Steele <dbdoug at gmail.com> wrote:
>
>> Hi Arthur:
>>
>> Did you contact MZTools?  Every time (well, twice) I've emailed them, 
>> I've had a quick response.
>>
>> Doug
>>
>>
>>
>> On Fri, Mar 8, 2013 at 8:06 PM, Arthur Fuller 
>> <fuller.artful at gmail.com
>> >wrote:
>>
>> > I just ran the MZTools App-Statistics module on a huge app and it 
>> > documented everything beautifully and quickly, too, except for the 
>> > last column of the ourput, called Controls. It contains 0 for every 
>> > single object in the app, including forms and reports. I don't get 
>> > it. Is it a
>> bug
>> > in the Tools, or did I miss a switch, or what?
>> >
>> > Has anyone run this and got non-zero values in the Controls column?
>> While I
>> > wait for a reply, I'm going to run it again and see whether I 
>> > missed a checkbox or something.
>> >
>> > --
>> > Arthur
>> > Cell: 647.710.1314
>> >
>> > Prediction is difficult, especially of the future.
>> >   -- Niels Bohr
>> > --
>> > AccessD mailing list
>> > AccessD at databaseadvisors.com
>> > http://databaseadvisors.com/mailman/listinfo/accessd
>> > Website: http://www.databaseadvisors.com
>> >
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>
>
>
> --
> Arthur
> Cell: 647.710.1314
>
> Prediction is difficult, especially of the future.
>   -- Niels Bohr
>
>


--
Arthur
Cell: 647.710.1314

Prediction is difficult, especially of the future.
  -- Niels Bohr
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com