Recent content by kdirvin

At present, I do have a button on my subform to delete the record, which I created through Access' built-in wizard. Unfortunately, it deletes the record from the juncture table and not the record from the table representing the one side. If I could get it to delete the one-side table record...

Re: Code to delete record from multiple tablss? Thanks to both of you for your responses. spikepl - that's exactly what I'm thinking. Cascade Deletes are set for the table and the juncture. Therefore, if I put a delete query for the table representing the one side, the record from the...

Hello, I’m using Access database to track projects and checks. Projects and checks have a many-to-many relationship joined through a juncture table. Tbl_Projects (PK ProjectID) Tbl_Checks (PK CheckID) Tbl_ProjectChecks (PK ProjectCheckID) I have a main form/subform...

Worked perfectly! Thank you so much.

Thanks for the quick response! I apologize profusely, I omitted a crucial piece of information. In additional to the project IDs formats that I provided in my earlier post, as follows: TG-BT-01 JJ-BT-09 HGF-BT-12 Two of my project IDs look like this: BTT-12-10 BTT-50-06 And I do not...

Hi, I am using Access 2007 and need to create a query that returns projects containing “BT” in their Project ID field. The Project ID has a set format. How would I construct the query to return all of the following Project IDs? TG-BT-01 JJ-BT-09 HGF-BT-12 The dashes and the varying number of...

Hi Brian, So you're saying that I should not be doing an outer join? Sorry for my dense question, just not sure what you meant by your answer! Thanks!

My 2007 database stores projects and the contracts on which they go. Each contract has several options, one for each fiscal year that the contract spans. Here is my table structure: Tbl_FiscalYear (lookup for fiscal years) FiscalYearID FiscalYear Tbl_Projects ProjectID ProjectName...

My Access 2007 database tracks projects which get obligated onto contracts. Projects and obligations have a many-to-many relationship, since one obligation can obligate multiple projects and one project may require multiple obligation actions to be fully obligated. The projects and obligations...

You all have given me some great insights. I will use this going forward - thank you!!

Hello all, My Access 2007 database is growing quite large (although well below Access's 2 GB limit). I am aware of the dangers posed by corruption and am taking steps to reduce that possibility. But can a database's sheer size ever threaten the integrity of the data? Thanks!

That worked! The query is now working. Thank you so much!

Thank you for your quick responses! I like your suggested table design better; that is closer to what I had originally. I restructured my tables according to this design. This created 3 one-to-many relationships between tblAgencies and tblProjects. I then created a query with the following...

Hello, No. Each agency can only be one role. A project will have three agencies, one from each role. Thanks!

Hello, I used Access 2007 to build a database that tracks projects. All projects are listed in tbl_Projects: tbl_Projects ProjectID (PK) ProjectTitle Each project has three types of agencies associated with it. One type of agency works the actual projects. The second type approves the work...