Search results

  1. K

    Solved Keep subform data present while refreshing mainform

    I just got a whole new perspective on how those particular properties work that I hadn't ever realized! It refers to the records and not so much what the form can do. I can't thank you enough for helping to clear up my subform issue! And I'd forgotten to remove that other OnChange sub, thank you.
  2. K

    Solved Keep subform data present while refreshing mainform

    Pat, that was a helpful read but doesn't fix my issue. Please see the database attached.
  3. K

    Solved Keep subform data present while refreshing mainform

    I had an AfterUpdate event also but it didn't seem to work by itself so that's why the OnChange. I have removed it now like you suggested and it still works the way I had intended it to but the problem still remains that the mainform refreshes and clears the subform when the combobox selection...
  4. 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...
  5. K

    Best way to send selected listbox values to a datasheet form

    Oh, I see. I had thought that by making those bound to the query, it wouldn't pull the correct information or only the first entry. Thank you, thank you! I learned a lot just now. :-) Krissy
  6. K

    Best way to send selected listbox values to a datasheet form

    Wonderful! Thank you arnelgp! However, if I enter a Qty for Item #1 and another for item #2, it changes the Qty for Item #1 to what I entered for #2. The same goes for the column PurchasePrice. What do you suggest I should do there?
  7. 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...
  8. K

    Loop INSERT INTO statement

    Wow! You are right JHB!! 1. I suppose that makes sense and I should've realized that. 2. Thought I'd set the fields to be the same. 3-5. Did some research and now I understand the reasons why that's useful. 6. I know now why those settings are there and how to use them. Thank you so much for...
  9. K

    Loop INSERT INTO statement

    Try this attachment......
  10. K

    Loop INSERT INTO statement

    JHB, I don't know any other way to post it. Did you click the down-arrow in the top right corner?
  11. K

    Loop INSERT INTO statement

    https://drive.google.com/open?id=0B6jZXGf3QPC1OHd6UUc4MFROdzQ Start the form "Add New Training", enter 1 into the CodeSecNum combo box, write "Test" in the description, and select 1 or more positions from the listbox to apply the training to. Click "Save and Add Training" and close the form...
  12. K

    Loop INSERT INTO statement

    The [CodeID] is numeric and I tried without the brackets. It didn't work. Thanks for the idea though!! The_Doc_Man, I've tried several more ways including what you suggested and still not giving me anything. Sometimes it won't enter any information into the table I want. Is there something...
  13. K

    Loop INSERT INTO statement

    I'll go ahead and try the (Count) idea though I'm not sure what you mean by (0 TO ....ListCount-1). Beginning coder. Would you mind writing out the whole line so i understand what it is you mean? The ('before values...etc) was more of a mental note that I forgot to delete prior to posting...
  14. K

    Typed value in combo box not allowing change

    JHB, It was under the combobox event but you gave me another idea. I placed the same event as the OnChange, under AfterUpdate and it works great! :-) Thank you!!!
  15. 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...
  16. 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...
  17. K

    Subform shows blanks but Mainform does not

    Uncle Gizmo, Yes that is correct. When I open the SubForm as a stand-alone form, all the training shows. Those with dates and those without. When I open the MainForm which carries the SubForm, only the training with dates shows. I want all of the training to show, not just the ones with...
  18. 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...
  19. K

    Looping gets Runtime Error 3251

    Thank you pbaldy and Galaxiom! I believe I tried it that way originally but it failed so my next objective was to try the loop. I will go back through and figure out where exactly I went wrong with my form/queries. Thanks a bunch!!
  20. K

    Looping gets Runtime Error 3251

    Sorry, CJ. You are right. That was in a mix of trying different ways and I forgot to reverse my changes before I copied and pasted here. See the original post edited. The form is meant to enter in new Employee information and the "Button", to enter all the "Training Codes" listed in the...
Top Bottom