Recent content by Superglide

Thanks for the response JR. I considered the delete boolean flag on deleted records. I ultimately decided to go with the physical delete because 99% of the time a record is deleted due to duplication in data entry (i.e. a business process issue, which we apparently can't solve). So actually...

Thanks all who viewed. I know it's quite a complex puzzle. Here is a sample db with vba code that shows what I'm doing. Rename it to .mdb. If you modify any registrant info, it'll create a log entry, which you can view from the Edit Registrant form by clicking on the H button. If you go to an...

Perhaps a real challenge for you. I am creating an audit log for a database I have developed. This has been an interesting challenge, more complex than I expected. Here's a (hopefully brief) summary of how it works. For the audit log, I want to capture previous values for select fields when...

Newbie programmer that I am, I'm at least familiar with the importance of error handling in my code. However, I'm unfamiliar with best practice. Currently, I error handle every sub. Like below (modeled after what comes in the sample MS Access databases for error handling). Private Sub...

Sweet. That was exactly what I needed. Now that I see it, I see that it was obvious. Just learning... Thank you much, SpentGeezer!

I have built an audit logging capability into an existing system; basically any time data changes on a form the audit log captures previous values and writes them to an audit log table. I accomplish this using VBA and various form properties (e.g. OnDirty). The combo boxes on my form execute...