UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Record Count In A Subform, Access 2003    
 
   
whdyck
post Jan 11 2017, 11:01 AM
Post#1



Posts: 252
Joined: 20-July 11
From: Winnipeg, MB, Canada


Probably a bonehead question:

I have a subform (fsubUntAsnUnitBookingsCardex) that displays no records when the form (frmUntAsnUnitBookingsCardex) is opened.

However, if I then run the following command from the Immediates window (with no records displayed in the subform):
CODE
?Forms!frmUntAsnUnitBookingsCardex.fsubUntAsnUnitBookingsCardex.Form.count

I get back 33. How is that possible?

How can I get the true record count in this subform?

Thanks.

Wayne
Go to the top of the page
 
DanielPineault
post Jan 11 2017, 11:05 AM
Post#2


UtterAccess VIP
Posts: 5,865
Joined: 30-June 11



See: http://www.devhut.net/2016/08/09/display-t...on-a-main-form/

--------------------
Daniel Pineault (2010-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc

All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
whdyck
post Jan 12 2017, 08:06 AM
Post#3



Posts: 252
Joined: 20-July 11
From: Winnipeg, MB, Canada


Thanks, Daniel.

Is it possible to post the attachment in an Access 2003 format?

Thanks.

Wayne
Go to the top of the page
 
DanielPineault
post Jan 12 2017, 08:50 AM
Post#4


UtterAccess VIP
Posts: 5,865
Joined: 30-June 11



Try the link again, there is now an mdb sample available to you.

--------------------
Daniel Pineault (2010-2017 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc

All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
« Next Oldest· Access Forms· Next Newest »
 
Display Mode: Switch to: Standard · · Switch to: Outline

Track this topic ·Email this topic · Print this topic · Subscribe to this forum

Custom Search
RSSSearch   Top   Lo-Fi    21st April 2018 - 02:16 PM