Access Tech Community

The Access development team at Microsoft continues to up the anti on how a team should support their users.  After many years of apparent neglect, Michal Bar and her team have really improved the relationship between the development team and the Access community. In addition...

Read More »

Templates available for Access databases

Microsoft has published templates for five types of database applications on their website.  The basic url only shows templates for Word, Excel, or PowerPoint, but there is an additional URL which displays these five templates (Asset Tracking, Contacts, Students, Event Management, and Task Management). I...

Read More »

Manage VBA application user roles with AD groups

Instead of creating your own table of users, roles, and user roles, and then creating forms to manage those user – role combinations, consider using Active Directory groups.  Your sysad already has all of your users built into your domain, and it is a relatively...

Read More »

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 »