Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...
MS Access Forum / Forms Programming / March 2007

Tip: Looking for answers? Try searching our database.

RecordCount Property

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JamesJ - 31 Mar 2007 01:12 GMT
Hi. I had code to display the number of records using the RecordCount
property in a label but have misplaced it.
The code example in Microsoft Visual Basic help was way more than I needed.
Can someone point me to an example?

Any help will be appreciated,
James
Reply to this Message
missinglinq - 31 Mar 2007 01:19 GMT
YourLabelName.Caption = "Record  " & CurrentRecord & "  Of  " &
RecordsetClone.RecordCount & " Records"

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Reply to this Message
JamesJ - 31 Mar 2007 01:33 GMT
Works fine. Thanks

James

> YourLabelName.Caption = "Record  " & CurrentRecord & "  Of  " &
> RecordsetClone.RecordCount & " Records"
Reply to this Message
fredg - 31 Mar 2007 01:23 GMT
> Hi. I had code to display the number of records using the RecordCount
> property in a label but have misplaced it.
[quoted text clipped - 3 lines]
> Any help will be appreciated,
> James

If you use an unbound Text control:
=[RecordsetClone].[RecordCount]

If you wish to display the count in a Label control, you'll need to
use VBA code.

Me!LabelName.Caption = Me.[RecordsetClone].[RecordCount]
Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message
JamesJ - 31 Mar 2007 01:35 GMT
In a label but can't get it to work.
Should the code be in the On Current of the form?

James

>> Hi. I had code to display the number of records using the RecordCount
>> property in a label but have misplaced it.
[quoted text clipped - 12 lines]
>
> Me!LabelName.Caption = Me.[RecordsetClone].[RecordCount]
Reply to this Message
fredg - 31 Mar 2007 16:32 GMT
> In a label but can't get it to work.
> Should the code be in the On Current of the form?
[quoted text clipped - 17 lines]
>>
>> Me!LabelName.Caption = Me.[RecordsetClone].[RecordCount]

Yes, the Current event should work fine.
Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.