Search results

My understanding was that if you tab subforms then they will all relate to the parent form? I.e. create Customer, then go to enter Case and this will relate directly to the Customer info you just entered? The data that will be entered in my database isn't linear (i.e. occurs on a 'when it comes...

I am regretting not documenting! I was just trial and erroring following through with other similar responses on the forums, most recent try was: [on click 'save' button] Me.CustomerID = Nz(DMax("CustomerID", "tblCustomers", 0) + 1 It didnt update the table and the textbox in the form...

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 theDBguy, just wondering how this works if you had to enter data at multiple different points in time? Are you trapped into having to track back to the original parent form and filling from there (e.g. if you had a customer who has been with your organisation for years), or if you have to...

Hi June7, your suggestion worked great with displaying the data but I'm running into two issues: 1. Data is not updating to table (i.e. CustomerID) 2. When going back to previous records the combobox is showing as blank, meaning it is impossible to tell which Customer the form is referring to...

Hi JDraw, thanks so much for this, very helpful. I am trying to split a bit more out of my four tables where there is a 1-1 relationship to allow use of subforms (e.g. one section in referrals is 'referrer', so can subform that out). Work in progress when starting from an existing spreadsheets...

Haha I'm giving myself a lot of headaches as I learn!!!

Not a problem at all! I work with a small nonprofit. This database is intended to keep records of persons interacting with our small-scale social aid program - we need to keep track of who has ever accessed the program (Customers), the times they have applied and been approved for aid (Case)...

The surnames and first names need to be in the tables for now as there is a lot of old data being ported in. Can I use that combonix as a calculated source for a 'Name and ID' field in the respective tables?

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