[AccessD] Access Timer

Not sure if it will get you as close as you need...but couldn't you record 
the time before you open the query...and record the time after...and then 
take the difference."START" and "FINISH" were text boxes on the form I 
lauched the query from.

    Dim stDocName As String

    stDocName = "Query1"
    Me!start = Now()
    DoCmd.OpenQuery stDocName, acNormal, acEdit
    Me!finish = Now()

>From: "William Hindman" <wdhindman at bellsouth.net>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem 
>solving"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Access Timer
>Date: Mon, 3 May 2004 06:57:29 -0400
>
>...take a look at http://www.CleanDataSystems.com
>
>William Hindman
>"The world's becoming a museum of socialist failures." John Dos Passos
>
>
>----- Original Message -----
>From: "Martin Reid" <mwp.reid at qub.ac.uk>
>To: "Access Developers discussion and problem solving"
><accessd at databaseadvisors.com>
>Sent: Monday, May 03, 2004 6:18 AM
>Subject: [AccessD] Access Timer
>
>
> > I want to test the time taken to
> >
> > Open a form - get the load time
> >
> > Run a query - named query - get the time take to produce the results or 
>a
> > file or a report. We may also require the database to send an eal but 
>that
> > is covered.
> >
> >
> > Would anyone have a function that measures such things?
> >
> > Martin
> >
> >
> > --
> > _______________________________________________
> > 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

_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar – get it now! 
http://toolbar.msn.com/go/onm00200415ave/direct/01/