Ms Access Dynamic Menu 

Thank you for sharing.. looks very good!!!!

Excelente explicación así como el contenido 🙂

Great Video! Thank you.

You are such an artist! Excellent menu systems you have! I cannot find part 3 for the Dynamic Menus.

Great video!!! Thank you!!!!!

I like where you're going with this video, though I personally hate tabs, they're more trouble than they're worth in my opinion. I like hiding the tabs, but why not eliminate the middleman. Don't use tabs, just add seven subforms and make them visible or invisible instead of setfocus. If you don't mind some suggestions: maybe go a bit slower, try to eliminate the static and background noise, it will be less distracting.

Hello. Very nice implementation. And thank you very much for the provided information. I would like to ask a question. Would it be difficult if i wanted, instead of just plain buttons at the left for menu options, to create list box that brings the menu options from a menu table. This menu table will have MenuID as AutoNumber, MenuName as string and FormToBeOpened as string, MenuPic as string which will be a path to the disk where the image is stored). Or ever more to "simulate" this list box with a sub form menu. I thought about sub form menu, in case the menu options are changed dynamically based on user level, so menu pictures are changed dynamically as well. Alternatively, instead of having the tab control, i should have a sub form which will display the form based on the menu option i select from the left list box or menu sub form. I know that it sounds line a custom navigation control and newer Access versions have embedded this control, but i would like to create from scratch in order to be compatible with older Access versions. What should i take into consideration in the above implementations in your opinion? P.S. The tab control is very good for displaying such information and i was given an idea by your video to create a wizard form based on tab control for specific data entry.!!

What icon list are you using for your menu buttons at the beginning of your presentation, and where can we obtain the icon list? Interesting menu approach, thanks for sharing.

its a great implementation

Hi Sir Sissoko, Really appreciate your work and if possible I wanna learn from you...

Hello friend! I wrote the code exactly as you indicated but it's not working. Do I need to enable some reference in my access?

This is great, can you tell me how to use those additional tabs which you touch upon. I'd like one tab to have some buttons which open other tabs to site sub forms/datasheets

I would like to be able to view all the menus as well as the entire database in sequential tutorials.

Hi thank you great tutorial! just a question how to use the side button to navigate between the pages? without using the label part

Why my Access 365 is not the same as yours after I clicked at Create (a blank database)?

This is great 😍😍😍😍😍😍😍😍

Thank you for your instructions, they are really helpful. I have 2 questions: 1. If I am using quick style to color the background of my command buttons, how do I find the code for the color and gradient of the quick style chosen to make the code you have shown work? 2. What is the name of the video that shows how to set up security for the buttons, that was mentioned at the end of this video? Thanks again for all your instructions.

you dont need code to make the buttons highlighted: just use the "focus colour" property of the bottom to your highlight colour and access does the rest!

Thank your

Wonderfull

Do you have any idea why this code does not change my backcolor? I am following your steps, same box name, same button name, same design, code etc. There is no error message, tried on Office 365, office 2016, office 2019 the result is same, color is not changing.

Nice video. Is there a way to reach you? I would like an advice on a project

Hi. The SetBt() function you created, does not work for me under access 2007. Yet despite copying the code exactly as in the video and as stated in the description, it keeps returning the error " Property or method not supported by the object". Please can you help me. Thank you.

good job

hi, Where did you get those icon pictures on the button menu please

I get error Asset Master List cannot find the object 'SetBt()" when trying to following your video, please help

Hai, Sir..... Can we get an example of the MS Access this file ? Thanks.

Votre application est en français mais vous parlez en anglais Mr. Sissoko Je regarde juste mais vos explications sont en anglais 💔

I tried to add more buttons but after menu 9 it gives me an error. why?

Nice dashboard! Can you share the file with us?

friend i saw your video 100 times - every time i apply what you have said but the result still error

I know so many tips for it...

Pin that menu already!

good morning I started following your tutorial, I got stuck in coloring the buttons, I did everything like you did "Private Function SetBt() For i = 1 To 7 Me("B" & i).BackColor = Box0.BackColor Next Me.ActiveControl.BackColor = Box1.BackColor End Function" What am I doing wrong?

works without the tabs for me. but when i add the tabs i get "object doesn't support this property or method" Here is the code i used Private Function SetBt() Dim Ax As Single Ax = CSng(Right(Me.ActiveControl.Name, 1)) For i = 1 To 4 Me("B" & i).BackColor = Box0.BackColor Next Me.ActiveControl.BackColor = Box1.BackColor Me("P" & Ax).SetFocus LB0.Caption = Me("B" & Ax).Caption End Function