Great video, thank you one note: Calling the 12 buttons with B11, B12, B13...B20, B21, B22 TABs with P11, P12, P13...P20, P21... The SubTabs with P11S1, P11S2,...P19S1, P20S.... and taking into consideration the LAST 2 characters of Button (11, 12, 13, ..20..22) it is avoided that by clicking on the B1 button, SubTab 10 or 11 or 12 (those containing a “1” at the beginning) is also displayed --> on the unction SetBt : change: Dim Ax As Integer change: For i = 11 To 22 (or button n°) ;)
@Kizigira3 ай бұрын
Spit first then speak.
@thaisrivera79663 ай бұрын
GENIAL!!!!!! 🤩
@ilhamsenjaya94523 ай бұрын
This amazing , i looking for this thanks
@macmacho3 ай бұрын
Hello! Please: The content is not available for download. Please send me a new link. Thanks
@FasuTech4 ай бұрын
I have watched and follow all your tutorials, please can you show me how to bring forms to my menu.
@premshah62004 ай бұрын
I got a message you don't have permission please do needful
@premshah62004 ай бұрын
i cannot download your template
@premshah62004 ай бұрын
or sample database
@iredekoty76804 ай бұрын
Monsieur svp je peux avoir un exemplaire svp
@GALLERY-964 ай бұрын
You are amazing and very grateful. could you please tell me how to add those icons to the buttons??
@sissokom.prodev99794 ай бұрын
@@GALLERY-96 the bigger square is a transparent button , and juste put any image icon above, that is trick !
Thanks I really appreciate it, please help me with download like on youtube to download sample database the link above is not working.
@Puti31647 ай бұрын
terimakasih my friend here is the function to do the job Private Function SetBt() Dim Ax As Single Ax = CSng(Right(Me.ActiveControl.Name, 1)) For i = 1 To 7 Me("B" & i).BackColor = Box0.BackColor Next Me.ActiveControl.BackColor = Box1.BackColor Me("P" & Ax).SetFocus LB0.Caption = Me("B" & Ax).Caption End Function 🙏
@jameskojopaintsil96237 ай бұрын
Hi Sir, thank you for the insight, please how can I link the buttons to their respective forms and queries
@TLDW_Tutorials7 ай бұрын
As a fellow KZbinr and Access developer myself, I just wanted to say this is a beautiful layout and interface. Well done!
@daviddesideri574810 ай бұрын
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?
@borgehansen668010 ай бұрын
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.
@alfredallen611311 ай бұрын
Nice video. Is there a way to reach you? I would like an advice on a project
@sissokom.prodev997910 ай бұрын
on ms access master group on facebook facebook.com/groups/345768833121934
@KentReynolds Жыл бұрын
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!
@maxcanispugnax4082 Жыл бұрын
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.
@sissokom.prodev9979 Жыл бұрын
Hi ! Some properties has been created in office 2013… the database sample we provide is created from office 2016
@alixstlouis3133 Жыл бұрын
I would like to be able to view all the menus as well as the entire database in sequential tutorials.
@akhileshyadav7366 Жыл бұрын
I know so many tips for it...
@sissokom.prodev9979 Жыл бұрын
Tips about Ms Access ?
@kemalayaz6459 Жыл бұрын
Wonderfull
@suadshatat Жыл бұрын
friend i saw your video 100 times - every time i apply what you have said but the result still error
@sissokom.prodev9979 Жыл бұрын
Go to ms access Master group on Facebook to post your error screenshot ! You will be guided facebook.com/100015557976530/videos/137307092721802/?mibextid=v7YzmG
@myltonnogueira2385 Жыл бұрын
good morning I'm trying to download your example on facebook. yet he does not authorize it. I don't think I have permission. would there be any other way? thanks
@sissokom.prodev9979 Жыл бұрын
you need to be accepted in the group before download
@haroldcruzcorrea Жыл бұрын
Excelente explicación así como el contenido 🙂
@simonmaersk Жыл бұрын
Looks very cool! Thanks for sharing
@patrickzanchette3913 Жыл бұрын
Very instructive - thx. What would prevent the company "Global Trade" to give/sell the application to someone else that would also use the name "Global Trade" to avoid paying a license?
@JeserCotrim Жыл бұрын
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?
@alfredomorello17632 жыл бұрын
I tried to add more buttons but after menu 9 it gives me an error. why?
@sissokom.prodev99792 жыл бұрын
Go to ms access Master group and download the last version of sidemenudb7 .. to download the file you need to be accepted in the group
@zoubela39742 жыл бұрын
Looks like the access to file is not authorized; please make it available as we are interested in your chanal; Merci Monsieur pour vos video, tres bien expliques
@sissokom.prodev99792 жыл бұрын
Hi .. you need to be accepted in ms Access master group in order to download the file … request membership then we will accept you
@bobykumar39602 жыл бұрын
good job
@sissokom.prodev99792 жыл бұрын
Thanks
@mehdihamedi1232 жыл бұрын
This is great 😍😍😍😍😍😍😍😍
@sissokom.prodev99792 жыл бұрын
Thanks ! :)
@RichardNickyBrian2 жыл бұрын
I really like your video ....Thanks for your great effort. But please what is the name of the group so i can join.
@sissokom.prodev99792 жыл бұрын
Ms Access Master m.facebook.com/groups/345768833121934/permalink/475388916826591/
@RichardNickyBrian2 жыл бұрын
@@sissokom.prodev9979 Please i have joined the group and how can i download the Key Licensing Technique and Password Hash (DB or VBA Code) as you promised to share it to us. Thank you.
@sissokom.prodev99792 жыл бұрын
@@RichardNickyBrian m.facebook.com/groups/345768833121934/permalink/620222279009920/ The file link
@RichardNickyBrian2 жыл бұрын
@sissokom.prodev9979 Thank you.... Please can you make the database to run from "Date 1" to "Date 2" using tables or any method then it will get expired, so you can control your software by generating a (Serial Number, Activation Code/Renewal Code/Subscription) for it to run based on client subscription like 6 months, 1 year etc. This your video technique is good and helpful but it seems the Client will use it forever after he/she had received the "Company Key and the Pc Mac Address from you the Developer. Thank you.
@sissokom.prodev99792 жыл бұрын
@@RichardNickyBrian hi Richard! That is possible just get a little more imagination :)… you can generate a pc key by combining the Mac Adress of the pc and the expire month and year .. if you like ! Or juste generates a company key + 12/2022 , so you don’t need to go and give them a key for each pc
@henryjayr2 жыл бұрын
How do I put content inside the tab and sub tab?
@henryjayr2 жыл бұрын
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
@henryjayr2 жыл бұрын
got it working. How do I add data from other tables in the tabs and sub tabs?
@izeckelibrah9162 жыл бұрын
how did you solved this issue bro?
@Nassallm2 жыл бұрын
brother the link of Facebook not found
@sissokom.prodev99792 жыл бұрын
You need be accepted in Ms Access Master before being able to download
@Nassallm2 жыл бұрын
@@sissokom.prodev9979 group not found even i search MS Access Master
@Nassallm2 жыл бұрын
@@sissokom.prodev9979 can you email me this file
@noone64762 жыл бұрын
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.
@sissokom.prodev99792 жыл бұрын
:) ….. thanks for your comment ! For the question 1 : we don’t have a specific code to copy the style of a button to another ! But you can just create a hidden button named button sample then in the code you say me.button2.backcolor = buttonSample.backcolor etc… For the question 2 , : are talking about how to secure your database copy , or secure a button ? Another video link : Ms Access Dynamic Menu 2 KZbin Msaccess Menu 2 kzbin.info/www/bejne/aKurgn2jr7KsmaM Side Menu 3 Ms Access Adavanced Login Form and User's Menu Controle kzbin.info/www/bejne/l365fKyJi751qNk Side Menu 4 sqlserver connection ,DataMacro Stop Using link Table , custom message box ,Advanced For kzbin.info/www/bejne/rYjLeaGYqLabh7M
@noone64762 жыл бұрын
@@sissokom.prodev9979 thank you so much... This is exactly what I was looking for... Thank you again
@good-sharing2 жыл бұрын
Why my Access 365 is not the same as yours after I clicked at Create (a blank database)?
@abegahilrachid50102 жыл бұрын
Ganhou mais um inscrito ermano.
@s.sloppy19992 жыл бұрын
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.
@constructioncost2 жыл бұрын
I experience the same thing but I manage to find out how it happen. Try to change the color of the button from what he did. I think you made it transparent.
@paulajimenez89642 жыл бұрын
Great video!!! Thank you!!!!!
@44louix2 жыл бұрын
hi, Where did you get those icon pictures on the button menu please
@sissokom.prodev99792 жыл бұрын
Iconarchive.com
@44louix2 жыл бұрын
@@sissokom.prodev9979 Thanks sir, but do you know why when i insert the picture on my button, it looks very small and not big like yours
@antarboua19882 жыл бұрын
Can i have the function code please!
@sephjvr59792 жыл бұрын
Great Video! Thank you.
@harun24hr2 жыл бұрын
Nice dashboard! Can you share the file with us?
@sissokom.prodev99792 жыл бұрын
The file is on the Facebook group : MS Access master : you need to be accepted on the group in order to download the file facebook.com/groups/345768833121934/permalink/620222279009920/?mibextid=wACSiI&fs=e&s=cl
@harun24hr2 жыл бұрын
@@sissokom.prodev9979 I am already member of that group. I have few post on MS-ACCESS on this group.
@sissokom.prodev99792 жыл бұрын
@@harun24hr so go to the group files and find sidemenu DB 7 , that will ne is the last version published
@explozivac2 жыл бұрын
In years on KZbin, I subscribed to three channels - yours being the third one! I also create Access databases and have seen tons of videos where people offer lessons on codes, etc. However, after watching a number of your videos I got impressed with your ability to simplify things while making them work perfectly well. I keep seeing hundred lines of code to do three operations - you make three lines of code that perform hundred operations. That's impressive! Well done! By the way, for us who are not on Facebook, how can we get in touch with you? :-)
@sissokom.prodev99792 жыл бұрын
thanks for your comment :) !! the only link we is the facebook link to download the file ! if you don't want to register to facebook with your email, you can create one to use there only.