Hide Toolbar
Jul 20, 2006I have create my first program. When you click on the program it runs (I am an expert now!) But when I want it to run, I want it to hide the toolbars on the top so no one can alter it. Any suggestion?
View Replies
ADVERTISEMENT
Hide Toolbar
Dec 27, 2006I am trying to hide some toolbars and have noticed that with the following command:
DoCmd.ShowToolbar "Design View", acToolbarNo
I get an error message. Is there a way I can avoid this toolbar to show whenever I issue an updated file? Thanks.
Hide Toolbar When Program Runs
Jul 20, 2006I have create my first program. When you click on the program it runs (I am an expert now!) But when I want it to run, I want it to hide the toolbars on the top so no one can alter it. Any suggestion?
View 1 Replies View RelatedToolbar
Aug 13, 2006Hi all
I have a toolbar called companies.
How can I add menus to it??
Any attempt to help will be highly appreciated.
Thanks in advanse
Regards
Mark K.
Toolbar Buttons
Jun 18, 2005I have created a floating toolbox much like the floating toolbox you see when you design a form. I want my buttons to stay depressed the same way they do in a real toolbox. It must be possible... I just have no idea how..
any info is greatly appreciated
Custom Toolbar
Mar 29, 2006HI all, I have recently created my own custom toolbar for my database which works fine on my computer, but when the database is transfered to another computer via a memory stick (needs to be done as it is going to be used on remote laptops away from the main network), the custom toolbar does not carry over. Instead of the custom toolbar being shown, the normal, main toolbars are reset to the default ones shown.
Is there a way of stopping the toolbars reseting when transfering the database so that my custom toolbar is the default toolbar?
Thanks for the help!
Custom Toolbar
Jul 13, 2006I have a custom toolbar in my application. However, it isn't visible at the top of the application window and when I try to make it so - via View - Toolbars - it doesn't appear on the list of available bars.
I had assumed that I had somehow deleted it, but I know it's still present somewhere, as when I try to recreate it, I get a message saying so.
How can I get the toolbar to be displayed? :confused:
Create My Own Toolbar
Jul 22, 2006Is there any way of adding export fuction to the toolbar using modules or macro
or how I can build my own toolbar when will appear in all workstation in the company
Custom Toolbar
Mar 6, 2007Hi folks:
when I create a custom toolbar on my db, would that custom toolbar be carried to other copies of my db? I'm hiding all toolbars using code and I need to display only one.
thanks
Combo Box On Toolbar
Oct 2, 2007After several nights of reading through the documentation on the ability to add a combo box to a toolbar, I have not been able to create a combo box with more than one column and hide the key column.
Here's my goal (I think that many people would want to do the same):
In any database that deals with a client table, a good way to access a client's record is by putting a combo box on the client screen with (at least) 2 columns, one is the client's ID and the other is a Last, First field. (I usually put another column with phone number as well). The user selects the client and the value of the combo box is set to the (hidden) ID field and the AfterUpdate event pulls up the appropriate recordf.
My idea is to put this combo box right on the toolbar for easier access. You may want to call up a client even if the client screen happens not to be open.
The combo box on toolbars seem to work with indexes rather than allowing you to hide (or size) a column, making this seemingly impossible.
Another issue I found is updating the contents of the combo box.
Since Access doesn't refresh the contents of a combo box, I always set mine to have no rowsource. In the OnGotFocus event of the combo box, I assign the rowsource programatically to the client list (or whatever list the combo box is meant for) so you always get up to the minute results. The amount of time that it takes to load 10,000 names into there even over a LAN is so fast that the user doesn't notice that it's loading.
I'm not sure what would happen if I had to do the same with the toolbar combo box. First of all, I'm not aware of any OnGotFocus event so you'd literally have to keep refreshing the contents every time someone changed, added or deleted a client from the client table. To refresh the contents, it seems that you can't just set the rowsource to a SQL recordsource. (The way I did it was to have a loop go through my database using DAO and using the AddNew command for each client). You would actually have to loop through, clearing out every item and then adding them back in each time someone updated the client database.
All the above is based on what I was able to derive from the documentation that Microsoft has provided for this feature. I do see that there are many events, styles and properties of the combobox that have scant explanation and I'm hoping that someone with more knowledge can help me out here with the problems I'm having. I think this can be a wonderful and much-overlooked tool for many Access developers if it can be used as I want to.
Thanks
SHADOW
Customizing A Toolbar
Jun 28, 2006Hi,
I was trying to customize a toolbar by adding the "size to shortest", "size to narrowest", etc., stuff from the format menu. The first item, "size to tallest", I just clicked and dragged from the format menu onto my toolbar, and that worked fine....except that it disappeared from the format menu. Then, I tried to drag "size to tallest" back to the format menu; Now it has disappeared totally from both my toolbar AND my format menu. How do I get it back???:confused:
BTW, I found out if I ctl-drag items from the format menu to my toolbar, they stay on the format menu but also appear on my toolbar. Wish I had known that before ....
Toolbar On Forms
Dec 3, 2006Is it possible to remove/hide the combo on the forms' Main Menu toolbar which says - 'Type a question for help'?
Dave
Every Acces Screen Has Its One Toolbar Btn
Dec 21, 2005I only want the active screen on the toolbar. and all other screens like the DB screen and forms that are not active to be hidden on the toolbar.
I hope you can understand it. else i wil make a screendump of what i want.
Custom Toolbar & Parameters
Jul 18, 2006Hi all,
I'd like to create a custom toolbar where each button would call the same generic module function, passing it a parameter.
I see how to create the toolbar, but I can't figure out how to call my function and how to pass it parameters.
Also, I can't find any explaination on what this "Parameter" box of the Custom Toolbar is. I thought that would pass parameter to the command in the "on action" but I can't seem to be able to retreive it...
Any help appreciated,
Jerome
How To Copy Toolbar And Menubar
Oct 22, 2006Hi,
I want to copy my Toolbar and Menubar in another .mdb, can any one help me?
Rahul
Disable Button On Toolbar
Mar 5, 2007Hi all,
This has to be simple, but the solution eludes me.
I have a database that works really weel, but I need to do some tweaking to the toolbars to "grey out" the "sort ascending" and "sort descending" icons so that hte users do not mess with those and change how the recoerds display.
There has to be an easy way to disable those two buttons or an alternate way to ensure that the form basically ignores them.
Thanks
mafhobb
Can You Put Menu & Toolbar On Same Line?
Nov 25, 2007It wastes a lot of screen space and looks a little unbalanced to have a very short custom toolbar immediately below a very short custom menu, as I do in an Access 2003 application of mine. Is there any way to make a menu and a toolbar sit on the same level?
David
Custum Toolbar For Printing?
May 5, 2005Hey,
I use a code to hide my toolbars and database window and desable Right Mouse Click. The code I use is:
'Hide Toolbars
Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i
'hide Database Window
DoCmd.SelectObject acTable, , True
DoCmd.RunCommand acCmdWindowHide
Now i try to show my custum toolbar with code:
DoCmd.ShowToolbar "HLP1", acToolbarYes
But I still dont see the toolbar? Do I have to do anythink else to show it? I need that custum toolbar for printig my reports. So pls help me out with this.
Thx
Combo Box On A Custom Toolbar?
Feb 1, 2005How can I put a combo box on a custom toolbar so that it is always avail/visible for the user (and has code behind it to open a form w/ arguments)?
Thanks,
David
Custom Menu Bar / Toolbar With Images
Mar 12, 2006I have created a menu bar in access 2003 and I have spent the last couple of hours designing icons in photoshop, however, when i come to import these icons to use on the menu bar I can't see anywhere to do so, only a button editor that isn't much use to me.
Is it not possible to import icons in this way (like you can for command buttons on forms)?
Thanks for any help
Custom Toolbar In Access 2007
Mar 27, 2007Just recently updated to 2007 and found something I would like to adjust.... But can't find out how, or if I can.
I have a DB done in Access xp, it has a custom toolbar. Well, works fine in 2002,2003... but when I open the DB in 2007 first, I have to click "Add ins" to even get it to appear and then it is WAY too big! It is only about 5 small items...A-z, Z-a, "Lightning bolt" for filter on, and "filter off" but the height is the same as the other "Ribbon". Is there a way to adjust the appearance? AND make it visible when the DB opens?
Thanks
Hidden Database / Toolbar Menus
Oct 27, 2006Whilst trying to tidy up my database in the Start-Up menu, I checked the boxes that hid all toolbars and menus, so now when I open the database, all I get is the opening Main form I created.
Does anyone know how to correct this please, I need to continue working on the database and it is driving me nuts............
Hiding Access Toolbar In Form View
Aug 24, 2007Hi.
I have a widely used application in Access 97.
Anyway, some staff are not using the forms' menu buttons but are playing around with the Access toolbar (file, edit, et cetera).
The administrator wants me to either disable that toolbar or hid eit from view. Any ideas?
Russ
URGENT HELP : Restricted The Toolbar In Access 2000
Mar 30, 2006i'm doing my final year project and i have restricted the toolbar in access. I need it back as i need to make changes to the forms and switichboards, but i can not access them. Does anyone know how to get it back???????????
Please .......
Pamela
Forms :: Mini Toolbar With Attachment Control?
Mar 19, 2013Is there a way to make the mini toolbar, with the attachment control, visible all the time?
View 1 Replies View RelatedHow To Change The Colour And Other Format Properties Of A Menu/ Toolbar?
Oct 9, 2007Hi All,
If it is possible to change the format properties of a menu/toolbar could someone please point me in the direction of some guidance/ let me know how to go about it I would appreciate it.
Specifically I'm trying to change the menu bar's /database window's property to match my forms (and company branding).
I've Googled various phrases in both UK and US spellings (to be on the safe side) and searched a few forums (this one included) and cannot find much beyond creating customised menu/tool bars.
Many thanks