By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,486 Members | 2,169 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,486 IT Pros & Developers. It's quick & easy.

Displaying a count of records that have been processed

P: n/a
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

Aug 19 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
dg******@twcny.rr.com wrote in
news:11*********************@i42g2000cwa.googlegro ups.com:
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

Aug 19 '06 #2

P: n/a
On 19 Aug 2006 21:04:39 GMT, Bob Quintal <rq******@sPAmpatico.ca>
wrote:

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

-Tom.
>dg******@twcny.rr.com wrote in
news:11*********************@i42g2000cwa.googlegr oups.com:
>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.
Aug 19 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.