How Do You Hide Top Toolbars When Open Database - Access 2007???
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...
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,
This used to work, but now I can't remember/ don't knkow how it was done before.
I have some custom toolbars and menu bars, on some forms (like the main menu) i don't want any bars to appear at all, all I used to have to do is set them to tbrBlank and mbrBlank, but I went and played around the names (It used to be something wacky like "std_msitbBlank"), but now a get a blank toolbar up, that you can right click on and turn all the toolbars on. I don't want it to show up at all. I can disable it through code, but every time I restart access, they come back (I dont want to have to paste that in every one of forms, thats silly and unneccessary! right?!?)
How I can make it possible to open the recordset of a database that is being used by a different user (not a front-end - back-end database). The database that needs to be read creates a .ldb file when it is open.. when I try to make a connection and open a recordset I get a 3050 (can't lock file) error. The database is a file on a network and has not been properly setup as a front and back-end database Thanks in advance,
I have an Access 2007 front end (originally A2003 .mdb file) linked to an Access 2007 back end. I want some users to open the database and have full access. I want other users to open the database and have read-only privileges. The database uses the system.mdw file. For the read-only users I was hoping to have a desktop shortcut with a read-only switch, but all my efforts in this regard have failed. How do you open an Access 2007 database with linked tables in read only mode?
I am rather new to databasing. I just need to know how to open fully a database that only shows a form. I know there is background information that the form relies on and I need to change that. I am sure once I can open the database fully I can change what I need. But, then I need to reclose the database for the people who use the form to reuse as normal and not be able to change the background data suchs as the tables, queries, etc.
I want a custom toolbar for my application and I'm having difficulty accepting that there simply is no way to accomplish this once simple feat. Am I going to have to create a form with buttons and put it at the top of the window or is there actually a way to create a custom toolbar in 2007?
Ok, this is a weird one. I have a large MS Access application that has been around since Access 1.0. Of course, its gone through many, many, many revisions since its beginning. Now, I open the mdb in Access 2007 and behind many of the reports, are calls in the On Current and On Unload events for macros that have not resided in our database for about 10 years. We replaced these in Access 2.0 or 97 I think and through versions 2003, they are not there and everything runs smoothly. But low and behold if I open the database in Access 2007, there they are! And, they are causing errors because of course, the macro no longer exists.
For example, we used to have a macro named xyz and we called it from the OnCurrent event. In Access 97 we removed it by simplying highlighting and pressing delete from the property sheet.
So, I am wondering how the heck it has dredged up calls to this ancient macro after all these years?? Where have they been hiding??
I have also tried converting the database to accdb format, same result, it pulls in the macro calls. The database has been decompiled and compacted throughout its life including from within Access 2007.
I would LOVE to find out the answer to this one...
I have a number of production databases that use VBA to disable the user interface (menus, toolbars etc) when the database starts up. VBA also disables the shift-bypass key so they can't get in that way either. When I move these to Access 2007, what else must I disable via VBA code or whatever so that the user can't get to the database container and defeat my code to keep them strictly in the user interface? TIA NorthNone
I created a macro called "autoexec" with the action set to "RunCommand" and the corresponding command called "WindowHide". My understanding is that when the database opened, the Database window would be hidden. It isn't. Can someone please let me know what I need to do to hide the Database window when my database opens?
The top of my database window is hidden under the toolbars and I can't find a way to grab it and drag it down so that I can use it! I have tried everything i can think of with no luck can anybody help?
Hi, I have been opening password protected access 2003 databases with ASP / ADO for years now. However now we have updated to office 2007 everything gone bottoms up.
I have an access 2007 database (newly made, not converted from 2003), and a fresh asp page. I've gotten the new connection string information for Access 2007 from the internet yet the page cannot open the database.
When I try to open the page the error i get is - "Not a valid password" - 80040e4d. I'm 100% sure the password is correct, the driver is right (the server has office 2007 installed, and the new access driver from the M$ website). Every page i've seen on the internet says that the code I'm using is correct, yet asp still can't open it.
If i remove the password from the database it opens fine, so it's not a corrupt database, or bad path in the code.
If you can shed any light on my problem I would be eternally grateful - been working on it for hours now!
I know this is probably small and we are working around it but I wanted to know why wouldn't an access file open when someone else has the file open. We reinstalled windows Xp on a new hard drive and since then we have to open access first then find the file to open it. usually we just go to the network then the file and open it.
Since I have multiple Access databases, I would like to have a form with a button opening each of those, in order to avoid the logon each time I need to open a database (currently I have a shortcut for each Access database). I don't need to open more than one database at once.
I couldn't find any solution, maybe someone can help me?
Got multiusers accessing my Access db. Typical size of one of the db's is 20MB With Access 2003 we could have 50 users accessing all day and it would never get to more than 22-23MB With Access 2007 it is now bloating to 200MB within a few hours! Nothing's changed on the db - it's still Access 2003 format being opened in Access 2007. There's images in there but they are linked images. I can enable auto compact and repair on exit but the users will stay in the db all day, so only at the very end of the day will it get compacted. But that's not the issue - the question is WHY is this happening with Access 2007.
I'm a novice Access user and been given an old access database (pre-2007, not sure which version) which I've opened in my brand new Access-2007 program, with "Access 2007 - The Missing Manual" by my side.
The trouble is that the old database looks nothing like the pretty pictures in the text book:
* Under the office button there are only 3 options: Close Database, Exit Access and Recent Documents. * The ribbon has only one tab: Home, most of which is greyed out. * The thing is stuck in Form View and there is no menu to switch view in the Home ribbon tab.
I can't, for example, see any way to get the Data Sheet view of the database.
Hello. I haven't seen this before with Access; I've searched the forum and haven't found anything yet...
I have an Access database that was being used by about 9 different people. Everything was going along okay, but one day it became read-only for no reason. Once everyone got out of the DB it said it needed repairing. So with only one person in I ran the repair, but the horror-inducing message "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." appears and when I click "OK" on the message nothing happens whatsoever.
Luckily backups existed, but some data was lost. Is there anyway to run a repair on the database that won't open? Or is it a lost cause?