Search results

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

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