Cascading List Boxes: Part 1

This article will demonstrate how to create cascading list boxes between tables with one-to-many relationships.  The example provided here has been created by the author using Microsoft Access 2007.  This method also modified to work with combo boxes and can easily be adapted for use with many-to-many relationships....

Read More

Custom User Permissions: Part 1

When developing a full scale database application for Microsoft Access, one of the hurdles you're bound to run into sooner or later is the need for user permissions.  Managing who can see which forms, edit which records, run which reports, etc can seem like a daunting task for developers.  This series is focused on provided the knowledge and resources necessary in preparation for developing a user permissions management solution in your own database applications...

Read More

Function to Close All Forms

The CloseAllForms Function article posted in the UA Wiki  is a handy tool to close all active forms opened with the DoCmd.Open method. The example code provided in the article includes optional arguments for excluding selected forms from being closed which is an added flexibility bonu...

Read More

Lebans: An excellent developer's resource ...

Looking for functional examples of advanced access development technique...

Read More

Referencing Access Objects in a Query or Control

Referencing data in objects (tables, forms, queries, reports) is a basic skill in the Microsoft Access developer's toolkit, but what if you need to reference the objects themselves as part of a custom administrative interface (for example)?...

Read More

Guide to Closing Forms with VBA

Because it may seem like a mundane task to many, it can be easy to overlook a few opportunities for improving our applications' overall performance with something as simple as closing a form.  AccessInsider explores one such opportunity by providing an example for utilizing a public function call to close forms in order to reduce the amount of code required to load each time a form is launched. While any actual performance benefit will likely be undetectable using this particular example,...

Read More

Open Applications using Shell Method

In this post, we will go over one of the common methods for launching external programs from within Microsoft Access by utilizing the shell method in VBA.  A couple of other features also demonstrated in the example found at the end of this post are setting the external application as a child window within access and giving the shelled program a custom window caption by using API call...

Read More