X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
2 Pages V < 1 2  (Go to first unread post)
   Reply to this topicStart new topic
> Count On Continuous Form Only Counts Visible Records, Access 2016    
post Sep 23 2019, 04:24 AM

Posts: 52
Joined: 9-March 10

I do a C&R automatically every 10 days. Thanks for thinking of that.
Go to the top of the page
post Sep 23 2019, 05:46 AM

Posts: 1,463
Joined: 2-April 09
From: somewhere out there...

why not use a Query as recordsource of the subform.
then you can add the Count("*") in the query.
use the Calculated field as the value of the textbox
on the form footer.

Never stop learning, because life never stops teaching.
Go to the top of the page
post Sep 23 2019, 06:54 AM

UtterAccess Editor
Posts: 10,145
Joined: 7-December 09
From: St Augustine, FL

>> you can add the Count("*") in the query <<

I think this is a good idea... where reasonable, you're usually better off resolving data in an underlying query rather than through the UI. UIs in general are fickle and subject to various oddities, where the queries are much more stable.

Go to the top of the page
post Sep 23 2019, 08:21 AM

UtterAccess VIP
Posts: 11,067
Joined: 10-February 04
From: South Charleston, WV

RLG has stated that this thing works perfectly in Access 2007. If that's the case then reworking the logic isn't the way to go. Is there any way to reconfirm that 2007 works, RLG? If you were to post it then I can confirm it works in 2013 or not. It seems like we need something to work with.

Robert Crouser
Go to the top of the page
post Sep 23 2019, 12:50 PM

Posts: 52
Joined: 9-March 10

I have just reverted to old saved copies of the database and although it appears to be working, it is not giving the correct count each time. Clearly there is a problem with my logic, so I will try to go back to basics and come back to you all later, either begging for more help or apologising because my coding was up the creek to begin with.

Thanks very much.
Go to the top of the page
2 Pages V < 1 2

Custom Search

RSSSearch   Top   Lo-Fi    18th October 2019 - 03:35 AM