[AccessD] Record counter not working

[Rocky Smolin]

Means at the top of the loop - (stuped spel chequer)

If by continuous or single you mean form it's neither - it's a form not
bound to anything but running a rather complex bunch of code to create a
temp table that gets output to a spreadsheet or a report.

There's a big loop and it might take 10-60 seconds to process the data.  As
it's going through the loop, I know up front how many record are going to be
in the loop (the loop is a recordset so I can get rs.RecordCount).

I show the total records in the loop to the user, and I want to increment a
counter every time through the loop and display that to the user so they
know how many records have been processed and how many remain.  So they know
if they have time to take a dump or whatever before the looping is finished.

R


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Bill Benson
Sent: Saturday, September 03, 2016 12:05 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Record counter not working

Is it a continuous for or single? What does "at the top of the look" mean?

On Sep 3, 2016 2:29 PM, "Rocky Smolin" <rockysmolin at bchacc.com> wrote:

> Dear List:
>
>
>
> I have two text boxes on a form - one shows the total number of 
> records to be processed and the other is a counter.  So that the form 
> shows that there's something going on (i.e., Processing Record: 14 of
250).
>
>
>
> I put
>
>
>
> Me.txtRecNo = Me.txtRecNo + 1
>
>
>
> At the top of the look but it didn't update.
>
>
>
> So I added:
>
>
>
> Me.Repaint
>
>
>
> Still no update. So I added:
>
>
>
> DoEvents
>
>
>
> Still no update.  It always reads 0 of n (I initialize the text box 
> with a zero).
>
>
>
> Any idea why I can't get this to update?  I use this technique a lot 
> to let the user know at what point in the process the program is, and 
> it is often unreliable.  I have used a long variable for the counter 
> and just plugged the variable into the text box after it was 
> incremented but that doesn't work in this case.
>
>
>
> Any ideas appreciated.
>
>
>
> MTIA
>
>
>
>
>
> Rocky Smolin
>
> Beach Access Software
>
> 760-683-5777
>
> www.bchacc.com
>
> www.e-z-mrp.com
>
> Skype: rocky.smolin
>
>
>
>
>
> --
> 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