[AccessD] Display message while processing information

Thanks Drew and Lambert!

Very helpful!

-----Original Message-----
From: Heenan, Lambert [mailto:Lambert.Heenan at aig.com]
Sent: Thursday, February 06, 2003 1:53 PM
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] Display message while processing information

I'm guessing that your function runs a loop  which appends records one by
one to the temp table. In which case, if you know how many records will be
processed in the loop, are a decent guestimate, you can use SysCmd to give
the user a progress bar on the bottom left corner of the Access window.

pseudo code
...
Dim nRecords as Long
Dim nCurrentRecord as Long

        nRecords = SomeNumber ' your estimate or an actual count
        nCurrentRecord = 0
        SysCmd acSysCmdInitMeter, "Creating Temp Table, please wait...",
nRecords

        ' For Loop is just for example. you might use a Do Loop or whatever.
        ' The For loop conveniently increments the counter, in any other
loop
        ' you'd need to do that manually : nCurrentRecord = nCurrentRecord +
1

        For nCurrentRecord = 1 to nRecords
                ' Process the data
                SysCmd acSysCmdUpdateMeter, nCurrentRecord
                DoEvents
        Next nCurrentRecord
        SysCmd acSysCmdClearStatus

If you cannot get an exact record count number, then a good over estimate
will still let you display a moving progress bar which tells the user things
are happening.

HTH

Lambert

> -----Original Message-----
> From: Joe Rojas [SMTP:JRojas at tnco-inc.com]
> Sent: Thursday, February 06, 2003 12:26 PM
> To:   'accessd at databaseadvisors.com'
> Subject:      [AccessD] Display message while processing information
>
> Hi All,
>
>       Access 2000 (mdb)
>
> I have a function that generates a temp table that is populated with
> information for a report. What I would like to do is have a message
> displayed on the screen saying something like "Generating Report..." or
> something to that extent, to let the user know that Access is "working"
> and
> not just locked up or something. I tried in the past to achieve this with
> a
> small form, but the form did not always load properly or completely while
> the function was churning away.
>
> How can I achieve this while having the form load completely?
>
>
> Thanks,
> Joe Rojas
> jrojas at tnco-inc.com
>
>
>
>
>
> This electronic transmission is strictly confidential to TNCO, Inc. and
> intended solely for the addressee. It may contain information which is
> covered by legal, professional, or other privileges. If you are not the
> intended addressee, or someone authorized by the intended addressee to
> receive transmissions on behalf of the addressee, you must not retain,
> disclose in any form, copy, or take any action in reliance on this
> transmission. If you have received this transmission in error, please
> notify
> the sender as soon as possible and destroy this message. While TNCO, Inc.
> uses virus protection, the recipient should check this email and any
> attachments for the presence of viruses. TNCO, Inc. accepts no liability
> for
> any damage caused by any virus transmitted by this email.
> _______________________________________________
> 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



This electronic transmission is strictly confidential to TNCO, Inc. and
intended solely for the addressee. It may contain information which is
covered by legal, professional, or other privileges. If you are not the
intended addressee, or someone authorized by the intended addressee to
receive transmissions on behalf of the addressee, you must not retain,
disclose in any form, copy, or take any action in reliance on this
transmission. If you have received this transmission in error, please notify
the sender as soon as possible and destroy this message. While TNCO, Inc.
uses virus protection, the recipient should check this email and any
attachments for the presence of viruses. TNCO, Inc. accepts no liability for
any damage caused by any virus transmitted by this email.