Home » 2017

Simple Access Audit Log

In response to a question on Experts Exchange, I did some research and then developed a simple audit log feature for Access database applications.  I have described the features and provided sample data forms and code in an article I published on EE. The process...

Read More »

Identifying all open instances of Excel

VBA’s GetObject( ) function is great for assigning an Access object variable to a single instance of Excel, but this function only identifies the first instance of Excel which was opened.  If you have multiple instances of Excel open on your desktop, then you need...

Read More »

Automating Excel from Access

Today I published Part I in a series of articles written to assist Access developers in their efforts to improve user experience when working with Excel in their applications.  Many of my clients have migrated their business processes from working primarily in spreadsheets to working...

Read More »