How to Show What Record You're On and How Many Total Records There Are in Your Microsoft Access Form
ฝัง
- เผยแพร่เมื่อ 3 พ.ย. 2022
- 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:
TH-cam: / @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.
![[TH] 2024 PMWC x EWC Group Stage Day 3 | PUBG MOBILE WORLD CUP x ESPORTS WORLD CUP](http://i.ytimg.com/vi/VnOqutfqWqU/mqdefault.jpg)
Loved the Bounce !!! WoW.... thank you for the Record absoluteposition !!!!
Love this stuff! Thanks, Richard.
My pleasure!
Rick,
I would enjoy seeing the developer tips as well and I think others would appreciate it if your busy schedule would permit it. Enjoy the videos as always!
Will do!
Yes please, more developer tips!
More to come!
Thanks for the great effort. I need to paste a value into a set of specified rows in the table through VBA Code
599cd.com/Ask
Thank you
Great video and exactly what I was looking for. I stumble however as my form is a subform and doesn't seem to work unless you cycle through the records. Is there a workaround to trigger the VB code whenever the containing fom updates?
599cd.com/Ask
Wow, exactly what I was looking for: how to create a box that shows the current record in a group or set. I need it for my sampler keyboard database as it would show the file number of a sound in a directory in the drive. Thank you very much it was very tricky to guess. I didn't even know it's name, that is, the current record number.
🇲🇹
Glad I could help!
Rick another great video thanks. Question at about 10:32 the RecCountBox goes from X of 29 to 1 of 1 after you took out the navigation menu. why was that?
OH I see after the Bonus you show why, Duh I should just watch it all the way then ask questions. Thanks again.
Great idea. :)
This was very useful. I have a question on how to keep a subform updated if I add a record in the subform. Example. I open original form and subform shows "1 of 14" then I add a new record to the subform and it does not update until I close the form.
I've never seen Access behave that way.
Thank you for this information, but if the records are in a subform and the condition is applied from the main form, the counter does not change
This video does not address subforms
i just wanna ask, what to do if i have 24 total records and if i go to new record, the number is still stuck with 24 rather than 25 :)
You'll be on record 25 as soon as you type the first piece of data into it.
How about if you want to display the record on MAIN MENU FORM.. Is Possible?
Sure
@@599CDsir how about By YEAR to display record.. example i want to display all record of 2022.. can you make a tutorial sir..
The absolute position is only valid within a sort order. If you change the sort order, the absolute position changes accordingly. I want my form to change sort order but remain on the current record. Changing sort order at runtime causes the recordset to go to absolute position 'first' ( 0 or 1 as you like)
Thanks for sharing
Please do more and more developer s videos.
Roger that
This doesn't (display current record number in form) work in Access 365. Error message doesn't recognize ".absoluteposition" . The video was followed exactly.
Well since I'm using Access 365 myself then you're probably doing something wrong - try again from the beginning
I have a database with many participants, which all have an ID stored in a number field named “PartID” in my table named “1 - Participant Information”. Example: Sarah is set as number “88”.
I use a combo box, with a drop-down arrow list to choose which participant’s information will appear on my form, using the “PartID” number that I selected - (this combo box is set to fetch values from another table).
As an example, If I want to bring up Sarah’s data on the forefront of my form, I simply select “88” from the drop-down menu combo box. Sarah’s info is thus loaded on screen.
My question:
A - How do I create an event procedure (Using VBA - on a button) which will tell this combo box to change number and load a different number on screen.
As an example - number “88” is loaded, but I want to press a button which will tell the combobox on the form to move from number “88” to number “89” - OR from number “88” to the previous number “87”.
Please note that the GoToRecord function does not work, because I am using a record source from another table and that the record selector does not display my 122 participant records on that specific form.
I want to know a way to do this using VBA to change the value selected on my “Part ID” combo box.
Any help would be appreciated! 😊
Post this in my Forum: 599cd.com/AF
think you
Wilcome
Text box specific characters count
Eh?
I reviewed more than 10 times. My box is blank
Memo box words count
Huh?
Hi Uncle,
I'm Faique Shaikh . I'm 11 Years.
I Wanted To Make A Revenue App . In Which Can Enter The Revenue Every Month By Checking The Dash board.
599cd.com/Ask
I also don't like the built-in navigation buttons because the user can't directly navigate to the desired record(s). So I often create navigation links like the ones you see on websites: < 1 2 3 4 5 | 6-10 | 11-20 | 21-30 | ... >
It's funny you mention that... one of my members just asked if that was possible. Might do a video on it soon.