Microsoft Access Split Forms and Why I Don't Like Them
HTML-код
- Опубликовано: 30 июл 2024
- In this Microsoft Access tutorial, I'm going to teach you about split forms: how to use them, what the pros and cons are, and why I don't like them.
LEARN MORE:
599cd.com/SplitForms
PRE-REQUISITES:
Access Beginner 1: 599cd.com/ACB1
RECOMMENDED COURSES:
Access Beginner 7: 599cd.com/ACB7
LINKS:
Evil Access Stuff: 599cd.com/EvilAccessStuff
Continuous Forms: 599cd.com/Continuous
BECOME A MEMBER:
RUclips: / @599cd
or My Site: 599cd.com/THMember
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
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, split form, splitter bar, SplitFormOrientation, acDatasheetOnBottom, subform, continuous form, single form, header, footer
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Good stuff. I love your list of "Evil Access Stuff." I remember being excited by split forms when they first came out and then...immediately going back to the way I did things before they were available. After watching your video, I'm glad I didn't waste any more time on them.
Yeah... a lot of the "bad tastes" in my mouth when it comes to Access features happened because they were not implemented very well when they were first released, or had major bugs. The worst was Data Access Pages. Remember those? OMG they were horrible. I'm glad MS nuked them.
Thank You very much for all of your Access tips, solutions and suggestions they are greatly appreciated. A very Merry Christmas and Happy New Year.
Happy holidays!
You saved me, thank you very much.
brilliant video, super helpful loved it!!
Thanks
Good morning Richard, nice video as always! I use a lot Split Forms, but i would like to start using continous forms like you're showing.. what do you think its the best way to apply multiple customized filters on a continuous form?
In the past, i tried but the new fitlers overwritten the first one and so on. Thank you a lot!
You write a custom SQL statement based on the fields you want to filter:
Access Search Template: 599cd.com/SearchTemplate
Merry Christmas and a Happy New Year!!!
same to you
"Uncle Rich", my true hero. Thanks for another awesome video.
very welcome :)
I have a split form where the toggle button currently works on the data sheet portion of the form. However, once I add a field that is a list, that allows multiple selections, the toggle feature no longer works on the data sheet. Does anyone know why or have the solution to fix?
Hi Rick. Nice video. I agree with you. I don’t like split formsever since you told me. I use single form and have search forms forms my database and when I do search I double click on the contact or anything in my databases. Merry Christmas!
Well said!
@@599CD Thank you Rick!
Nice Tips...... Thanks
welcome
@@599CD Thanks Again
Thank you very much for alternate solution. I think they haven't fixed the problem with split forms yet, as it suddenly stops responding or the scrolling is stuck especially when you experiment with the form. Often regains scrolling ability only when adjust the row height after opening the form each. Repeatedly remade the split forms a number of times continuously for three to four days. Fortunately I could make it right at the last attempt and still holds good. Presumed that I was making mistakes with the property settings.
Yeah, I still read of problems with them, and people send me issues to help them with all the time regarding Split Forms... which is why, again, I tell people to just not use 'em.
It is possible to add a photo to each record, thanks
599cd.com/Images
Thanks to this video I will never use split forms. Lol.
I have a question though. Is it possible to create a dynamic continuous form? One that changes based on your query or "filters" set?
599cd.com/QQ
I wholehearted agree with all your "Evil" points. I don't know why Microsoft introduced so many half-baked ideas. Perhaps to sell more SQL Server and other enterprise products. I recently inherited a few vba apps from a retiree that literally did everything here wrong and much more (including naming several fields just "Date" and after people in the office). I have all I can do to not just beg to start over. I also think Access' flexibility is its attraction and its downfall. It is "Enough rope to hang yourself" with too many ways to do the same thing, and still too many bad examples still online. You validate most of my understanding, but I always learn something new too. Thx
They introduced these half-baked ideas to help non-developers be able to do things that are more advanced... which is worse for them in the long run because they then have to learn how to do things properly and then un-F*@& their databases.