How to Replace Multiple Yes/No Fields With Properly Relational Solution in Microsoft Access
HTML-код
- Опубликовано: 8 сен 2024
- In this Microsoft Access tutorial I'm going to teach you how to replace having multiple yes/no fields for a customer with a properly relational solution that involves a many-to-many relationship and a junction table. This will allow you to easily create additional options in the future without having to go through table and form redesign.
Bruce from Boston, Massachusetts (a Platinum Member) asks: I have about 15 different yes/no fields that I use to set options for my customers. For example, do we provide them with hardware, service, software? Are they on the mailing list? Do they have a warranty? Are they an active account? Things like this. I've heard you say several times that having 15 different fields and 15 different checkboxes on my form is not the best way to go about this. And yes, every time I want to add an option it's a pain. Can you show me the better way?
Silver Members and up get access to an Extended Cut of this video. Members will learn how to prevent duplicate options. We will also make a button you can click to add all of the options to a customer's account so then all you have to do is check the values you want to set to yes. We'll do it both with recordsets (the hard way) and a single line of SQL code (the easy way).
MEMBERS VIDEO:
• Multiple Yes/No Fields...
BECOME A MEMBER:
RUclips: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
599cd.com/Mult...
PRE-REQUISITES:
Many-to-Many: 599cd.com/M2M
Subforms: 599cd.com/Subform
Relational Combo: 599cd.com/Rela...
LINKS:
Triple State: 599cd.com/Trip...
Prevent Duplicates: 599cd.com/Comp...
RECOMMENDED COURSES:
Access Expert 7: 599cd.com/ACX7
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
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/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
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, multiple check boxes in a subform, replacing several check boxes, form with many check boxes, multiple checkboxes, add several check boxes, multiple yes/no fields
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Hi Richard excellent video. Just watched your auto text video which was very informational great. Steve b
always thumbs up to the greatest Access teacher Richard. Thanks Richard
You're welcome
been watching lot of your videos all weekend...youve been helping me with formulating a method of creating Payroll Notices for work. think i have general idea just need to think all the little nuances that come up today and how to address them in the system 👍
Sweet! Glad you like it.
Exposure to an entirely new layer in relationships and optionality. Really good one Richard and thank you. Pondering how this can help with a dynamic form, i.e. choosing what goes on a form or a view basis what fields have been "activated" for a given customer. Some form geography considerations would have to accompany that , since we dont know what's going to show based on the selections in each customer case. Just a thought. Maybe a bad one... :) Maybe another video... Thanks again sir!!
Sounds like just making certain fields visible or not in the OnCurrent event. 599cd.com/OnCurrent
@ 4:10, Love the "Firefly" reference!
Shiney
I've been debating with myself about whether to do this on one of my tables. I have about 20 yes/no fields and, yes, doing it this way makes a lot of sense. However, I'd like the user (me) to be able to choose the criteria to search for, including the yes/no fields. Eg. Find all the customers who live in Florida and are also Trekkies AND Browncoats and DON'T have a warranty. This would be fairly straightforward if they were all in one table, using the multi-field search, but a lot more complicated when the yes/no fields are separate. Do you have a video that would give advice on this, please? (Hopefully a free one - I'm just a geek learning this for fun, not a company or using it for work) I'm loving your videos!
Yeah, but it's fairly complicated. I cover something similar in my 599cd.com/SearchSeminar
Thank you : )
Wish I watched this a month ago before I put in 300 records with 20 potential check boxes per record.
Sweet
Hmmm... Is it Not working for me? that's weird because I did all you did on the video but it doesn't update by clientID?
I fix it! now it's all good! thanks for your video! very well explained!
Glad to help. :)
"You've taken something I did as a lark and turned it into a colossal waste of time."
:)
Trekker. Not trekkie.
I'm a Trekkie. I've taken over the term from people who used to pick on Trekkies and call us nerds, which forced some people to coin the term Trekker. Nope. Not me. Trekkie and proud.
@@599CD Good luck with that.
And thanks for the high quality videos on Access!