Enjoyed this video on the record set count. Looking for the list hints video that you made where you used union to put in the hint to “select one”. Really enjoyed that one😊
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!
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?
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. 🇲🇹
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.
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.
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)
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! 😊
This doesn't (display current record number in form) work in Access 365. Error message doesn't recognize ".absoluteposition" . The video was followed exactly.
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 | ... >
Enjoyed this video on the record set count. Looking for the list hints video that you made where you used union to put in the hint to “select one”. Really enjoyed that one😊
Loved the Bounce !!! WoW.... thank you for the Record absoluteposition !!!!
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!
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
Did you find a solution @jarvbox?
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
Love this stuff! Thanks, Richard.
My pleasure!
Yes please, more developer tips!
More to come!
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
Please do more and more developer s videos.
Roger that
think you
Wilcome
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
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 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
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..
Text box specific characters count
Eh?
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.
Hint: test for me.newrecord
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
Memo box words count
Huh?
I reviewed more than 10 times. My box is blank
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.