Search results

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

IT WORKS. Literally shouted for joy. Thank you for explaining everything so clearly!!!

Thank you very much for your thorough response and the helpful tips. The “tblProjectPeople” table makes sense….looks like a juncture table to accommodate the many-to-many relationship between tbl_Projects and tbl_POC. I am not 100% certain on how I would populate this juncture table. I’m...

Working in Microsoft Access 2007. I have two tables, a table listing projects and one listing POCs. tbl_Projects Project Number Project Manager Resource Manager tbl_POC POC ID POC First Name POC Last Name The Project Manager and Resource Manager fields from tbl_Projects are set as Lookup...

Hello, Thanks for your quick response. In tbl_Contract Years, the Fiscal Year field determines the full fiscal year. This field holds the full four-digit year. When the user first enters the years information into the DB, they select "2011" into the field to designate FY11 or "2012" for...

I am using Access 2007. My database tracks contracts spanning across multiple years, and data about these years are stored in tbl_Contract Years. Fields include Contract Number, Fiscal Year, Year Number (whether it’s the 1st, 2nd, or 15th year), and Year Cost. Therefore, if Contract A was...