Search results

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

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

Hi all, I am trying to set up sequential numbering for my CustomerID field in tblCustomer (first and highest table in database). Much as I would love to let it stay as an autonumber, I have been directed by management that CustomerIDs must be sequential with no gaps. As such I have established...

Hi all, CURRENT KNOWLEDGE LEVEL: Tables and Reports all good, simple queries all good, learning Update Queries and Union Queries, Form formatting all good, comboboxes NOT GOOD. My database has four tables, with four related forms for data entry: Customer Case (multiple cases per customer)...

Hi all, I'm new to Access and have managed to rope myself into designing a database for live use for one of my work units. I have an intermediate knowledge of Excel and am definitely learning Access at a rate of knots through YouTube tutorials, AW and SO forums, and a lot of trial and error! I...