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.
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!
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...
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.
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...
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...
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!
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!
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...
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...
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...
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!!!
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...
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...