[AccessD] Record counter not working

[Rocky Smolin]

That's too easy.  But I'll try it.  :)

Tsk

R


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Charlotte Foust
Sent: Friday, September 16, 2016 2:23 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Record counter not working

You left requery unstoned.  Just requery the textbox.

Charlotte Foust
(916) 206-4336

On Sat, Sep 3, 2016 at 7:51 PM, Rocky Smolin <rockysmolin at bchacc.com> wrote:

> First one, then the other, then both, then in reverse order.  I left 
> no tern unstoned.
>
> R
>
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf 
> Of Stuart McLachlan
> Sent: Saturday, September 03, 2016 4:15 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Record counter not working
>
> Did you have both Me.Repaint and DoEvents or did you only try it with 
> each of those separately?
>
>
> On 3 Sep 2016 at 16:04, Rocky Smolin wrote:
>
> > OK- here's a clue (don't know what to make of it though)
> >
> > I put msgbox "Stop" after the Me.txtRecNo = CLng(Nz([txtRecNo], 0)) 
> > +
> > 1 and the text box showed as updated.  Actually is also worked with 
> > the simple Me.txtRecNo = Me.txtRecNo + 1.
> >
> >
> > So is it a timing thing?  I tried Me.Repaint and DoEvents to no avail.
> >
> > TIA
> >
> >
> > r
> >
> > -----Original Message-----
> > From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On 
> > Behalf Of Rocky Smolin Sent: Saturday, September 03, 2016 3:54 PM 
> > To: 'Access Developers discussion and problem solving' Subject: Re: 
> > [AccessD] Record counter not working
> >
> > 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
> >
> > --
> > 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
>
> --
> 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