I have just finished a 6 month long build of an access 2010 app.I have used the publish wizard to make it publishable. This has made the accdb to an accdr file. No my edit list form don't work when you right click.This seems to be an issue with accdr files.Is there a way to have a button on the form that when clicked does same think as the right click option for edit option selected.
I want to select an item in a listbox that has a specified value when I open the form that contains this listbox. Most I've found describes selecting records based on their index value but I want to select an item according to the actual value that's displayed in the listbox. For example, the first number below is the index value, the 2nd is the number I'm interested in and the 3rd is another column in the listbox:
0 1 12345 1 2 33256 2 4 36280
I'm using the OpenArgs property to pass the value (a long integer primary key) to the opening form but I don't know the syntax or correct terminology for ensuring the specified row is selected in the listbox. At present, using the above example, if I want to select the row with the value 2, it's selecting the 3rd row rather than the 2nd.
I have a list box on a form and I would like the user to have the possibility to add another item not from the list into the table using a command button. How can I do that?
Is it possible to remove an list item from a combo box list after it has been used.
What I am trying to do is use a combo box that has a list of questions, after the user selects a question from the combo box list and answers the question when they reselect the combo box that question will not be seen again till the form is reloaded.
My main form has a list box - user selects an item in the list box for editing. The selected item displays in a text box on the subform where the editing is to be done. User than makes corrections to the text box and clicks a button to save the changes. I have all of this working. But I can't figure out how to update the main form on this save button.
What is happening right now is the main form is not updating at all and the original selection in the list box is still highlighted. If I click within the list box, the list box updates with the correct entry.
What I need to happen is when the save button is clicked, that the listbox updates and the selection in the list box is deselected and then set focus on another text box that is on the main form.
(I was doing this as 2 separate forms and the edit form opened after the user selected the item and clicked a button (kept the first form open but not visible and based the text box on the list box) This worked but again when the user saved and returned to the first form even though I was able to setfocus to the text box, the list box kept the selection highlighted.)
My combobox is not working correctly. When I select one of the dropdown items in the combobox it always defaults to the 1st item on the list. I want to be able to select any of the dropdown items on the list.
I have a subform in a form that has a Combo Box that is linked (not sure is that is the correct term) to a field called PartID in a table containing a list of Parts. The list show the Name of the Part (PartName) and other fields.
This all works great except that it allows the user to change the text in the Name of the Part (PartName) field directly from the Combo Box!!!! I really don't want this to be able to happen.I have the "Limit to List = Yes" but it still allows the user to change the value...The "Allow Value List Edits = No"...
Hi pals, I have the following problem. I have a form that runs a query from 5 tables linked via odbc. The thing is that the result is showed ok.. but when I tried to edit an item in grid, I can't do it. (get that noisy bell). I realized that if i only use one one table, I can edit ok.. but If I use more than one, I can't. Any solution to that?? Thnks Mariano
I have several comboboxes in my database from which users select values. However, in most cases, I do want to give them the option to add an item that does not appear while simultaneously updating the underlying table which stores those dropdown values. I have made use of the builtin "allow edit list items" feature of Access 2007 but the form always opens on the first record of the form on which they are to add the new item. Is there a way to specify that it should open in Data Entry view apart from using VBA?
I have created listbox with one column (contains one column only), now i would like to display all the characters of list item (want scroll bar to listbox).
How do i display all text of list item, I have already fixed Column Widths to max length (22";0.1"). However when scrolling to right, it is going to next blank column of list box, which is created only to change Column Widths property.
In the form1 , I have a listbox1 with 2 columns. The values get added in the listbox using vba. Now I want to Edit the listbox values in case user enters something wrong. So when the user selects a listbox item and then EDIT button then form2 gets opened. And the textbox1 of it stores column1 of listbox1 value and textbox2 stores column 2 of listbox1 value. So the user canb make changes in the textbox values and then press SAVE button . Now I want the code that will make those changes in listbox1 of form1 and unload form2 then.
If the 5th option (Other) is selected, the user is required to specify what 'Other' represents.
I have created a combo box with the first 4 options and in instances of 'Other' the user can enter specific treatment that is not in the list (1 to 4).
What I would like to do is whenever the user enters a value that is not on the list (1 to 4), I would like to insert the word OTHER in front of the value entered. In other words all values not on the list will be prefixed by 'OTHER'. E.G. if 'Surgery' is entered, I would like the value 'OTHER : Surgery' to be stored in the Treatment field of the table.
This will help in the generation of statistics from the table.
Hi I have placed a Listbox in MS Access form. I use VBA. I have saved the item selected in the List box in a database. While retrieving the item from database, I want the listbox selected i.e the item should show as highlighted in the list box. Is this possible ?
HI all, the objective is to grey out an item within a listbox, where the id number is the same in another sub form. The sub form is called contacts and the list is called list15. the unique id that is linking the two is SWD.
I would like to be able to create a recipe (saved in its own table) by pulling items from a multiselect list box (from the raw materials table) but which allows me to add the same ingredient more than once.
I work for a chemical manufacturing company and we need to track the cost of goods by recipe (final product), by linking the ingredients (where the cost of the raws are associated) to the final prodcut. Several of our products need to have chemicals added in the beginning, but then again at the end of the procedure unlike normal kitchen recipes.
(I sure hope I don't have to learn VBA . . . I'm totally new at Access!)
I am using a combo box in my form. It is a growing combo box allowing new entries to be entered to create a growing list.
When new entries are made to the combo box list they are only displayed when I quit the form and then return to it. Is there any way I could allow the combo box list to grow dynamically rather than having to get the user to quit the form and then return to it?
Didnt know where to start or what direction to head in. I have a combo box on one of my forms. It works fine, but would am looking for an added feature.
I am looking to get the following started:
There are 5 items in the list of my combo box. If the user selects the item called "Lost Opportunity", then how do I get an additional combo box to show up underneath it with reasons the sales opportunity was lost.
Then the reasons why would be in the additional box and they would have to select one...my work wants it so that if they lose the sale, they must provide a reason for that loss of business.
I have made a few cascading combo-boxes that dynamically change based on the data entered into the field above them.. Example:
A SKU is entered, the combo-boxes pull the information for that sku from one or more tables (using SQL Query).
Now... I am having trouble getting these fields to show the first item in the list of possible item specifics. Everything comes in fine, however, I need to form to refresh and repopulate the fields one the SKU loses focus.
Drop down list equipped with new item input provided. My application now use a drop down list to access/display a form with certain item selected, but I want to entry new item using drop down list which equipped with "entry new item" then I hope the form can be accessed belongs to new item.
I have a MS Access database, which contains three main tables. With these I have a completed table, which holds either Yes/No within it.
One of the tables, I have linked to the Completed table as a list box, which when a job has been completed, either yes or no can be selected.
But, what I want to happen, is, when the Yes is selected, I want Access to insert the date the 'Yes' was selected, so that the employee cannot lie about the date the job was completed.
Hope I have explained this in a good enough fashion.
I don't have a clue how to go about it, could anyone help.
how I can have a shortcut option when right click on each item on the list box. So I got my answer with below code that opens another form "frmshortcut" with a listbox inside that shows list of options like "new task" , "edit item" . Now my problem is (like attached picture) the shortcut list (frmshortcut) will be open in another place when I right click the mouse, it is far from location of click. Also it shows some default in access when I right click in the listbox ("subform", "cut", "copy"), actually I do not like it shows these, just I like it shows shortcut list I have defined by the list box.
Private Sub ItemList_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single) Const RIGHTBUTTON = 2 If Button = RIGHTBUTTON Then DoCmd.OpenForm "frmshortcut" ' DoCmd.OpenForm "frmshortcut", acNormal, , , , acDialog Forms!frmshortcut!txtparameter = Me.ItemList.Value End If End Sub
My list box will be used to populate a form, is it possible that once the item is dble-clicked, it reverts to a different color to let the user know it has already been selected once or can the row be locked once it has been selected?
I have two table. Table 1 (assets) list all my assets etc. Table 2 lists all servicing for each asset.
I have a form which generates a list box of items that require servicing (once servicing has been completed on these items) I would like to update all records, in both tables. Table 2 with all the information about the service. and Table 1 with (only) the next service date.
I have set the list box to allow multiple selection and have used the following code to allow new records to be update in table 2 (which works). but I cant seem to get the code to edit one cell in table 1.
private Sub Command59_Click() Dim strSQL As String Dim db As DAO.Database