My First Video Tutorial

I have FINALLY put together my first video tutorial. No, you won’t have to look at my mug. It is a simple screen capture of about 1 minute showing how I pre-configure my MS Access 2000 databases with DAO turned on. You can see it by going to the DAO Page.

For many months I have been wanting to start a series of video tutorials to match my webpages. Now that I have finally done one, this sub-project will pick up speed.

If you have any topics you think will benefit from a video portion, fill in a comment.

Please Comment

I have modified the comment system on this blog to allow anyone to comment, even if you have not registered. The comments will, however, be held for me to approve before they appear.

So … no need to register, just click on the “Comment” link on any article and leave a comment for me. If I feel that it is useful to my readers, I will approve it, usually within 24 hours.

2 More Lost Articles

I am sure that I have found them all now.

Seems that when I moved from over to 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!