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
This will unhide all menu bars and tool bars
Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = True
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
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 have my File, Edit, View toolbar as the top toolbar, and that stays where I leave it.
However, my Form Design and Formatting toolbars will constantly move.
I like to have my Menu bar on top, then FormDesign on row 2 and after it my Formatting toolbar.
However, when I change between form view and design mode, or close and open Access my Formatting toolbar will often drop to row 3.
Is there anyway to lock these in place, and does anyone know why this happens?
I just want to compact and repair the same database that I open using vba. Thanks.
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?!?)
Running 2007. In 2003, to make a shortcut for an object, all I had to do is right click and place the short cut where i wanted.
I can't seem to find anyway to do it in 2007
Anybody have any clues?
Anybody out there has the codes to hide and unhide the Access 2007 tool bars, ribbons, etc.
I hope I am posting in the right place.
I have recently installed msoffice 07.
My old data bases that have code to hide the access window don't seem to work properly.
The forms load in the container.
Does anyone know what I have to do to hide the access window?
I'm wondering if someone can help me.
I am building an Access Data Base, part of the data base's function requires it to hide a form once information has been entered. Can this be done via a Macro?
I can set up a marco to open and hide a form in one motion but need to do it in two separate 'actions' each one controlled by a button linked to the macro.
Can anyone help me design such a macro? I'm a relatively new user of Access but I have picked up most of the basic/intermediate programming techniques.
I understand that new features would not be available but is there any way I
could open an accdb database in Access 2003 or back-convert it so I can open it?
Does anyone know why this happens?
Everytime i open a database in MS Access 2007, a copy of that db is created in the same folder. When i close the databse, the copy doesnt get deleted.
How can i fix this?
Function HideDatabaseWindow(bHide As Boolean) As Boolean
' Comments : Hides or shows the database window
' Parameters: bHide - true to hide the database window, false to un-hide it
' Returns : True if successful, False otherwise
Const c_intForm = 0
Const c_intWindow = 4
Const c_intHide = 3
Const c_intUnHide = 4
On Error GoTo err_HideDatabaseWindow
' Move focus to the window
DoCmd.SelectObject acTable, "", True
' Use the window menu to hide or show the database window
If bHide Then
DoCmd.DoMenuItem c_intForm, c_intWindow, c_intHide, , acMenuVer20
DoCmd.DoMenuItem c_intForm, c_intWindow, c_intUnHide, , acMenuVer20
HideDatabaseWindow = True
HideDatabaseWindow = False
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?
When I open my database file (Store.accdb), is it possible to open a form directly after opening the database (Form name = "Mainform")????
For example I have the accdb file stored in a folder, when i double click on that, I want the form "Mainform" to open as soon as the MS Office Access 07 Splash Screen dissappears...
How to do this?
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.
Is there a way to edit custom made toolbars from an acc2003 db in acc2007 db?
How can I do my own custom toolbar in Access 2007?
Can you explain ? Thank you
I'm in denial.
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?
I've created a database in MS Access and placed it in a shared folder. when one person has opened it, any other can't open it. why is it so? how can this issue be resolved?
Getting the following error when I attempt to open a form which includes a sob form:
error: This expression is typed incorrectly, or it is too complex to be evaluated
I created this form in Access 2007 and it automatically created a subform which I need. When I delete the subform...I no longer get the message. I do need the subform.
I did not create this DB, I'm only updating it. It's currently being used by the end user in Access 2003. However it could have easily been created in Access 2000 or 97.
Could someone please lend a hand...I'm stuck.
Thanks for your time in advance,
The example database attached to this post will show you how to disable or enable any toolbar or the database window.
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?
So we just switched over to 2002 (from 2000) --
Much to my dismay some of the functionality seems to have changed so that things have to be fixed (which doesn't seem right)
My current issue is hiding the Database Window
I have it set to do this in startup and it doesn't do it. It opens the form it is supposed and the database window isn't there but it's in the taskbar and when clicked it shows up again.
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?
Thanks in advance.
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.
connection string being used:
sConnString="Provider=Microsoft.ace.OLEDB.12.0;Data Source=" & strPath & ";Jet OLEDB:Database PASSWORD= password"
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.
All help is greatly appreciated
Hi, I hope I chose the right forum...
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.
Anybody know why this might happen?
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?
Thank you! :D