A reader wants to know where to find Functions information for more recent versions of Access.
Q: Marty Nizlek writes: “In Access 97 one could easily find a summary page listing Functions alphabetically. As well, there was the ability in the Builder Wizard to select a function, then hit help, and the function’s definition would come up in detail, with examples. Not so with more recent editions. Do you have a favorite way, perhaps a site, that can accomplish the same?”
A: In Access 2003, open the VB window, then select Visual Basic Help from the Help menu, and select Microsoft Access Visual Basic Reference from the table of contents. This Help book includes lists of methods, properties, events, functions, etc. Clicking on a function name opens its Help topic (mostly; sometimes you get a blank page).
For use outside of Access, you can download the Access VBA Language Reference from the MSDN online library, using the this link. This link worked on Jan. 20, 2005; if it doesn’t work when you try it, go to the main MSDN page (http://msdn.microsoft.com/) and search for the language reference by title.
There is a reference on this page (and others) to an online version of this reference, but it just yielded a blank page when I clicked it, so you will need to download the large file instead (unless Microsoft fixes the broken link by the time you read this).
To use this reference, unzip the downloaded file, and double-click the VBAAC10.CHM file.
