Search results

Thanks, Pat, awesome answer with extra points to think about, too.

Hi Bob, Can't speak for Pat, but the reason I'm using a child Note table is because a Vendor can have one or more notes, and an Item can have one or more notes. I did consider using a long text field for each, and add notes "blog style", but I want to be able to set a status to a note, like...

Hi all, I am starting a project. Two main tables to start, Vendors, and Items. One to many relationship. I want to have vendor notes, and item notes, also one to many. Should I create a Notes table, and link both Vendors and Items to it, or two notes tables, like VendorNotes and ItemNotes...

Got it. Trusted locations issue, the VBA code would not fire until I had the path to my db on the list. Thanks, everyone, for your help. Rick

Ok, this problem has been driving me crazy. I created new tables, in a new db, and a new form, and cut the whole thing to bare bones, to try and get my combobox to take its data and store it in a different table. Could not make it work. Last night it hit me, I have indeed made this work, in...

Thanks, all, I appreciate the help. I guess I am saving the company data more than once, since it is saved in the lkpCompanies table, the source of my combobox, and then I'm saving it into tblShipments. But, based on previous experience, I think that's what I want. tblShipments is history...

Thank you! By "bound" do you mean that the text fields have a control source which is a field in a table? If so, yes, they are bound. I do not know a lot about normalization, but I think of it in terms of "atomization" (among other things), which I think I've done here...

Hello all, The after_update code for my combobox, located on a tab control, is not firing after update. The combobox is displaying its row source correctly. What is wrong please? cboShipper > Row Source: SELECT [tblCompanies].[CompanyID], [tblCompanies].[CompanyName]...