Recent content by joleary

I have a db that has records with references to documents (primarily Visio, Word, and PowerPoint documents) stored on the external filesystem. I'm only storing the paths to these references - I'm not storing them as embedded or linked OLE fields. This works well on my form, where I can store...

Thanks George, that worked. To help the next person trying to solve a similar problem, here is the code I wrote to create the mirror record, as well as to delete the mirror when deleting the main record. Best, Jim Private Sub Form_AfterInsert() Dim curDB As Database Dim recSet As Recordset...

Thanks George, feels like we're on the right track. Is there a way to implement a trigger in Access (to follow the structure you are outlining)? Best, Jim

Thanks for your response. I think this is a bit different from a self join, in that there is a many-to-many relationship. One thing I think we have going for us here is that we really only need the one level of the relationship, but we need it in both directions (e.g., if a relationship is...

I've searched far and wide for a solution to what seems like a straightforward problem: I have 2 reports that must print separately (one is portrait, one landscape) that I want to generate and automatically combine into a single pdf (so the user doesn't need to do so manually). Recommendations...

I am working on a software requirements database and want to be able to relate requirements to one another, so that the reader can easily see what other requirements may duplicate or impact a given requirement. These requirements do not have a hierarchical relationship, I am trying to merely...

Thanks to all for the great content on this site - I've resolved a lot of issues by reviewing previous posts. I've searched this forum pretty thoroughly and couldn't find the answer to the following: I have a report that generates a document that replaces an older MS Word-based template...