A reader’s trying to add info to a query but keeps getting a message “Recordset Not Updateable”. Q: Roger Fisher writes: “I have an Access 2000 database that has a form that is based on a select query. When I try to type in a field on the form I get a message that “Recordset […]
Here’s some Explorer-type interfaces for finding records in Access tables. Q: Tom Gerry asks: “Is there any way to create an Explorer style cascading folders user interface to find records in an Access Table?” A: The closest to this would be a TreeView control used as a record selector. I dealt with the TreeView control […]
Option Explicit – to use or not to use? Q: Matt Perelstein writes: “I was wondering what you thought about using Option Explicit? It used to be a default, included with each module, but I noticed that in Access 2003, it’s not any more. I’ve used it religiously for years, but now I’m wondering why.” […]
How to customize menus/toolbars so the full menu always shows. Q: Bob R. writes “I just got a new computer with Office 2003 pre-installed, and when I open a menu in Access (or any other Office app, for that matter), I just see a few commands, and I have to hit an arrow to expand […]
The meaning of the word “Me” in VBA code. Q: Stuart E. Wugalter asks what is the meaning of the word “Me” in VBA code? A: Me is an Access keyword that refers to the form (or report) from which the code is running. There is also a Parent keyword that refers to the main […]