What's New

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

February 17, 2007 - 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.

December 28, 2006 - 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.

December 17, 2006 - The next article 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. See it at Text Files - Part 2.

December 12, 2006 - I have started a new series about the use of text files (also called ASCII or flat files) to transfer data to or from an MS Access database. See the first in this series at Text Files - Part 1.

November 26, 2006 - Here is a quick tip that I have had to use a lot lately. I'll open Access up (version 2000) and the main textual menu (File, Edit, View, ...) will be missing. How can I get it back? (1) open the "Immediate" window in the VBA editor by pressing Ctrl-G on the keyboard. (2) type the following VBA command (without the single quote marks) into the resulting space 'CommandBars("menu bar").Enabled = True' and then press the Enter button. (3) close the Immediate window. The menu should now be back.

September 26, 2006 - Make a choice using a listbox, and have another listbox's choices dependant on that first one. Listbox Based on another Listbox.

September 1, 2006 - When communicating with Excel, how to add a formula to a cell, dependent on how many rows were added to the workbook. Access Data to Excel Series - Part 5.

May 1, 2006 - Paul emailed me the following question, "I can reference form A from form B using syntax like Forms!FormA!ComboBox.requery, but if form A is not open, I will get an error. I know I could trap the error, but I would rather have a bit of code to check if Form A is open - do you know how to do that?" Okay. How do we answer the question - Is the form open? (or - Is the form loaded?) See an answer here.

April 25, 2006 - Article converted from the old site about creating and using custom toolbars. Click here to read it.

April 25, 2006 - Article converted from the old site about the books I have used to learn more about Access VBA. Click here to read it.

November 10, 2005 - Article converted from the old site about left padding numbers with zeroes. A practical application is included as an example. Click here to read it.

November 6, 2005 - Article about Data Recovery of corrupted Access databases. Click here to read it.

September 3, 2005 - Article about adding the word "ALL" to the choices in a combo box. This combo box is then used to supply criteria to a report, thus allowing the user to choose just one code/dept etc to report on, or all of them. This one has an associated sample database. Click here to read it.

July 25, 2005 - Article about using the Query generating tool to create SQL code to be used in VBA code for a recordset. Click here to read it.

May 21, 2005 - Article about using Access to copy the back end data mdb for archival purposes. Click here to read it.

March 24, 2005 - Article from my old site, converted here, about using unbound forms to connect to tables with a large number of fields. Click here to read it.

March 19, 2005 - Article about using the MsysObjects table in Access. MsysObjects

Subscribe to our MS Access ezine and never miss a new article again. Click on the Subscribe button at the left and follow the instructions.

the following is an advertisement for a new collection of Health and Wellness Information products being promoted by our sister site at www.nutritionlessons.com

Are you ready to cash in on the multi-billion dollar
Health and Wellness industry? Let us handle the
research and hard work for you...

"How to Start Your Own Home-Based
Business, Or Boost Your Existing Business,
with Private Label Resale Rights to
Over $1,000 Worth of Freshly Written
Health and Fitness Products and
Content Each and Every Month"

Low Carb Dieting, Hair Loss Prevention,
Arthritis Relief, Muscle Building Secrets,
Sunless Tanning Guide, Healthy Dating Tips,
How to 'Spot Tone' Your Way to A Beautiful Body...
.
And more of the hottest Health and Fitness topics
for selling and distributing both online and off!
.

Click Here to Get Started Within Minutes!
.