Displaying a count of records that have been processed

I am checking records between two tables. If there is no duplicate, the
record is added to the second table. (The master list is controlled by
another organization. The second list can be manipulated at the local
level with entries that are not on the master list.)

This operation takes some time and I want a text box (or label) to
display the message "Processing Record x of n master records."

lngCount counts the records being processed. At the end of each check
and before lngCount is updated, I tried
txtCount.Value = "Processing Record " & intCount
The textbox changes only after ALL of the records have been checked.

I used the timer event to change the textbox, but that doesn't fire
while the code to check the two tables is running.

Any suggestions?
Thank you in advance.
Deborah

dgardner@twcny.rr.com wrote in
news:1156022112.184247.94210@i42g2000cwa.googlegro ups.com:

Quote:

I am checking records between two tables. If there is no
duplicate, the record is added to the second table. (The
master list is controlled by another organization. The second
list can be manipulated at the local level with entries that
are not on the master list.)
>
This operation takes some time and I want a text box (or
label) to display the message "Processing Record x of n master
records."
>
lngCount counts the records being processed. At the end of
each check and before lngCount is updated, I tried
txtCount.Value = "Processing Record " & intCount
The textbox changes only after ALL of the records have been
checked.
>
I used the timer event to change the textbox, but that doesn't
fire while the code to check the two tables is running.
>
Any suggestions?
Thank you in advance.
Deborah

Immediately following your textbox update add a line with the
statement DoEvents

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

On 19 Aug 2006 21:04:39 GMT, Bob Quintal <rquintal@sPAmpatico.ca>
wrote:

If you use the statusbar instead, it will paint automatically. See
SysCmd in the Help file.

-Tom.

Quote:

>dgardner@twcny.rr.com wrote in
>news:1156022112.184247.94210@i42g2000cwa.googlegr oups.com:
>

Quote:

>I am checking records between two tables. If there is no
>duplicate, the record is added to the second table. (The
>master list is controlled by another organization. The second
>list can be manipulated at the local level with entries that
>are not on the master list.)
>>
>This operation takes some time and I want a text box (or
>label) to display the message "Processing Record x of n master
>records."
>>
>lngCount counts the records being processed. At the end of
>each check and before lngCount is updated, I tried
> txtCount.Value = "Processing Record " & intCount
>The textbox changes only after ALL of the records have been
>checked.
>>
>I used the timer event to change the textbox, but that doesn't
>fire while the code to check the two tables is running.
>>
>Any suggestions?
>Thank you in advance.
>Deborah

>
>Immediately following your textbox update add a line with the
>statement DoEvents
>
>
>--
>Bob Quintal
>
>PA is y I've altered my email address.

Displaying a count of records that have been processed

re: Displaying a count of records that have been processed

re: Displaying a count of records that have been processed

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about