Search results

  1. K

    Solved Keep subform data present while refreshing mainform

    I have an order form in which I select parts/items from a listbox (lstItemsPerVendor), relating to a specific Vendor, to be ordered and then adjust the quantity and purchase price in the subform (frmOrderItemsPerID). However, I have also made the form allow for specific categories of parts to...
  2. K

    Best way to send selected listbox values to a datasheet form

    Hello Everyone! I'm not very proficient at Access but love it's capabilities. I've tried a few avenues but I think I'm making it harder than it may have to be. I have a main order form to purchase items from various vendors and the OrderID is auto-populated. A person may choose a vendor and...
  3. K

    Typed value in combo box not allowing change

    Hello, I have a combo box on a form that, (OnChange), is set to re-query textbox calculations. When I select an option from the combo box list, the calculations are re-queried as desired. However, when I type them in, nothing happens and the values in the textboxes stay the same. Why is...
  4. K

    Loop INSERT INTO statement

    Hello All! I have a form where a person can create/enter a new training CodeID and select the PositionID's, from a listbox, that would need that particular training. All of my vba code works except the following part which is the loop: Private Sub cmdSaveandAdd_Click() DoCmd.SetWarnings False...
  5. K

    Subform shows blanks but Mainform does not

    Hello all, I have a SubForm created from a query that shows an employee's training based on their EmployeeID. When I open the SubForm, it shows the training with dates applicable but also the training which does not have date (This is what I want). But when I open the MainForm, only the...
  6. K

    Looping gets Runtime Error 3251

    Hello all, I'm fairly new to programming vba in Access so please forgive my simple tries and help me understand what I'm doing wrong. What I want to have happen when I click the "button", is for it to loop through each 'Code' in the 'Type of Training' table and enter the specified information...
Top Bottom