59. Securing Your Front End (Programming In Microsoft Access 2013) 🎓

A newer version of this series has started for Microsoft Access 2016 here:
• Microsoft Access 2016 ...
----------
Securing Your Front End in "Programming in Microsoft Access 2013". Hosted by Steve Bishop.
In this free beginner video tutorial series Steve will be going over Database Development in Access, creating the User Interface, and coding the backend of the application in Visual Basic for Applications (VBA).
Update: Due to some kookiness in Access, the ribbon XML has been updated in the work file. Please check the work file to see how to get rid of the Privacy Options.
Click here for the full playlist of "Programming in Access 2013"
• Programming in Microso...
Click here for the Work Files of this series:
github.com/Xip...
----------
Become a member today for only $5 a month!
/ @programmingmadeez
When you join, here’s what you’ll get:
* Your name in the credits
* A form to ask me for help on your project
* 10% off in the Teespring store (discount code)
----------
Looking for DAILY news and commentary? Join us on my other channel “Coffee With Steve” for daily videos where we discuss Technology, Software Development, Politics, Culture, and many other things.
Coffee With Steve: / @coffeewithsteve

[@ProgrammingMadeEZ]

Looking for DAILY news and commentary? Join us on my other channel “Coffee With Steve” for daily videos where we discuss Technology, Software Development, Politics, Culture, and many other things. Coffee With Steve: kzbin.info/door/eXAUvo5xxDY_b-lSknPC1A

[@boink8653]

Hi Steve, I'm trying to work on a project that requires building a student management system in access. I want to know where I should start with your videos (I've created the tables, forms, queries and I want to publish the database after creating a good front end) I'ed appreciate your help

[@TrenTGaming]

Pls help me I have done all that but when i am trying to bypass it with shift key it is not working btw thank you for your help greats vids

[@benjaminsart9195]

Keep doing what you doing Steve. This guy is my goto for broadening my knowledge in Access and his tutorial is so easy to follow and he explains what the different function, variable, etc. does just so you know that you have that option. Highly Recommended.

[@bobthuli4715]

Your whole series is fantastic! Your explanations and examples are by far the best I've seen. Thanks so much for helping us out!

[@ProgrammingMadeEZ]

+Bob Thuli I am so glad you have found the videos helpful.

[@authorrajusingh6916]

Hi Steave Thank you so much for your tutorials you are so good at explaining.I struggled whole day setting up xml finally it worked- (MS 2016)- here is the code friends

[@VicRauch45]

Raju, THANK YOU, THANK YOU, THANK YOU!!!! I could not find any errors in my code, and I checked 4 times and even had my wife check it. But still would not work. But the code you shared here, WORKED!!!! THANK YOU SO VERY, VERY MUCH!!!!

[@itsamore382]

@@VicRauch45 Me either! However, when I hold he shift and open the database, it still doesn't show me the options in the File menu. Are you having this problem too?

[@VicRauch45]

@@itsamore382 No, I'm not having this problem. But I do my database a little different than what was suggested in the video. I have TWO copies of the same database. One is the one that I give to the users. It has EVERYTHING locked down so they can not get at anything. The other copy is mine and it is NOT locked down at all. Whenever changes or upgrades are done to the database, when it is ready for release to the users, the last thing I do is make a copy of the database, and then add all this "Lock It Down" code to the new copy, then release it to the users. But the origninal database without the lock-down code is still in my position, and the users have no access to it. This saves me from the problem of something going wrong within the lock-down code and making me very unhappy about having to completely re-write the entire database because I have locking myself out of it.

[@MaraingMuong168]

Really thank you Author Raju Singh many thanks it is working

[@asniceful]

Great video! I started Access VBA programming by watching your videos. Thanks

[@premshah6200]

Thank you for very good presentation of access database learning. I see many videos of your and Richard sir. Very thankful for both of you. As a result I have created a desktop application accounting with GST for all India in access 2021. Thanks and obliged.

[@JFourie464]

Thanks for a high quality and truely professionally presented tutorial! I subscribed after watching only one, but I can see that I will be spending a lot of time on this channel!

[@agustintorres6034]

Bruh! you must be liying! stop them drugs!\

[@jarrodparks6984]

If you tried this code and the Shift+open did not enable the menus again, here is how I was able to get the menus back: There is a drop-down menu at the top left-hand corner (beside the Save icon, and the Undo and Redo icons). I clicked on that drop-down menu and selected "More Commands..." which allowed me to get to the "Current Database" settings. I was able to check "Display Navigation Pane", "Allow Full Menus" and "Allow Default Shortcut Menus".

[@claudettejohn2479]

Hi Jarrod, I am new to this and was having the same problem, however I followed your suggestion and it worked , but the problem the users will still have access to the "options" command, which will defeat the purpose of unchecking these boxes..i.e. that the users will not have access to the Options command thus preventing them from going into the database and making changes. Is there any other way to get the users to run the record.

[@jarrodparks6984]

Hi Claudette - Glad it worked for you. I'm on the same page as you - looking for a solution to both. I'll let you know if I find the final solution to both problems.

[@claudettejohn2479]

Thanks Jarrod, I'll let you know if I come up with something as well.

[@davideggleston837]

Thank you for the wonderful video. So many videos skipped the AllowBypassKey option. Then the few tutorials I found for that option were not videos and did a poor job of telling how to insert their code so a nonprogrammer like me was having trouble using them. Your video was so easy to follow and then I just made backups before each step incase their was a bug in my code and the results was a nice secured database.

[@markepps3511]

Thanks, Steve, great tips. I'm using Access as a front end for a cloud hosted MySQL db and want the Access layer to look, feel and act like a secure application. Your video will help a lot.

[@ren-OMG]

Thanks dear, i recommended this channel to my friends.

[@ProgrammingMadeEZ]

+Renjith Kuttichira Well thank you very much!

[@AkirosGuy]

First of all, thanks for your awesome videos. I've watched a couple of tutorial series for access, and I can easily say this is by far the best one. Congratulations and thank you! My problem is that shift + open doesn't open my database in bypass mode. To be precise, i've only managed to open it in bypass mode like 4-5 times, and i'm stuck with this issue for like 30 minutes. Things i've checked so far: -Yes, i have chosen to turn on bypass (even made a second version without the bypass part in login form, so bypass was never turned off in this version). -Yes, my shift key is working. EDIT: checked it in another pc with access and it works fine (every time i shift + double-click, it opens in bypass if it is on). So, it must be something on my pc. EDIT: Also, forgot to mention that I used Access 2016, not 2013, to build my project, if that is important. I was wondering if there is some kind of trick regarding the use of "shift + open" (e.g. hold shift some seconds before clicking, use shift + double click instead of shift + enter or visa versa, etc). I know this may not be an access issue, but any idea why this is happenning would be a great help.

[@ProgrammingMadeEZ]

Be sure to hold the shift key down for the entire time the database is opening. If you let go before the database has performed all of it's startup then it will not work.

[@AkirosGuy]

You are right, now it works. Thank you SO much! It was getting very annoying.

[@haydarm.al-samawe9819]

man .. you amazing .. i had good experience in MS Access .. but with your videos now i get more and more .. thanks

[@ProgrammingMadeEZ]

Bill Baird I had thought about that but I think I'll introduce accde a little later when we talk about distribution of software and bundling for commercial purposes.

[@SSLDHL]

Dear sir... question by Mr. Jarrod Parks is also important i found. Can u check please... below... details ... "If you tried this code and the Shift+open did not enable the menus again, here is how I was able to get the menus back: There is a drop-down menu at the top left-hand corner (beside the Save icon, and the Undo and Redo icons). I clicked on that drop-down menu and selected "More Commands..." which allowed me to get to the "Current Database" settings. I was able to check "Display Navigation Pane", "Allow Full Menus" and "Allow Default Shortcut Menus".

[@YMenesy]

Thanks Steve!!! I have had the videos from Lynda, yet, yours were more interesting and helpful! I did have had a lot of issues with hiding the ribbon, QAT, and the buttons within file, but then after 2 days of searching, i found this: " DoCmd.ShowToolbar "Ribbon", acToolbarNo " (without quotation marks), add that to the Login form "On Load", and all options should disappear. And if you would still want to hide the options within "File", here is this little bit of code (Make a table named USysRibbons and put the following info in it like in the video): (Applies to office 2016)

[@adeelqadri]

Thanks, the code in the video didn't work. This one is working.

[@13GSscca]

The weblink to schema is dead. We need to find the new one for this to work

[@whatGoodisLife]

Hi, Steve. I note there is Quick Access Toolbar as a loophole for your coding here in which a user can still open Access Options by clicking More Commands... If Quick Access Toolbar is removed it will be perfect. I use MS Access 2010.

[@danklarman2299]

There is a loophole: The QAT is still available and commands can be accessed by customizing it. Even if it is hidden in code - if the file is renamed and the content security warning shows than it can be accessed again. The solution is to use "startFromScratch=true" - but that means you will need to build all the buttons that you want available on you own...

[@ProgrammingMadeEZ]

+Dan Klarman Thanks for the comment Dan. That's correct, I did not cover disabling the QAT and I probably should have looking back on it now. However if you save the file as an ACCDE file using the save as dialog within Access, it will not be accessible later even if you try renaming it.

[@kevinolmstead2268]

Hello, Just for FYI you know the AllowBypassKey can be changed remotely. So in another DB you can replace the CurrentDB with a reference set to the target DB and alter the setting as easily as you show it here. So a determined user could download a tool that does that very thing and turn it back on. I do this all the time with my DBs. I don't even have code in some to set this, because why would you need to if you can do it remotely, but again if you can anyone can. The code would look something like this: dim trgtDb as DAO Database Dim PathRef as String PathRef = "C:\blah\blah\NameYourDb.accdb" Set trgtDb = DBEngine.OpenDatabase(Name:=PathRef, Options:=False, ReadOnly:=False) trgtDB.Properties("AllowByPassKey") = [True/False] True : Next the time trgtDb is opened the bypass key will function. False: Next the time trgtDb is opened the bypass key will not function

[@CoffeeWithSteve]

Yes and ultimately the answer is to generate an accde file that is a binary executable that is compiled VBA rather than the ACCDB file which there will always be work arounds if you're really knowledgeable of.

[@JRubi-on5up]

Thank you Mr.Steve for your easy to follow tutorial video.

[@TrenTGaming]

Pls help me I have done all that but when i am trying to bypass it with shift key it is not working

[@tonitoni9368]

Thank you Mr.Steve for your easy to follow video.

[@cwatry2453]

Thank you for the prompt reply, sorry for the confusion. What I meant is that when I tried to open the db file while holding down the shift key, it opened the db w/ full controls instead of just opening to the Login Screen as we want. I thought I fixed the problem as it seemed to work on first attempt; however, once I login and open it as Admin and then re-open it using the bypass (shift) key it seems that every subsequent attempt to open it w/ the shift key is successful in opening the db w/ full controls. So, I restarted my computer but that also didn't work. Not sure where I'm going wrong.

[@cwatry2453]

In other words, it does not over-ride the bypass key whereby the shift key continues to work despite the routine we build here.

[@paintedveil4650]

Dear Mr. Bishop,Thank you very much for the lessons and the code you provide in them!They are very usefull, easy to understand and fulfill.I faced some obstacles I passed trough and I woud like to share my solutions with people like me who are learning on their own.The first error I recieved was connected with setting property.It turns out that in an Visual Basic editor ->Tools->References->Microsoft DAO 3,6 objec library have to be checked.The other obstacle was connected with empty fields in login form.When you remain fields empty and press login button access returns an run-time error 94/Invalid use of Null/.I passed trough this by changing type of variables from String to Variant.I don`t know if it`s properly to apply but it does work for my project.Thank you very much again!

[@MuhammadTayyabRana]

Thank you for your great tutorial video. But one thing I important thing I have found that if your database is encrypted with default MS Access database feature then this method won't work. To get this working you've have to decrypt the database by opening the database again with exclusive right. After that, I have found your "AllowbyPassKey" toggle setting working.

[@bourezahkarim3172]

Thanks Steve, very much appreciated. Keep the good work coming. 👌

[@ActiveInventories]

I encountered a small problem with the vba allow Bypass Key code. Easily overcome in my situation by changing Dim prop As Property to Dim prop As DAO.Property After this change all worked as explained. I guess my vba library references differed from those of the video demo. Excellent and helpful video

[@ProgrammingMadeEZ]

Thank you ActiveInventories! I appreciate your contribution as I'm sure others might run into the same problem.

[@naseemgillani3655]

do you have any video regarding pick and pack goods,

[@businessdevelopmentcrmhelp1413]

Hi Bishop, Nice video, I have heard people saying that the Bypass can still be reversed using some kinda automation code. Hence the best method I thought of securing my code was by also having a VBA Password on the VBA Editor along with all the other wonderful methods which you demonstrated in your video. Thank you.

[@TheUnicleo]

👍 Great, please let us know how we can get the Default Ribbon XML text, you mentioned!?🙏

[@DhrubaMishraQMS]

So what if somebody import all objects from blank database ?

[@rondaficklin5410]

this video is again EXACTLY what I needed. Thank you!!!!!!!!!!!

[@jassam8287]

How can I turn off/hide the Quick Access Toolbar at the top left of the window? The options menu could be accessed using the QAT

[@SohaibHasan]

You're the best.

[@samuelseepersad1015]

There is another way users can simply access the tables and what not. In the quick access toolbar if they select 'More commands 'it will directly take them to 'Access Options'. How can i hide the quick access toolbar?

[@TheRagreis]

Man, you're the BEST!!! Thanks

[@APerryNation]

First off, as I have seen many people say in the comments that I have read so far, your tutorial videos are extremely useful and even more professional. Now to my inquiry; I have seen some code on some of of the videos that isn't explained that I think would be useful for me though I havent been able to find a video where you specifically talk about it. The code i am referring to is the Allow Bypass Key code. Is there a specific video that you could refer me to? Please and thanks in advance. Keep up the awesomeness!!!!!

[@ProgrammingMadeEZ]

Hmmm... I thought that's what I covered. From around 10:30 in the video I'm getting you ready to use the bypass key property, and around 12:55 I actually start to code it.

[@APerryNation]

Wow. I cant believe i missed that. Ok Disregard my oversight. Thank you

[@hassanrozh6579]

Long live Steve, really you're great, best wishes, regards

[@stevenneuberger4323]

I think it should be added that to truly locked the frontend you need to distribute the application as an .accde. If the user has access to full Access it's not difficult to create an Access application that will open this database and set the properties to whatever they choose.

[@ProgrammingMadeEZ]

You are correct. I mention this in later videos, but it would have been appropriate to bring it up here.

[@shahramahmadzadeh5285]

hi steve how about importing data from Access, they can access passwords and codes and easily enter all parts of the database.pls guide us if it passible

[@jassam8287]

What's the XML for the newest version?

[@MaraingMuong168]

Dear Sir, I use your code On Microsoft Access 365 it not working it is still seen Option please help with the code for Access 365. i'm waiting your new video

[@yadali4833]

hiding the options code does not work for access 2019, is there a solution to this?

[@danieltesfay6690]

Thank you! Very helpful.

[@jamesrequilme]

Hi Steve, unfortunately it does not work in Microsoft 365. Does it work in Access 2016? Do you have the updated version?

[@jeremiahochepo6175]

IF only i saw this video earlier. Thanks you for been generous like this

[@mohammedal-sabbagh8463]

Excellent... I really appreciate you...

[@ISOnepal]

It is worthless if the user do not enable the security warning. Any Solution Plz ?

[@AkirosGuy]

Also, i found a security issue. The way the code is built, it allows access to almost everything: Since in the login form, the code was to first open the main menu and THEN close the login form, the control (focus) silently gets transfered to the navigation panel, so by tab & enter we can open whatever we want. Try it: Open the database, and after you click the login button, before you do anything/click anywhere, just press tab a couple of times and then press enter. I think that you understand that with appropriate number of tab presses, someone can open everything that's on the navigation panel. Solution: Invert the lines in the login form. First docmd.close the login form and then docmd.open the main menu. This way the main menu (or whatever form is opened) will have the focus, and the tab will navigate through the form's items instead of the navigation panel. Note: This may affect other forms as well, so make sure you check this kind of stuff when switching forms.

[@ProgrammingMadeEZ]

This will only work if you make the call to a module outside of the login form. Otherwise when you do a close of the form, that ends all VBA execution of the code on that form. I was not able to recreate the security vulnerability you described. I believe the main difference is that I do not have the navigation pane turned on in the database and therefor it cannot be tabbed to.

[@AkirosGuy]

If "turned on" is different than "displayed", then you are probably right. Otherwise i don't know whyit didn't work for you. I followed your instructions from the video of the (current) login form, and then this video, and i noticed the above vulnerability. However, i haven't gone through your entire tutorial due to lack of time, so maybe you have make somewhere a change that prevents the vulnerability I found. Maybe I'll make a video to show the code and demonstrate it, so you can see exactly what happens.

[@saururin5811]

hi there steve..i'd been following ur tutorial..its working great. but after a while, when i wanted to change and ade new query..its give me some error..i havent chose an object in new query but its show all the object on my table, yet i havent chosed them. is there anyway for me to reset all the setting in mydatabase option? please reply..thanks

[@franksmit4914]

Hello, its been a while i see, still hoping for feedback. After inserting the login screen, everything works great, but when i try to change the login screen in any way then access stop working and needs to be restarted, but the databse has been currupted and can not been used again, why is this ?

[@no_short_circuit]

Great video again. Why can't you convert the db to accde format to distribute to client. Thank you

[@dbaker369]

I am using Access 365 (2020) and when I create the USysRibbons table I cannot see it in the Navigation pane. If I try to recreate it Access says a table with that name already exists. Also I don't get the ability to choose the "Default" Ribbon as you instruct, possibly because of the first issue. What am I missing, doing incorrectly.

[@pazfejeamarcellenediocales7731]

hi how can i undo this because my log in form doesn't pop up ;(

[@rubensimoes341]

Tried the code, and it works as intended. Just found two issues that I don't know how to get around! The first one: Logging without password, just by typing username and pressing login, grants me access. And the other thing, I believe it´s related to the code for the bypass fucntion, any other user that doesn't match the level 4 user type, can´t login at all. The Login button just won't do anything. Can anyone shed some light on this matter? Any solutions? Thank you all in advance.

[@kennethcrawford5065]

Do you have the no ribbon display code in a better readable display? Does this still work in Access 2016?

[@gcbonfiglio]

Thank you so much for your help!

[@dwaynecoulson3750]

Thanks so much for your tutilidge... Can you secure the back end in the same manner as the front end?

[@hamidshah09]

Awesome!

[@whilburn2]

Thats a great video.. however, when you work for a .gov entity and the network guys require you to authenticate and enable macros on startup, the Login screen prevents you from enabling macros... this prevents code from running on startup.

[@prasadintergulf]

Sir Thank you very much for your great video. great work!!!!!!!!!!!

[@ProgrammingMadeEZ]

Siva Prasad Thank you for the kind praise.

[@gevara2500]

it's not working with MS Access 2016 Pro, any solution?

[@claudettejohn2479]

Hi Mr Steve I am new to programming and need your assistance. Ok, so I followed your steps and everything worked out fine. Great tutorials, Thank you very much. But my problem is I am unable to open the print Screen to make changes... such as Changing from Portrait to landscape etc. How can I accomplish this.

[@wcambris]

Very neat and nice solution

[@ProgrammingMadeEZ]

+wcambris Thank you!

[@jockfaire]

What if i want the end user to interact with only the forms i create and not have them see MS Access itself in the background?

[@markadams5462]

I have followed this and am an absolute novice, but when i save the USysRibbons table, it does not appear in my tables list. What is wrong? Reply 1 Programming It is a hidden/system table. You have to change the Navigation Pane settings to show hidden and system tables. Me, too. Thanks for asking the question, WoodyAus. You can't call us dumb Aussies. We're smart enough to ask the right questions

[@garycurtis]

Great video thank you. Question, do you need to even do this if you are using Ms Access runtime?

[@supportrealm]

if the user has full version of MS Access, they can gain full access to the data (including passwords) via the import option within a new database ... can you do another video on how to stop this .. please

[@dankirchner4460]

Hello. Will the language you give in the data table to hide away privacy settings also worked with access 2016?

[@GAMPASSHREYAS]

Hello Steve, all of this works perfectly fine when the macros are turned on. But when a new user downloads the front end to their desktop, the modal view of Login form doesn't allow them to enable macros. Is there a way around it? Thank you so much for all the videos again. They are a great tool for learning.

[@wizardmc13]

For the bypass key section, why would you go through the trouble of creating a prop object, setting it to something, and then appending it to the Currentdb.Properties? Why not replace that whole thing with CurrentDb.Properties("AllowBypassKey") = False?

[@ProgrammingMadeEZ]

Nubblet Because the property doesn't exist until you create it.

[@RealityRascal]

Excellent videos, The Ribbon XML code does not seem to work with Access 2016, Do you have a fix for this?

[@kathleensteed489]

Hi Steve. Once the front end is secure, how do the users run the reports I made for them? The navigation bar is gone, so they can't get to them.

[@ijo680]

I just found your video on securing your front end … great work... Can you help.. I need to use checkboxes on a form to insert value into field when checked and clear value when unchecked . I'm using this VBA in the after_update of the chkbox If Chkbx1 = -1 Then Me.field1 = "text1" Else Me.field1 = Null End If two problems.. the box remains checked after leaving the record and if I return to that record and uncheck the box it does not clear the field .. Any help will be appreciated. ..Thank you

[@kcp1594]

Hey, so I'm trying to do this for my company, but my boss wants the security to be by the user instead of by class. I have an employee table like yours and an access table. Th access table has each individual Id number and each column is a checkbox with the individual tables as the column names. I can't seem to get it to work. Please help.

[@simacenter8355]

Hi, sir Could you make a tutorial about secure a ms access database that prevent to be used in another computer, or make a license to prevent copy past the database, thanks for your kindness.

[@xg2845]

This is brilliant. Thank you 😊

[@falkson10]

So, what should I do to make my Access file into a desktop program for windows so my colleagues can use it as a computer program? Thanks a lot in advance and thanks for a great video! Regards Falkson

[@altonbrisbanejr8254]

Hello Steve, seems that the ribbon xml code to lock the Privacy Options does not work for 2016. Any idea on how to get this working again? Thanks.

[@louisbaileyjr3860]

Hello Steve, I created the code as explain but, when I reopen the database options was still there. I would like to get this to work(:>).. Very Good videos !!!.

[@kelshab]

Hi steve, I am trying to create a ledger in MS Access with a running total but cant seem to build from the expression builder the correct sum. The difficulty is that i want to add the previous balance in a row add another debit amount to it and minus a credit to give me a new balance. Could you or anyone reading this help me out, please. Thanks

[@chrisreeves7816]

Hi Steve, Your videos have been a godsave as I am an ADBA and have been tasked creating a database. I am having a problem though. The error handling for appending the property doesn't seem to be working. I am getting the Run time error 3367 "cannot append. An object with that name already exist in the collection." It was working fine, but after I added the activity logging code I started getting the error. If I rem out the append statement when debugging then everything else works fine.

[@lbarbaric11]

Hi Steve, I searched the comments before posting. What's the advantage of bypassing and re-loading. I thought you were going to have me set one ribbon or display based for user 1 and a different display for user 2. As in, different items would load automatically after login depending on employeetype_id. I'm guessing there's some smart reason you go this open and close route...??? curious so that if I go searching another way I know which is "better" / "more secure". thanks so so so much!

[@osamaabushammala5344]

thank you man, you are the best

[@carolynbaker975]

Hi Steve, I've tried this with Access 2016(365) and it doesn't appear to work. The microsoft site it references to appears to have been removed. Do you have another video or information on how to do this with the current version of Access?

[@martin6498]

I can't get it to work in Access 2010. What am I doing wrong? Here is my code... I can't find the mistake!

[@user-el4bx4ni1n]

I really love your way, but I have error. It said Property not found."AllowBypassKey"

[@user-ho6xr3wf7o]

Hi Mr steve, I did Everything in your video and I published it to the users also. But I just found out an issue that on my computer,everything looks fine. But after I copied the application to a user's laptop, since the security issue, that laptop doesn't allow me to login, instead it shows a close button on the right top of the login form which was forbidden in the design mode on my computer already. So when I click it, the login form is closed and I can still right click on Home or File tab to get access to "Customize the Ribbon" which goes directly to Access Options. So in this case, I cannot secure my database from users end. How can I fix it? Thank you

[@transformationofthebride2295]

How about getting rid of everything on the screen and only show the forms

[@Its_Noobody]

Hi. Its nice code i got it working. For me need it to add bit extra on password check ("Or IsNull") other wize it was loking with empty Password Field. Not sure if it wasnt the issue for you. Thanks for shearing it ;)

[@chriss377]

Is there a way to set the CustomUI by user from the login screen? I need to enable the paste function for a manager user level.

[@yuvals3027]

Hi Steve can I disable shortcut menue for certain users and enable it for others? @Programming , +Programming

[@blessesplease]

Notification popup -"Can't overwrite table or query" while importing data as form is base on query! Please help me

[@timothymedugu4799]

hello.... I like your videos. I can't get the bypass key code to work on my login page. What could I be doing wrong?

[@louisbaileyjr3860]

Steve, I have written many programs using access and I like this video and need to get this to work. i just can't get this to work. I even tired the script from one of the subscribers below and still no luck. What might I have done wrong?

[@woodyaus9426]

G'day, I have followed this and am an absolute novice, but when i save the USysRibbons table, it does not appear in my tables list. What is wrong? Thanks

[@ProgrammingMadeEZ]

WoodyAus It is a hidden/system table. You have to change the Navigation Pane settings to show hidden and system tables.

[@woodyaus9426]

Programming Many Thanks. This has done exactly what i require. Well done good work

[@kongvue5160]

Hi Steve. I have been using your tutorials for my database and it has been a really good reference. I do have a problem in this section. I was able to get everything to work but I do see that you can right click the ribbon and go into customize mode and change the options from there. I did uncheck the "Allow Default Shortcut Menus" which should disable right click but I'm not sure if it will disable the right click I'm talking about. Are there any ways around this? Thanks.

[@angeldsouza5712]

hi Steve. your video are very helpful. also I had a query on search button where after I search for a particular product I want the data to be populated in the textbox and not listbox. is it possible?

[@salmanwate7018]

hey is there any relation between employeeid and employeetypes?

[@brentconner8239]

Chris I have really enjoyed your videos I have however tried the code for hiding the options bar but was unable to get it to work, I am currently using Access 2016 could this be the issue of why it does not want to work for me. Thanks in advance for any assistance

[@ning-weili1602]

Hello Steve, Is there a ribbon can get rid of "tell me what you want to do?" and "quick access " of version 2016 and later. These two functions cause design leaking. Thanks a lot.