[AccessD] Record counter not working

Rocky Smolin rockysmolin at bchacc.com
Sat Sep 3 17:39:19 CDT 2016


Bill:

No soap.  It should work.  But so should Me.txtRecNo=Me. txtRecNo + 1.

Oddly, it worked once while I was trying different things. But then not
again.

R

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

Try =CLNG(NZ ([txtRecNo],0))+1

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



More information about the AccessD mailing list