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 »

Dealing with Access NavPane visibility

Professional Access developers understand, and rarely violate, the unwritten rule that Access database objects should not be directly exposed to users.  Unfortunately, when Microsoft fielded Office 2007, we found that the database window had been removed and replaced by the Navigation Pane, commonly referred to...

Read More »

Using shortcut menus in Access run-time apps

Users of Windows applications have grown to expect right-click menus in applications.  But for some unexplained reason, Microsoft disabled the built-in shortcut menus in run-time applications. This has resulted in many Access developers avoiding the use of these menus and subsequently decreasing the functionality of...

Read More »

Adding Shortcut Menus to Your Applications

As Access developers we all know how important right-click menus are; we use them constantly as we develop our applications, but did you know that you can create your own custom shortcut (right-click) menus in your applications?  Prior to A2007, you could do this by...

Read More »

Date/time picker for Microsoft Access

Over the years, I have seen many posts on the Access groups and forums asking for a date/time picker other than the one built into Access 2007 and subsequent version.  A client recently mentioned that he wanted to be able to pick a date and...

Read More »