I 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.
I 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 2 Replies View RelatedI 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 RelatedHi 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.
I 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
HI 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!
I 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:
Is 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
Hi 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
After 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
Hi,
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 ....
Is it possible to remove/hide the combo on the forms' Main Menu toolbar which says - 'Type a question for help'?
Dave
I 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.
Hi 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
Hi,
I want to copy my Toolbar and Menubar in another .mdb, can any one help me?
Rahul
Hi 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
It 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
Hey,
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
How 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
I 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
Just 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
Whilst 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............
Hi.
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
i'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
Is there a way to make the mini toolbar, with the attachment control, visible all the time?
View 1 Replies View RelatedHi 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