[AccessD] Record counter not working

Rocky Smolin rockysmolin at bchacc.com
Sat Sep 3 17:54:13 CDT 2016


Then what triggers it to change as the code loops through its loop?

r

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

Again, I ask why not put it in the controlsource  of the textbox.

On Sep 3, 2016 5:48 PM, "Stuart McLachlan" <stuart at lexacorp.com.pg> wrote:

> Is all of the procesing code in the form's module or is it done by a 
> single call to a function/procedure  in a separate module?
>
> (Failing code not shown!)
>
>
> On 3 Sep 2016 at 11:28, Rocky Smolin 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
>
--
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