Search results

  1. A

    Saving changes to records on Form

    Awesome! Thanks Gasman!
  2. A

    Saving changes to records on Form

    Yes that is correct. However, the creation of a new package will be rare. The list of packages of packages that is there is unlikely to change. Users will mostly be adding records under the exiting packages. So they first select the correct package from the combobox and then add the record.
  3. A

    Saving changes to records on Form

    The 'All' option was added to giver users a option to search for a record using the 'Search Activity' text box, rather than having to select the correct package No. under which the record is located first. The save button appears when the option 'create new package' is selected in the combo...
  4. A

    Saving changes to records on Form

    Thanks Gasman. I appreciate you taking the time to respond. I did begin to understand (as you explained) what Arnel had done. His delinking of the master and child links was intentional. Unfortunately the rest of the code is way beyond my limited Access knowledge.
  5. A

    Saving changes to records on Form

    It seems while solving the bigger problem of saving records with the correct package number, the DB has lost the ability to filter by 'All' records. This option when selected in the combo box does not show any records. Any ideas why this may be?
  6. A

    Saving changes to records on Form

    Thanks so much for your help!
  7. A

    Saving changes to records on Form

    Hi Arnel, I wonder if I can trouble you for your help once more? My DB no longer saves new records to the correct package number selected in the package combo box. New records are not assigned a package by default. I not sure what I've changed to cause this. Thanks.
  8. A

    Saving changes to records on Form

    Works perfectly. I can't thank you enough for all the help you've given!
  9. A

    Saving changes to records on Form

    Hi arnelgp, Sorry to keep bugging you. Hopefully this is a quick one to solve. I wanted to keep it so that no records were displayed when the form first opened, but have the option to display all records with a package number 'All' that could be selected from the combopackage. I thought...
  10. A

    Saving changes to records on Form

    Thanks again. This is exactly what I wanted to implement:)
  11. A

    Saving changes to records on Form

    Hi arnelgp, A quick question. I see on the last file you uploaded all activity records are visible when the form is opened. On the one I have the activities are not shown until the a package is selected from the combo box. What controls this? I've gone through the VB code, but can't identify...
  12. A

    Saving changes to records on Form

    Sorry arnelgp, I'm confused. I can't find any other combobox in the form.
  13. A

    Saving changes to records on Form

    Thanks arnelgp. I've opened the file, is this using the search box at the bottom of the form?
  14. A

    Saving changes to records on Form

    Hi arnelgp, I would like to create a search combo box on the main form to filter the activities on the Subform. I would like this to work in 2 ways, first so that the user can filter search all activities even without the package selected. The other would be that it filters activities based on...
  15. A

    Saving changes to records on Form

    Thank you.
  16. A

    Saving changes to records on Form

    Arnelgp, This is great! Much better than my design. I hope you don't mind if I use this? Yes, I work in engineering and construction. This was something I was trying to put together in some downtime. Thanks again!
  17. A

    Saving changes to records on Form

    Hi Arnelgp, The package numbers and descriptions would make sense to be in a separate table as this list is fixed to approximately 40 package numbers, with no additions or deletions anticipated. The Activities (cboActivity), list however will change, with additions and edits to existing...
  18. A

    Saving changes to records on Form

    Thank you very much. This is what I wanted it to do.
  19. A

    Saving changes to records on Form

    Currently the (ignoring the record number ribbon at the bottom of the form) selection of cboPackageNumber and cboActivity functions great for searching and displaying records information i.e. all for the information displayed in the text boxes is the correct information related to that activity...
  20. A

    Saving changes to records on Form

    Sorry, the issue now is that the record overwrites the the changes to the first record in the table and not the correct record. The record navigation at the bottom of the screen remains at '1' even after the record selection is made from the second combo box and the text boxes are updated.
Top Bottom