How to Open a Popup Form Over the Active Control and Return a Value in Microsoft Access, Part 2
In this Microsoft Access tutorial I will show you how to pass values back from a modal popup form to the original control using TempVars, set up event handling for reusable popup functions, and make it easy to add popups to multiple fields and forms by using a public function for the On Click event. This is part 2.
Silver Members & up get access to an Extended Cut of this video. In the extended cut, we will cover how to work with subforms, including detecting if a control is on a subform, figuring out subform coordinates inside the main form, and determining which row you are on. I will show you how to handle pop-up over controls on subforms, which involves more advanced coding than with standard forms.
MEMBERS-ONLY EXTENDED CUT VIDEO:
https://youtu.be/bJIMJdbscKc
BECOME A MEMBER:
YouTube: https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: https://599cd.com/THMember
LEARN MORE:
Popup Over Control 2: https://599cd.com/PopupOverControl2
PREREQUISITES:
Popup Over Control, Part 1: https://599cd.com/PopupOverControl
LINKS:
Event Handler: https://599cd.com/EventHandlerFunction
RECOMMENDED COURSES:
Access Developer Courses: https://599cd.com/Developer
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates
DIAMOND SPONSORS:
More info on our Sponsors: https://599cd.com/DiamondSponsors
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
How to Use Access in 30 Minutes: https://599cd.com/30Minutes
$1 Access Level 2: https://599cd.com/1Dollar
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter: https://twitter.com/LearningAccess
https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/
KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 2024, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, pop-up over control, modal form value return, tempvars usage, passing values between forms, vba on click event, global module function, public function event handler, control name referencing, forms collection, subform value return, dynamic default button, form object manipulation, extended cut tutorial
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
Видео How to Open a Popup Form Over the Active Control and Return a Value in Microsoft Access, Part 2 канала Computer Learning Zone
Silver Members & up get access to an Extended Cut of this video. In the extended cut, we will cover how to work with subforms, including detecting if a control is on a subform, figuring out subform coordinates inside the main form, and determining which row you are on. I will show you how to handle pop-up over controls on subforms, which involves more advanced coding than with standard forms.
MEMBERS-ONLY EXTENDED CUT VIDEO:
https://youtu.be/bJIMJdbscKc
BECOME A MEMBER:
YouTube: https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: https://599cd.com/THMember
LEARN MORE:
Popup Over Control 2: https://599cd.com/PopupOverControl2
PREREQUISITES:
Popup Over Control, Part 1: https://599cd.com/PopupOverControl
LINKS:
Event Handler: https://599cd.com/EventHandlerFunction
RECOMMENDED COURSES:
Access Developer Courses: https://599cd.com/Developer
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates
DIAMOND SPONSORS:
More info on our Sponsors: https://599cd.com/DiamondSponsors
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
How to Use Access in 30 Minutes: https://599cd.com/30Minutes
$1 Access Level 2: https://599cd.com/1Dollar
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter: https://twitter.com/LearningAccess
https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/
KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 2024, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, pop-up over control, modal form value return, tempvars usage, passing values between forms, vba on click event, global module function, public function event handler, control name referencing, forms collection, subform value return, dynamic default button, form object manipulation, extended cut tutorial
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
Видео How to Open a Popup Form Over the Active Control and Return a Value in Microsoft Access, Part 2 канала Computer Learning Zone
TechHelp Access 2016 Access 2019 Access 2021 Access 2024 Access 365 Microsoft Access MS Access MS Access Tutorial #msaccess #microsoftaccess #help #howto #tutorial #learn #lesson #training #database pop-up over control modal form value return tempvars usage passing values between forms vba on click event global module function public function event handler control name referencing forms collection subform value return dynamic default button
Комментарии отсутствуют
Информация о видео
6 мая 2025 г. 18:01:13
00:14:11
Другие видео канала