Search results

  1. H

    Commandbutton - open form, hide fields in target form

    Hi Mike, thanks for the response. I'm just going to transform all the old data in Excel and import it (Xlookup and power query for the win bebe). I've learned a lot from the whole process and am studying database design in my own time so will be prepared for my next build.
  2. H

    Solved Use a subform to change data on the 'one' side of one-to-many relationship?

    Hi Arnel, sorry for the delayed reply! I couldn't get this code to work as it kept throwing up errors. I ended up using a bound popup form to allow users to manually close a case, which is working a treat. I really appreciate the time you took to reply, and am learning a lot from your responses!
  3. H

    Solved Use a subform to change data on the 'one' side of one-to-many relationship?

    Correct, but those events are linear, so each case can only have one *chain* of events attached to it. Each event has outcome of 'active at end of event' (can be many) or 'closed at end of event' (singular, end of event chain). Once singular 'closed at end of event' occurs, no further action is...
  4. H

    Solved Use a subform to change data on the 'one' side of one-to-many relationship?

    The subform I added was back to the case form, but it wasn't linking the Event FK to the Case PK, and as such is creating new records instead of updating existing. Any way to link them or is it just a select-and-search via combobox option.
  5. H

    Solved Use a subform to change data on the 'one' side of one-to-many relationship?

    The values that I was updating through the Update Query are in tblCase. Hence my annoyance that I can't run that at work, because it was perfect!
  6. H

    Solved Use a subform to change data on the 'one' side of one-to-many relationship?

    Hi all, quick brief: three tables with respective forms, Customers, Case, Events. One customer can have many cases, one case can have many events. My issue is how to reflect cases as closed once the last event stage is entered. I had a wonderfully functional update query which was running...
  7. H

    Commandbutton - open form, hide fields in target form

    Yes, because we have five years of existing data in that format (names etc in every row on every worksheet) and I don't have the luxury of time or authority to strip information out of the data to import to make it fit perfectly. If my contract gets extended (dependent on much more than just...
  8. H

    Solved DMax not working - wont update in form or table

    Another big thankyou for such a detailed response Dave. Luckily in this case there is only ever one person at a time entering data but I have 100% taken this on board. Hopefully future projects will be ground up to allow me to implement these learnings a bit better!
  9. H

    Solved Autofill a field

    Really appreciate you taking the time to give such a detailed response Dave. This is a bit beyond the scope of current project and current role but I have definitely taken it under advisement and will keep learning/training so that I understand it all!
  10. H

    Commandbutton - open form, hide fields in target form

    Row source for combobox is a custom query. I appreciate the risk of running into issues, but it's a temporary best fit as I try to get workable database versions up and running. If my contract gets extended I will be able to do a lot more work on the database and with the data analysis officer...
  11. H

    Commandbutton - open form, hide fields in target form

    Combobox is already working perfectly, I do want these fields to display the data as they are doing. All textboxes displaying data are locked to prevent any accidental edits which would throw the tables out of whack (yes I am duplicating data, shhhh I know). The only change I want to make is...
  12. H

    Commandbutton - open form, hide fields in target form

    Last question for now, I promise! I am nearly, finally at the end of my to-do list for V2 of my database! Last thing on the list: I am using a combobox to populate fields - it is working a treat! Only issue is that when I am scrolling back through records, the combobox is blank. What I want...
  13. H

    Solved DMax not working - wont update in form or table

    IT WORKED IT WORKED THANK YOU THANK YOU!!! It is currently displaying '0' until I click my save button. If I move this this to the AfterUpdate of the Surname textbox, will this have the same effect, or does it need to be in the form events? EDIT: Tried it and answered my own question, thank you!!!
  14. H

    Solved New to Access, little SQL knowledge - cascading combo boxes query

    EDIT: Dont worry all I figured it out! Hooray!!!! Populating textboxes that are hidden in Add mode but visible in Edit mode :) Hi all, please find attached stripped database - I have removed sections and fields unrelated to current focus (sorry for error messages) I need to achieve the...
  15. H

    Solved DMax not working - wont update in form or table

    Heres a deidentified copy. Please excuse errors, I had to strip a LOT of fields out from both tables and forms. I do appreciate that data shouldnt be duplicated across tables HOWEVER please note that we are NOT approved to complete all data analysis in Access - this needs to be exported to...
  16. H

    Solved DMax not working - wont update in form or table

    Oooh I love this!!! Very tricksy!!
  17. H

    Solved Autofill a field

    I'm going to strip out identifying branding and references today and upload (subcontracted to gov so have to be very careful)
  18. H

    Solved Autofill a field

    But one event can only have one management meeting decision outcome? I have got individual forms for each stage at the moment. I watch some tutorials on subforms and try and get my head around it 😣
  19. H

    Solved Autofill a field

    So there might be a management meeting with external stakeholders to discuss applications made for aid packages. These applications get discussed in no particular order but the topics of discussion and the outcomes need to be recorded. The admin assistant won't have time to go back, search for...
  20. H

    Solved New to Access, little SQL knowledge - cascading combo boxes query

    I am slowly splicing out extra data sections that are in the respective tables, e.g. 'Management meeting decisionmaking' fields (multiple steps that need to be captured) under 'Event' because there will be one management meeting decision outcome per event. The fields I describe were just the...
Top Bottom