Managing Multiple Form Instances

AccessInsider demonstrates the collection method of managing multiple instances of a form. Free example database included.

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)? AccessInsider demonstrates one method of accomplishing just this.

Concatenating Fields in an Access SQL Query

Having trouble combining multiple fields in a query or not sure when you use the + symbol instead of an ampersand? AccessInsider shows you how.

Setting Parent/Child Form Windows

Learn how to load a form inside another form as a child window. Free example database provided by AccessInsider.

Showing posts with label Shell. Show all posts
Showing posts with label Shell. Show all posts

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 calls.

Share

Twitter Delicious Facebook Digg Stumbleupon Favorites More