The below code will hide ALL menu bars and ALL tool bars. Ensure that you have a way to unhide the menu bars and tool bars before you hide them! You should place the hide all tool bars routine in your opening splash screen form for it only needs to be run once when the db is first opened.
This will hide all menu bars and tool bars
Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i
This will unhide all menu bars and tool bars
Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = True
Next i
An added bonus is the right-click mouse button option is disabled if the menu bars are disabled with the above code.
Use the 'ShowToolbar' command if you need to display a tool bar or menu bar...
DoCmd.ShowToolbar "YourToolBarNameHere", acToolbarYes
This will hide a tool bar or menu bar when needed...
DoCmd.ShowToolbar "YourToolBarNameHere", acToolbarNo
This will hide the menu bar...
DoCmd.ShowToolbar "Menu Bar", acToolbarNo
You can also hide/unhide the database window with code...
Hide the database window
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
Unhide the database window
DoCmd.SelectObject acTable, , True
Remove the "Type a question for help" on the default menu bar in Access 2002 or 2003
Application.CommandBars.DisableAskAQuestionDropdow n = True
This command will prevent the db from opening up a separate window tab on the Taskbar
Application.SetOption "ShowWindowsinTaskbar", False
The above commands have been successfully tested with Access 97 and Access 2003.
Read this if you do not understand where to post your questions! >>> Please Read Before Posting (http://www.access-programmers.co.uk/forums/showthread.php?t=63576)
Please do not directly PM me with any questions related to my Hide all Access Toolbars and Menubars code. Please do not post any questions related to my Hide all Access Toolbars and Menubars code in the Code Repository forum. If you have a question related to the Hide all Access Toolbars and Menubars code... Please post your questions in the appropriate forum and include a link to this thread if you have a question or problem related to my Hide all Access Toolbars and Menubars code. I will be glad to help if I see your post and if I am available.
Key words: toolbars, tool bars, menubar, menu bars, hide, unhide, enable, disable, right click, right-click, database window, hide database window,
I want to hide the top toolbars when my users open my database in Access 2007! i have an autoexec macro to maximise the window which gets rid of the navigation bar on the side but cant work out how to hide the top bar? do i need to write code? if so what code and where would i input it.. any help would be much appreciated...
i have some forms, which i am creating customised menubar for them. On each menubar, i am planning to have options such as Add New Records, Delete, Exit Form etc. Now if i will create some general functions in a Module for each of the above, for example :
Function Add_Record() DoCmd.GoToRecord , , acNewRec End Function
and then place the function name on the onAction of a command button in the Menubar, will this be ok i.e. will it affect only the current form which has the focus (in case there are other forms opened will they be affected too?)
Moreover is it possible to set a background colour to a customised menubar, because i've seen it on a database, but i do not know how to do it.
I started access today and all my icons and menus are gone from the interface. I am forced to right click on all my queries and tables to perform any action. All I have at the top of my window is the usual "Microsoft Access" caption. Absolutely nothing else. Other than that, Access is fully functional provided I can use the right click commands. Has anyone encountered this? Help!
Hi, I have been using "fSetAccessWindow (SW_HIDDEN)" in the open event of my main switchboard to hide the grey Access screen from being visible behind forms, reports, etc in this db. But when I started using a .vbs script file to launch the db, the Access window stopped being hidden. (The reason I use the script for launching is that it temporarily sets the db's security level to 1 which stops the macro security warning from coming up.) Apparently MS knows about this happening and released a technique to rectify the situation, but I don't understand their instructions. It looks like they expect one to have more understanding than I have. Could someone help me get this impliemented? Here is the article: http://support.microsoft.com/kb/167659/en-us Thanks!
I was not sure were to post this question so i thought "General" would be a start.
I have a number of toolbars i would like to copy to a new database i am not sure if this can be done, but any help will be useful to me as i am stuck on this issue.
On my database, for startup, I had the toolbars taken away from the user. Is there a quick shortcut to pull them back up? I noticed that the 'Tools' option is gone.
i am wanting to find some way of turning off the menus and toolbars in a startup macro and is it possible to turn off the warning messages that appear when appending or deleting rows in a table. many thanks
I have this filename.mdb file which was given to me for revision, so I opened it with MS access but once I opened it, the toolbars are disabled so I can't switch to form view, design view etc. How can I resolve this? I remember when I once did VBA Access that you can do this 'disable' thing. Only that I forgot it how now. So if anyone could please help me in this? I need to 'have those toolbars back' so I can start editing the file. Please do help me.
Hello Guys, I need to know how to enable toolbars and edit a text in a report... the database is locked by previous employee and I can't get to design view so I can change a text... There isn't any tool bar up there.. just EXIT button..
My company recently completed a fairly large website for a local travel-agency. The website runs on a MsSQL and .net platform, but (It is a big but(t) by the way) a pricing calculation database is a old MS Access 2000 application.
The users of this DB have MSA2000 installed on their computers, and the database is made with one application DB and connected tables.
My problem is that I have to make some small changes to this DB, but when I start it up, the toolbars is hidden and right-clicking is disabled. (F11 works).
A previous employee of the company I work for setup an access database, which works well. But he populated some drop down lists and didn't give us the option to add additional items to those lists.
He has also done something that when the database is opened the usual access menus and toolbars disappear.
I'm pretty sure that the lists are collected from a table in that database, but I can't view the tables either :(
I have managed to get the start form into design view and also to open the code builder, but I can't see anything in there.
If anyone can offer any help or suggestions on how to access the tables when it's been locked out, I'd be grateful.
Please give all the info you can. I have my database and forms set up. what I want to do is just see my forms and not see access in the background. Please specify where I enter code if it's provided. thanks for all your help, Derek
The problem is when the users views a report there is no toolbar for them to print the report. The user can click on file print but they would prefer to see the icons on the toolbar.
I have set the startup to not show the toolbars I have also tried just to show each one individually with no joy.
How do I show the print preview toolbar. I do not want the user to be able to design the report I only want to allow them acccess to print the report or maybe export to word.
Hi all, I have been given a database from a small business who just want some menial report editing. Their problem is the supplier of this simple access database has disappeared and in over a year of reporting the problem has not resolved it.
The database is locked interface-wise, i.er. if you load you cannot access tables, queries, reports etc. I was wanting to know how you do this. If the database is passworded I have a revealer, but actually getting to the edit area seems to be the problem at the moment.
Hello, I've read most of the General category on Toolbars and Startup Menus, but still can't figure this out. I have no VIEW or TOOLS on my toolbar, so I can't get to the startup menu, toolbars, or anything else. When I go to Customize, one option is Built-in Menus. When I try to drag the VIEW or the TOOLS to the menu bar, it won't happen. I have tried the Shift trick, but it did not work either. Can someone help me?
There aren't too many threads on this subject folks. I am looking to understand this a bit more. From what I know, complete security of a database can only be accomplished by making an MDE file. But, the downside there is that MDE's cannot be edited by anyone, so any backups or changes that need to made must be done with an MDB.So, what I want to know is, if I want complete security of a database (as in, no changes allowed to be made, except by me), my only option is to make an MDE file and then transfer all the data back and forth between that and an MDB file whenever I need to make any design changes.Am I right?Thanks!
How do I regain the full menu bar in my dbase. I had unclicked "Allow Full Menus" and "Allow Default Shortcut Menus" and now I need to regain those features.
I am using Access 2010 and trying to hide the background access window, so that only my forms are visible to the end users.
After researching, I found these VBA codes, but I always get an error. I have changed all my forms & reports to Pop-up and Modal. This is the code that I use on OnLoad of the Main (first form):
When I open my the database- the mian window is still there and I get an error
"The espression On Load you entered as the even property setting produced the following error: Only comments may appear after End Sub, End Function or End Property.
*The expression may not result in the name of a macro, the name of a user-defined function, or [Even Procedure]. *There may have been an error evaluating the function, event or macro.
I've been using Dev Avish's excellent code shown within the sample database section to hide access windows. I've taken his call fsetAccessWindow function and set it to 1 or normal in two separate databases. Both databases seem to work slightly differently. The idea is that opening the database produces one Visible instance of access on the taskbar which is the purple standard graphic (Access 2000 / Windows 2000). With the first database I have set up reports through the active x control as required when using dev's code and even when I hit the report button the user is only aware of one visible instance of access as the purple colour graphic.
I am trying to implement the same code in a second database and have copied the code from the previous database into this database. It works great for the forms however there is a slight glitch when report forms are accessed. Rather than remaining with the purple access part on the task bar the task bar section is split into two between the form and the report. In the previous database users would not notice that the report had been opened at all. (although technically it was still running in the backrground)
I have checked most of the properties between the two database forms and they would appear to be the same..
Has anyone got any ideas why the taskbar is behaving differently between these two databases there must be some difference between my set up but as yet cannot find it??
I recall using a database (created by someone else that I don't have contact with) whereby, when you open it, the user-end form opens up on your Windows desktop, but the usual MS Access window is minised/hidden.
I just upgraded to Access 2010. I was able to solve all migrational issues, but my custom ribbon is showing two File tabs, one that I created and the default access file tab. How to get rid of the default File tab or at least disable it?
