Category Archives: VBA
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 … Continue reading
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 … Continue reading
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 … Continue reading
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 … Continue reading
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 … Continue reading