No Toolbars, Menus Or Tables
Nov 22, 2007
Hi All,
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.
Kind regards,
Rich
View Replies
ADVERTISEMENT
Mar 16, 2006
I did something in the start up options with this database.
Now when I open it I can't get Access to function as normal.
There is no right click, no tool barr or menu.
Any ideas?
View 1 Replies
View Related
Nov 14, 2006
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!
-Nino
View 14 Replies
View Related
Dec 31, 2005
Hello People,
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.
Alastair
View 2 Replies
View Related
Aug 30, 2005
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.
Thanks.
View 1 Replies
View Related
Jan 13, 2006
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
View 3 Replies
View Related
Feb 26, 2007
hello,
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.
Thanks in advance
View 2 Replies
View Related
Jan 28, 2008
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..
Thank you in advance.
View 6 Replies
View Related
Dec 26, 2006
I would like to hide the toolbars on the form.
Could you please explain to me to do it?
Thanks
View 1 Replies
View Related
Mar 8, 2005
i must be overlooking something obvious, but....
how in the world do you put in the little gray separators in a custom toolbar? you know, to keep similar buttons in logical 'groups' on the toolbar...
View 1 Replies
View Related
Dec 5, 2006
Hi all! Hope you can help me yet again!
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).
Is there a workaround this problem?
View 1 Replies
View Related
Nov 22, 2005
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,
View 5 Replies
View Related
Dec 21, 2004
Hi,
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.
Any help I would be greatfull. Thanks PWF
View 2 Replies
View Related
Aug 29, 2007
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?
View 1 Replies
View Related
Feb 16, 2008
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!
View 2 Replies
View Related
Oct 28, 2004
Hello..
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.
Help!
Diana
View 4 Replies
View Related
Feb 29, 2008
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...
many thanks,
Gaz
View 12 Replies
View Related
Jan 18, 2006
I was curious,
How do you add a Menu to a form? Like is there a way to have a Main Menu bar and add the individual menus/menu items with custom events? As well can i cusomize the context menu for the form, or make a popupmenu that is executed upon clickin a command button?
There is a lot of help on how to attach menus to properties and such, but I can't find an item "Menubar" in the access interface.
Thanks
Jaeden "Sifo Dyas" al'Raec Ruiner
View 2 Replies
View Related
Apr 13, 2006
I have an application that hides all the normal Access menus, so that the user can only use the buttons that I have put on the screen forms. Now however, when I open up access, I cannot get to any of the Access menus. It shows the toolbar, but not the normal FILE/EDIT...TOOLS/HELP menu.
How do I toggle this back on? Everything I have been able to find so far tells me to go to the TOOLS menu ---- I cannot get to the TOOLS menu.
Thanks. BTW, I am not really as stupid as this post makes me sound.
Mike Redmond
View 6 Replies
View Related
Jun 26, 2005
I'm sure there must be a simple answer to this question but I have been unable to locate the answer.
I recently finished a database program under Access 97 and unchecked the boxes to allow menus. Now I need to fix a few mistakes and need to access my code or the menus to do this. Is there a way to get access to my code.
Any help would be appreciated.
Thanks
rtamd
View 2 Replies
View Related
Oct 25, 2007
Since the introduction of 2003 when you create a custom menu you always get the 'Type in a question for help' tag and the min max close buttons. Is there any way of removing them or disabling them?
:confused:
View 1 Replies
View Related
Jan 30, 2006
I have the following code in the on_load of all of my forms to disable all menus:Dim i As IntegerFor i = 1 To CommandBars.CountCommandBars(i).Enabled = FalseNext iThe problem is that when I open a report in preview mode I cannot close, print, etc.Two questions:1. Is the above approach the best way to disable all menus and toolbars?2. How do I add a custom toolbar (already created) to the report preview only. I've tried doing in in the properties and by me.toolbar = "custom toolbar." Neither approach works. I suspect that the code I've used to disable the menus is keeping me from adding custom menus where I want them?I should also mention that I have also turned off all of the menus, toolbars, etc. in the options/startup.Thanks for your help!
View 2 Replies
View Related
Nov 16, 2004
hello everybody
I've created 2 menus using macros and everything works perfectly.
The 2nd menu has 2 commands and I want the second command of the menu to be "activated" only if a specific form is open.Otherwise the command must be in the menu, but not enabled. I also want to put a line between these 2 commands. Is it possible? Thanks in advance
View 3 Replies
View Related
Nov 14, 2004
Hello everybody
Could someone please explain me how can I create a couple of menus that execute commands in my db? I would like to open certain forms or reports using menus. If it is possible pls give me an example, of 2 menus each having 2 commands. Thank you in advance
View 11 Replies
View Related
Feb 2, 2005
In Tools, Startup I deselected all options but now I want to display the toolbar and menu again. I can't figure out how to undo what I've done.
Help appreciated.
View 1 Replies
View Related
Oct 15, 2005
How do I make my own menus? Is there some kind of wizard or what? I know how to select a menu to use, but as far as making one I've never done/seen it done before.
View 1 Replies
View Related
