Preventing Reference Failures

In the March 1999 issue’s “Access World News,” we reported on how Access references can break when end users update their systems or install new software. Hardin explains the problem that causes functions like Left() and Date() to fail, delves into some mysteries in Access’s use of references, and presents a module that can get your applications back on track.

The first time it happened to me, my stomach bounced against the soles of my shoes. I’d just finished an Access application for a new client, tested it thoroughly, and delivered it to the client’s office. As soon as I started to demonstrate the program, my code failed on a simple Left(). The error message insisted that the function wasn’t available. Luckily, I had an .MDE version of the project with me and it ran just fine, so I was able to implement the application. My client insisted on available source code, though, and I didn’t know how to make the MDB version work. Continue reading

Posted in VBA | Leave a comment

Peter Comes to Bat

In this month’s issue, Peter tackles handling of quotes,  using the RecordsetClone on a form, violating Windows user interface standards, data entry forms, and how to find the First Monday and Last Friday of a month.

I can’t figure this out. I’ve created a DLookup function and, for the Where clause part of it, I entered “[Department] = Forms!frmDept.txtDeptNumber.” This is supposed to look up the department name for the department number displayed on the form. But it doesn’t work!

Continue reading

Posted in VBA | Leave a comment

Persistent Caching Of Combo Boxes etc

Take a Load Off Your Server with Access 2007 or Access 2003.  Includes examples of using XML in ADO.

Access 2000 allows you to generate persistent recordsets that can be stored on a local drive. This article demonstrates how to use these local recordsets to cache information for display in ComboBoxes or ListBoxes on Access forms. Continue reading

Posted in VBA | Leave a comment

More Dragging Around

Doug Steele tries to address commonly asked questions from Access developers. This month, he extends his look at how to add drag-and-drop to an Access application, as well as looking at how to simulate XP Cuing Banners.

I tried implementing your drag-and-drop code from your article in the January 2003 issue. That worked well, but I want to go one step further: Can I drag from other applications to an Access application? Continue reading

Posted in VBA | Leave a comment

Is SQL Better than DAO for Creating Tables and Indexes

SQL may be much more useful to you than you think. In this first in a series of articles on SQL, Peter introduces SQL and compares it to DAO for ease of use and performance. He also includes a utility to transfer table designs among SQL databases.

IF I have one complaint about Access it’s that using it can prevent you from fully discovering the power of SQL. There are experienced Access developers out there who have never written a SQL command and see no reason to. They assume that as long as they can create Access queries or write code using Data Access Objects to manipulate tabledefs and recordsets they don’t need to learn SQL.      Continue reading

Posted in VBA | Leave a comment