In this Microsoft Access tutorial I will teach you how to show what record you’re currently on and how many total records there are in your Microsoft Access form using the RecordCount and AbsolutePosition properties of a form’s RecordSet.
LEARN MORE:
599cd.com/RecordCount
PRE-REQUISITES:
Command Buttons: 599cd.com/CommandButtons
Intro to VBA: 599cd.com/IntroVBA
On Current Event: 599cd.com/OnCurrent
RECOMMENDED COURSES:
Access Developer 1: 599cd.com/ACD1
LINKS:
Recordset Properties MS: tinyurl.com/29t258tk
CONCEPTS:
Form_Current
Me.Recordset.AbsolutePosition
Me.Recordset.RecordCount
Form_ApplyFilter
Me.Recordset.MoveLast
NOTES:
And yes, I know there is a Count property, and a CurrentRecord property for a Form. Why do I use the Recordset properties then? Well, the Form.CurrentRecord property is fine, but the Form.Count property doesn't work right if you filter the form. Try it.
BECOME A MEMBER:
KZitem: / @599cd
or My Site: 599cd.com/THMember
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, recordset, recordcount, movelast, applyfilter, absoluteposition, Get Record Count, Count the number of records, record count, current record
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Негізгі бет How to Show What Record You're On and How Many Total Records There Are in Your Microsoft Access Form
Пікірлер: 46