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 ....
To remove the file button from access. however the more commands button in the quick access toolbar renders this method pointless unless i can remove the more commands button. How to remove the "customise quick access" button or failing that how to remove the more commands button?
Am an ardent access user and have a small problem that am Requesting for help.
I have designed an application software using access and I would like to peddle it to a few prospective clients. I want to package it as a trial software to run for thirty days and after that if the clients is not satisfied,I want it to disable but store the data. How is this possible.
But when I try to add a button with the following code it doesn't work: <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon startFromScratch="true"> <tabs> <tab id="tabMain" label="CRSTHA Manager"> <group id="grpHome" label="Home"/> <button id="cmdHome" label="Home" size="large" onAction="onOpenFormEdit" tag="frmMain"/> </tab> </tabs> </ribbon> </customUI>
I am creating a database of private equity funds. I want to have a currency field for an input entitled fund size. However, I need to be able to display whether the size of the fund is in dollars or euros. How can customize a number/currency field to allow me to input the correct currency symbol?
Hi I was hoping someone could give me some advice on formatting dates in a text box upon a form. The date forms part of a serial number that consists of a user selected prefix, from a seperate list box and a 4 digit date in the format of year and week, ie "yyww". I was intending to use the current system date as the source.
Hi I wonder if anyone could re-orientate me and put me in the correct direction regarding the above subject. Without wittling on too much what I,ve been basically trying to do is to get a query that I've made, derive its criteria from a form that has 3 combo boxes on it allowing a user to select varying options. I have been using a forum thread which described the process in more detail and whilst I,ve followed it to the letter the end result that I get an annoying message "The expression On Click event that you entered as the event property setting produced the following error: A problem occured while MS Access was communicating with the OLE server or Active X control. It goes onto say that the expression may not result in the name of a macro, the name of a user defined function, or [Event Procedure].There may have been an error evaluating the function, event or macro". The thread took me to www.fontstuff.com/access/acctut08.htm and it is on this site that I have been trying in vain to come up with a matching result. Am I going mad or is there someting on their tutorial that is mis-leading me! I am desperately trying to adminster some 'self help' and to use the forum threads but I am still at a loss as to what to do next. Could some kind person please help...
I am having trouble customizing a database template, i have changed the fields that i needed and got rid of one that i did not but for some reason it will not work.
I am trying to create a form for a query so that I can filter on a chosen record and have the data presented in a more reader friendly format: the idea being that I have the common data show once in the form header and the rest show in the detail section (kind of like a form with subform type)
First I tried using the form wizard to create a Tabular layout form which I could have easily customised, but I am unable to use this because I get an error message telling me the wizard cannot create my form due to me choosing too many fields.
In my next attempt, I elected to use the Multiple Item form option, which seems to work OK but presents the following problems:
1) It has not included all of the data fields in my query... though it looks like I can add these manually 2) I am unable to reorganise the text boxes and labels the way I would like, as they all seem to be locked together Is there a setting somewhere that I can change to stop this from happening?
I am looking for a way to customize fields to be hidden or not depending on user in forms or reports.
Any idea ?
I wanted to explore the customisation of each query but there must be an easier way to save personal parameters somehow so that the user would go through the forms and hide the non necessary fields once and we would then save somewhere these settings for each user.
I don't want my user to type in the parameter value for a query in case of miss spelling. Therefore, I'm using a dialog box form with a combo box field. The row source of the combo field is a table with one field for the list. I've added VB code (Event Procedure) to a buttons on the dialog box which says to run a query after click. I've created the query for the info I need displayed and am using the forms combo field as the criteria.
Private Sub cmdOK_Click() DoCmd.OpenQuery "qryRequestsbyBranch", acViewNormal, acEdit DoCmd.Close acForm, "frmDepartmentList" End Sub
I am trying to change the standard input mask violation error message to a personalised one. I have found this code:
Private Sub Form_Error(DataErr As Integer, Response As Integer) Const INPUTMASK_VIOLATION = 2279 If DataErr = INPUTMASK_VIOLATION Then MsgBox "There was an input mask violation in the field no!!" Response = acDataErrContinue End If End Sub
However, i would like to change the message for a number of different text boxes. and i don't know how to isolate each one, and give each one a different message?
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..
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?
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:
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.
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.
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?
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...
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.
