Hello, I found a code to hide the database ribbonDoCmd.ShowToolbar "Ribbon", acToolBarNo

Now if the Ribbon is not viewable, how then do I go back to the codes to "yes" see the ribbon if I cannot go to "Create" > "Macros & Code" > "Visual Basic" ?Must be another way to get to the codes without using the Ribbon?Thank you

You most certainly can, and should hide all of the ms-access interface. The options to complete hide and keep people out of the ms-access interface can easily be done using the file->options.

Using those options allows you to complete hide the ms-access interface (tool bars, database window etc).

And then using that code to hide the ribbon will complete this process.

Also, using these options means you do not have to bother setting up security etc. to keep people out of design mode etc.

Of course, during development, you will hold down the shift key so yourstartup settings don't run. You then develop for awhile, and then to test in"user" mode, you exit, and then re-enter the application without the shiftkey bypassed.

You will likely do this dance all day long as you run/test asuser mode, and then flip back in to developer mode (shift key used..so youdon't get the main custom menu). So, you cant develop, or really modifythings when you run your application with the startup settings...so you mustshift-by-pass them when you want to work.

And, in fact, I use alt-f4 to exit the application...the mdb/accDB file should still be highlighted in the windows explorer. So then you hit enter key (and, hold down shift key if you need be). This key stroke sequence and exiting and re-entering the application will occur CONSTANTLY all day long when you are developing.

When you finally have things just right? You will then compile your application into a accDE you plan to distribute to each workstation.

I mean even things like autokeys can run on startup and re-map f1 or f12 for a barcode scanner etc. So you really cannot in ANY practical way work on a application with the "ton" of startup options you set for "end users". So you have to shift by-pass into your application for development needs. There really no way to develop or work on a application with that "ton" of startup options etc. active. So shift key by-pass will "ignore" all of the startup setting you kindly set in Access - and shift by-pass will also not run your startup code that rather likely runs additional code to hide the Access UI which is required for development.

Between your startup code, and the file->option settings there is about 100 settings that you not want when attempting to develop your application as opposed to running in "user" mode. So you shift in an out of your application all day long to "test" as "user" and "work" as developer.

ok, so if I start up holding the SHIFT key, the toolbar will be available and Alt + F11 to open codes, then I need to open the Switchboard Form (where the DoCmd.ShowToolbar code is located) to be able to see this code and change it back to "Yes"

Does this seem doable? or is there an easier way? Have not created a module

I am guessing that the startup code or one line of VBA to hide the ribbon was placed in your main startup forms code module (the on-load event).

I suppose you could modify the code to "no". However, your switch board likely just launches other forms and reports. So in “general” VERY little development and changes will occur to your switchboard.

So you likely can just launch the application (shift by-pass). You are then free to open in design mode the particular part of your application that you need to work on. Test that part. And then to see the “whole” application run as it will in user mode, then you can exit + re-enter without shift by-pass.

About the only case in which I would bother to change that hide ribbon code would be if you need to work on and modify the switchboard code. So sure, in that case you could shift in and then simply modify (or even comment out) the line of code to hide the ribbon.

However since as noted you not likely to be doing a lot of development work on that switchboard form, so once you shift in, you are free to open, view, design the additional parts and forms as you require. At that point you could launch the switchboard to “test” things – but it would hide your ribbon. So you have to exit + re-enter after testing as such.

In fact to save on the exit + re-enter process, I place the compact + repair button in the QAT. So it only one mouse click to re-launch the application (and I either hold down, or not the shift key). So this trick allows me to flip between developer and user mode with one simple mouse click.

Thank you all for you time and expert help,But you have missunderstood my objective.......I already put the code to "no" and now I just want to know how to get back to the codes to undo itwhen now there is no toolbar to access the codes.I just want to undo , put to "yes", but I can't get to the codes by way of the toolbar, I do not need to know how to make the toolbar unavailable ( it already is!)But thank you, after I get this undone then I will try your suggestions instead.

Reading you reply above I'm not sure you can get into your code from the shift key.

Click on your main form.

Press the RMB and select "Design View" for the form.

Press the RMB again and select "Form Proberties"

Click on the "Events" Tab of the properties.

Go down to the On "Open" event and click on the "..." on the far right, this will ask if you choose a build method. You can now select build a macro or a VBA code module and create a button on the form, where you can place you code.

CODE

DoCmd.ShowToolbar "Ribbon", acToolbarYes

Then when you click on the button, it should bring back the ribbon each time.