I wrote a number of articles for Advisor Media between 2004 and 2007. These articles used to be available only for subscribers, but I finally managed to convince them to make them public. Here are links to them:

Explore your MP3 Files with VBA (Originally published December, 2004)

Learn how to retrieve the metadata in an MP3 file using VBA code.

Find Your MP3 Data via VBA Programming (Originally published May, 2005)

Using MP3 files as an example, learn how you can search for data on your hard drive.

Move Local Data to Microsoft Access (Originally published June, 2005)

Using MP3s as an example, learn how to catalog data from files on your hard drive into an Access database.

Learn How to Split a Database (Originally published November, 2005)

Learn how to automate the creation of a back-end database for use with your application.

Create Tables in Your Split Application (Originally published December, 2005)

Learn how to automate back-end database creation for use with your application.

Create and Populate Tables in Microsoft Access Using DDL (Originally published January, 2006)

Learn how to use Data Definition Language (DDL) to quickly and easily automate the creation of tables, relationships, and indexes.

Connect Your Split Application (Originally published February, 2006)

Splitting a Microsoft Access application into front and back ends improves network performance. Here's how to connect the ends into a whole application.

Use DAO to Make Changes to a Microsoft Access Back-End Database (Originally published April, 2006)

A back-end database can help you speed Microsoft Access applications residing on a network. Find out how you can make changes and improvements to your back-end database to meet your data needs.

Use DDL to Make Changes to a Microsoft Access Back-End Database (Originally published May, 2006)

Discover the advantages -- as well as some limitations -- of using Data Definition Language when making database changes programmatically.

Do Custom Page Numbering in Microsoft Access Reports (Originally published June, 2006)

Make your reports more professional by displaying page numbers in the most optimal way.

Enhance Your Microsoft Access Forms with the TreeView Control (Originally published June, 2006)

Enhance Your Microsoft Access Forms with the TreeView Control

Add Pizzazz to Your Forms with the ListView Control

Learn a versatile technique for presenting data to users in an organized manner.

Effectively Use Many-to-Many Relationships in Microsoft Access (Originally published October, 2006)

Discover two approaches to making simple many-to-many relationships available to users.

Easily Change Application Configurations in Microsoft Access Using INI Files (Originally published November, 2006)

Sometimes, you need to store application-related data outside of the database itself. Here's a way to do it using INI files.

Use Windows Standard Dialogs in Your Microsoft Access Applications (Originally published December, 2006)

Give your users the File Open and Save dialogs they want -- the same dialogs used by Windows itself.

Get the Most from Microsoft Access Using the Query Tree Editor (Originally published December, 2006)

Product Review: Using SQL Queries is fundamental to using Access effectively, but the Access SQL editor is a limited tool. Query Tree Editor, from 4TOPS, provides a better environment.

Let Users Know What's Going On with the Status Control in Microsoft Access (Originally published February, 2007)

You just can't provide your users with enough feedback. Using the ActiveX StatusBar control lets you display more information more effectively than the default Access function.

Impress Your Users with Attractive Forms in Microsoft Access (Originally published March, 2007)

Learn how to use a different combo box control to give your application that extra visual oomph with graphics.

Improve Data Integrity in Microsoft Access with Sliders (Originally published April 2007)

If you want to make sure your user enters data that's within a specific range, you need to use a Slider. With a Slider you can let your users select a single value or select the start and end values for a range.

Generate and Report on Scheduled Activities in Microsoft Access (Originally published March, 2007)

Here's a tried and true way to get it done.

Eliminate Bloat by Using Temporary Databases in Microsoft Access (Originally published May, 2007)

Using temporary tables in your Access database can lead to database bloat. This technique leverages built-in features of Microsoft Windows to eliminate the problem.

Automatically Calculate Holiday Dates in Microsoft Access (Originally published July, 2007)

Many organizations, from companies to families, have re-occurring activities that, while scheduled, happen on different dates each time they occur. Here is a flexible system that can handle almost any scheduled date you can throw at it.

Capture and Display RSS Feeds in Microsoft Access (Originally published August, 2007)

With a little code, you can access information distributed over the Internet through Really Simple Syndication. This article covers how to capture that information and three different techniques for displaying it to your users.

Turn Microsoft Access Data into Information with Graphics

Spruce up your reports with this technique.

Communicate More Effectively In Microsoft Access Applications Using Graphical Reports (Originally published November, 2007)

Find out how you can simplify the presentation of data to users.

Reuse Your Subreports in Microsoft Access

You can save yourself time in maintaining your applications by reusing subreports to report different data. However, changing the underlying data for a subreport means that you need to determine the order that Access processes your reports -- not an easy task.

Get Data from the Internet into Microsoft Access

Here’s the code you need to download a table on a Web page into a table in your Access database.

Download Images and More from the Internet to Microsoft Access

See how the DOM model makes it very easy to work with images and hyperlinks on Web pages.

Access Home

This page is maintained by Last Updated: 01st January, 2010