ADVISOR TIPS

Microsoft Access Database Multi-User Deployment

Here's how to set up an Access database in a multi-user environment and have a front end on each client.

By Ken Getz, technical editor

PROGRAMMING

Implementing Microsoft Access Sorts, Part 3 

Here's how to make sure your sorts are speedy.

By Ken Getz, technical editor

PROGRAMMING

Implementing Microsoft Access Sorts, Part 2

Build on what you've learned about the QuickSort algorithm to sort more complex arrays.

By Ken Getz, technical editor

USER INTERFACE

Use Field Description Properties to Make Microsoft Access Information Meaningful

When the field description isn’t adequate, usurp it with a query.

By Susan Sales Harkins

PROGRAMMING

Implementing Microsoft Access Sorts, Part 1

Get to know the Quicksort algorithm.

By Ken Getz, technical editor

MICROSOFT ACCESS DEVELOPMENT

Microsoft Access String Manipulation Using Inline Functions 

You can use Access' inline functions to manipulate and extract pieces of data from text fields in order to perform operations (such as sorting) on a part of the data instead of the entire field.

By Joe Stockman

ADVISOR TIPS

In .NET, Run the Application Associated with a Document

Take advantage of the Windows command processor to launch the right application.

By Ken Getz, technical editor

ADVISOR TIPS

Sort Text Data in Microsoft Access

By Ken Getz, technical editor

ADVISOR ANSWERS

Selecting Files in Access, Revisited

In a previous tip, you got some code to select files. But, what if you're using Access 97 and, therefore, can't take advantage of the Split function. Here's an alternate solution.

ADVISOR ANSWERS

Select Multiple Files in Microsoft Access

This flexible code hands back either a single file name or an array of file names.

By Ken Getz, technical editor

ADVISOR ANSWERS

Selecting Files in Microsoft Access

Here's how to work with an ever-tricky control.

By Ken Getz, technical editor

DATA INTEGRATION

Recreate Microsoft Access Tables in SQL Server 

Here’s a tool that SQL Server has and Access doesn’t: The ability to generate SQL Scripts that can be used to recreate your table design in SQL Server -- or any other database server.

By Roger Carlson

USER INTERFACE

Building Microsoft Access Menus Programmatically

Use the Office Commandbar object model to create menus on the fly.

By Ken Getz, technical editor

MICROSOFT ACCESS DEVELOPMENT

Protect Your Work with Source Control and Access 2007

You've made a change to your application and, after much work, have realized that it's all been a horrible mistake. How do you get back to the working version?

By Peter Vogel, editor

ADVISOR TIPS

Using Activate Event to Requery Microsoft Access Forms

Here's another alternative to looping.

By Ken Getz, technical editor

MICROSOFT ACCESS USER INTERFACE

Let One Microsoft Access Report Do the Job of Many 

Don’t overload your database with unnecessary reports, when one will do.

By Susan Sales Harkins

ADVISOR TIPS

Don’t Loop -- Use WithEvents

Using the WithEvents keyword, you can react to built-in or custom events, and can avoid the overhead involved in monitoring for state changes.

By Ken Getz, technical editor

MICROSOFT ACCESS USER INTERFACE

Combine List Box and Checkbox Behavior 

Use a subform to display and manipulate Yes/No data in a Checkbox control with something that looks like -- but really isn’t -- a list box.

By Susan Sales Harkins and Gustav Brock

REPORTING

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.

By Doug Steele