Microsoft Access Switchboards and Navigation Forms. Why NOT To Use Them! Create Your Own Menu Forms
HTML-код
- Опубликовано: 30 июл 2024
- In this video, I will show you how to create a Switchboard, a Navigation Form, and my personal favorite method of navigating around a database which is to create custom Menu Forms. Plus, I'll show you a cool special trick for your Menu Form navigation.
Charlotte from Auckland, New Zealand (a Platinum Member) asks: What is the best way to create an interface for my users to navigate the different forms and reports in my database? Switchboard? Navigation Forms? Something else?
Silver Members and up get access to an Extended Cut of this video. Members will learn how to open forms directly to the right, or underneath the parent form. This is handy for creating menus where the forms may move around the screen. You can control the form's exact positioning from the calling form.
MEMBERS VIDEO:
• Switchboards, Navigati...
BECOME A MEMBER:
RUclips: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
599cd.com/Navigation
LINKS:
Blank Template: 599cd.com/Blank
Report Listbox: 599cd.com/ReportListbox
Dashboards: 599cd.com/Dashboards
Splash Screens: 599cd.com/SplashScreen
Favorite Customers: 599cd.com/FavoriteCustomers
Simple Security: 599cd.com/SimpleSecurity
Form Aesthetics: 599cd.com/Aesthetics
Alt Keys Navigate Ribbon: 599cd.com/ShortcutRibbon
Microsoft's Switchboard Article: tinyurl.com/yzarcgb4
Microsoft's Navigation Form Video: tinyurl.com/yfu9lwkd
COURSES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
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:
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:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, microsoft access switchboard, create and use a switchboard, What is a switchboard in Access, How do you create a switchboard in Access, alt key command button, movesize, openformright, open form right, form position, Where is the switchboard in Access, Switchboard Manager does not appear in the ribbon, Where's the Switchboard Manager Tool, Access switchboard vs navigation form, navigation form, How do you create a navigation form in Access
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Hi Richard just watched this video and so pleased I did. Agree with you its best to build your own. Loving learning Access as retired a few years ago. Have my little office in the extension we had built, so it’s like I go to work still, my wife loves it.
We are in our 70’s and keep active during the day, me using my Brain. Have produced several applications since 2016 for family, like Home Accounts .
Your guidance has been so helpful in my learning Access. Thank You so much. Kind Regards Stewart (West Yorkshire UK) 👍👏
Glad you enjoy my videos. Always keep learning. :)
I’ve been using access since 1997 and I just found out about the three boards. In access 2010 (that I still use) I learned switchboard. Before that I navigate it everything through my original form with buttons. That’s where I develop the name “button man“🤪 i’ve long since retired and use my access database now to record my rental income and expenses. You do a great job👍
Thanks, Button Man. :)
Thank you Mr. Richard, world do need more people like you
No formal training in Access, but like you, am a fan of making my own Menus from scratch. Have worked with Access since the 90's and am something of a control freak, thus my love of designing my own forms so I can control flow. Also believe in always room for improvement so enjoy your videos for inspiration and information on Access. Not in IT anymore as a stroke has taken me out of workforce sooner than anticipated in addition to limiting my activity options. Have a few Access projects in the works to provide my brain with some exercise, one of which is your genealogy dbfree video. Using the other two free videos for the ideas you presented to further develop my application. My copy of Access is 2003/2007 and hope to obtain a more current version or versions in the future.
Keep up the good work you are doing and thank you for all you have done so far.
Thank you very much for your kind words. :)
Hello. I totally agree with you about switchboard and navigation forms. I want to create a menu form from scratch that will be compatible with previous MS Access versions. So, i thought to create my application in which there will be a main container form. On the left side there will be a subform which simulates the main menu. And on the right side, according to the option that is selected in the main menu subform, there will be another subform that will displays i.e. customer form, orders form and so on. Just the same point of view like the navigation control but doing it from scratch and being compatible with previous Access versions,especially 2000-2003 that there was lack of navigation control. I know that instead of a menu form i could implement a list box with menu options, but i would like to add some images on the left of each option and generally i can use many parameters regarding user levels etc. The menu table which will be the record source for the menu form, will have 4 fields for start:
1. MenuID, 2. MenuName 3.FormNameToOpen 4. MenuNamePic (this one will be a path to a directory in which images are saved. I don't want to save images in database. I prefer to save them on the disk)
Is the above way good enough to be implemented or according to your experience there will be any difficulties in implementation?
Be careful using subforms.
Your material is far easier to understand than my college textbooks.
Thanks
Richard is 100% right about the navigation control: it causes major problems with VBA, because only the subform that is opened can be referenced with VBA. For instance, at 12:30, if CustomerF is opened, then all the other subforms are inaccessible, and you can't use VBA to get field values from ContactF, Manager Stuff, etc. or do anything with them. A better way to handle this is to use tab controls. You can have several tabs, each containing a subform, and ALL those subforms can be referenced with VBA at any time, back and forth. It is much less a programming nightmare than using navigation controls. Richard's own method of a menu form is fine too.
Yeah, I personally hate tabs... lots of glitches in them when they were first released. It looks like MS has fixed them, mostly... mostly... :)
Very helpful
Glad you think so!
As our great instructor Mr Richard Rost said ( to use navigation form is not a good practical tool) , so I decided to add all buttons and texts boxes to the main patient entry form in a colorful frame , and to be opened as pop up objects because I suffered alot with applying filters, or loading reports via navigation form
Yep
I want to thank you form Iraq
You are the best
Is there a way to do a navigation subform for a specific record?
You are free awesome sir..
Thanks. I think. :)
Best tip
Thanks
I can't control the size of my forms. Every form I create extends horizontally all the way to the right hand margen of my screen and vertically to the bottom margen of my screen. When I change the width in the property sheet it has no effect on the size of my form. Thanks for any help you can offer.
Sounds like you need to switch to Overlapping Windows... 599cd.com/OverlappingWindows
I find making my own easier to modify and reorganize as I add features and functionality.
Hi Sir how can i reference the form to navigation form during runtime and how can i align the form inside the navigation to center. Thank you.
I don't understand your question
Hello sir, I hope you are fine.
I have a question, in navigation control, Option Group filter doesn't work. Could you please tell me why it doesnt work.
599cd.com/ask
how can i change the navigation page using vba or macro programming
I get a ton of questions every day, and I don't have time to answer them all here on RUclips. Feel free to submit your question on my website at: 599cd.com/AskYT
Is it in Access 2010?
I'm pretty sure.
Prefer making my own menu forms. Better flexibility and control. 😊
IMO the best reason to not use nav forms is because only one form is open at a time thus you cannot refer to a form field that is not there to get its value.
Indeed!
very 👍
very nice
Thanks
IMADE MY OWN MENU FROM SCRATCH!!!!!!! I added a pic for a graphic background, then made the button designs in xcel, imported and added the fields for the button annnnndddd made the header a logo which I also designed
T
H
A
N
K
YOUUUUUUU
W
E
L
COME. :)
You are gorgeous
Thanks