List of explanations for built-in functions in Access?

[Thwork]

I am using Microsoft Access 2000. I am looking for a complete list of the
built-in functions (found in the expression builder) and explanations of what
they do, and how to use them. The Access help files say very little about
these functions, and all explanations that I have found on the web have to be
searched for separately. Can anyone pleeeeez help?

 

[Paul Overway]

Open or create a module....press F1 while in the VBA editor.

 

['69 Camaro]

Hi.

I am using Microsoft Access 2000. I am looking for a complete list of the
built-in functions (found in the expression builder) and explanations of what
they do, and how to use them.

Then you'll need to purchase some reference books for comprehensive listings
and explanations. Most of the links one finds on the Internet just repeat
exactly what one finds in the Access Help files, anyway.

all explanations that I have found on the web have to be
searched for separately.

Perhaps the following links will help a little by providing a central
location to see the names of functions and methods (and available links).

Links to built-in functions:

http://msdn.microsoft.com/library/d...us/off2000/html/acidxFunctions.asp?frame=true

Links to methods:

http://msdn.microsoft.com/library/d...n-us/off2000/html/acidxMethods.asp?frame=true

Or you may download the most recent (April 2005) version of Access 2003 VBA
Reference. Most of what's in Access 2003 is also compatible with Access
2000, but you'll have to compare with the lists of "What's New" in both 2002
and 2003 to be sure.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac11/html/Welcome_HV01132058.asp

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that the first and
best answers are often given to those who have a history of rewarding the
contributors who have taken the time to answer questions correctly.

 

[Dirk Goldgar]

I am using Microsoft Access 2000. I am looking for a complete list
of the built-in functions (found in the expression builder) and
explanations of what they do, and how to use them. The Access help
files say very little about these functions, and all explanations
that I have found on the web have to be searched for separately. Can
anyone pleeeeez help?

Open the help file and, in the Contents pane, expand the topic
"Programming in Visual Basic". For the built-in VBA functions, expand
the subtopic "Visual Basic Language Reference" and navigate to the
"Functions" subsubtopic. They're all listed alphabetically. For
special Access objects and methods, expand the subtopic "Microsoft
Access Visual Basic Reference" and read the "Objects" and "Methods"
subsubtopics.