databaseLessons

I am sure that I have found them all now.

Seems that when I moved from AccessDatabaseTips.com over to DatabaseLessons.com I moved some files and never added them to the index pages. Most were discovered a month or so ago. Found 2 more today.

Need to use a query to change UPPER CASE values in a field to Mixed Case? Try this.

The documentation tool that comes with Access 2000 (under Tools, Analyze, Documentor) is VERY slow compared to the Access 97 version. I do not understand why. I use this feature frequently to print out the field names of a table. It is so slow in MS Access 2000 that I designed my own. Here is its story!

While I was at it, the info on “dao” was linked to from dozens of articles, but it was never added to an index page. It is now on the “Modules” page.

NOTE: All the VBA code segments on the Database Lessons site assume that you have DAO references active. If you are not sure what this means, and you are using Microsoft Access 2000 or higher, click here.

I hope your databases are being good to you!

I have done a major rewrite of this article, first published many moons ago. The new version has 4 screen shots (about 60 K in total), to help you visualize what I am suggesting. I think I explain myself better as well.

If you have dozens of reports that need various criteria fields, then between this new version and the original Part 1 of this series, you should have a workable answer.

Read the article by clicking here.

As always, write me with further ideas or questions about this article.

A reader reminded me that I never posted part 4 of the Calendar series. Here it is at Calendar Form - Part 4.

I discovered about 20 articles that were on the web site, but not linked to from any of the menu pages. I have updated the menu pages, and Tables, Queries, Forms, and Reports all have new articles. Most went on the Forms page.

The next article (#3) in the series about the use of text files (also called ASCII or flat files) to transfer data to or from an MS Access database has been published. This article is about the Import/Export Specification facility in MS Access. See it at Text Files - Part 3.