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

Concatenating Fields in an Access Query

For those of you that have wrestled with concatenating fields and the use of the & and + symbols, this post will demonstrate methods of building a SQL query to combine multiple field...

Read More

Setting Parent/Child Windows

Here is a simple method for forcing a form window to open inside another form's window when the parent form is loaded. This can be useful for access applications utilizing a custom user interface...

Read More

Managing Multiple Form Instances

Need: Multiple Form Instances Have you ever needed to create/compare/edit multiple records at the same time?  If so, you've probably noticed that the default form behavior in access is to allow one instance of each form to be open at any given time.  This limits the user to working with one record at a time in "Single Form" view.  The good news is that there are a few different ways of adding and managing multiple instances of a form and this article will cover the method most commonly utilized for my project...

Read More