Our last videos looked at a number of user-configurable settings for the main MS Access interface. This video will take a look at some of the settings within the VBA Editor. See part 1 of this series at the VBA Settings 1 page.
As with any modern Windows based program, MS Access has a large number of user-configurable settings. Some of them have little impact on the overall program, and others are critical. See 2 videos about setting these options on the Settings 1 page and the Settings 2 page.
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.
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.
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!
Just a friendly reminder. You need to ALWAYS use Option Explicit. Look at the top of any module of code, whether under forms or modules. The first two lines should be …
Option Compare Database Option Explicit
By default, Access only puts the 1st one. You have two ways of getting the 2nd line in there.
What does it do? Forces the “compiler” to make sure that EVERY variable has been declared. Basically, helps stop typos from causing “bugs”.
Just trust me on this one, and do it!
