Recent content by URRich57

Hello vbaInet, I apologize for the long delay. Finally had time to cleanup and implement your recommendations. Added Referential Integrity to the one-to-one Relationships without Cascading and set to the default join type. I left Cascading in the Lookups though. After the first cleanup and...

Hi Bob and vbaInet. In pursuit of answers to your questions, I've located and partially corrected the problem. I found that the newest record in my primary table had no matching record in two related one-to-one foreign tables. A few days ago I deleted the newest primary record and now it seems...

I have a database used to track my personal assignments, created about six years ago using Access 2003 on Windows XP. Recently upgraded to Access 2010 on Windows 7. At some point thereafter, I started having the following issue: When a new record is created, that record gets added to the...

Thanks for the suggestion! I re-created this one several years ago due to the SaveRecord issue and made a start at it again several weeks ago, but didn't have time to complete before taking extended time away from work and lost track of my progress and files. Still considering ur suggestion as...

Thanks Paul!

I have a database created in Access 2003 about six years ago. I’m the sole user of the Application, which I use to keep track of my personal assignments and to quickly access other resources. A search form was added and tweaked over time until it contained the features I desired. The search form...

Hello, I have about seven years of progressive experience designing and supporting Access databases in multi-user environments. Knowledable in some design areas, but lacking in VBA language and advanced coding skills. Have relied on this Forum and other Web sources over the years for help...