Tags: access, builder, built-in, complete, database, explanations, expression, functions, microsoft, mysql, oracle, sql, thebuilt-in

List of explanations for built-in functions in Access?

On Database » Microsoft Access

5,284 words with 3 Comments; publish: Wed, 04 Jun 2008 01:43:00 GMT; (250125.00, « »)

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?

All Comments

Leave a comment...

  • 3 Comments
    • 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/de...asp?frame=true

      Links to methods:

      http://msdn.microsoft.com/library/de...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/de...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.

      "Thwork" wrote:

      > 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?

      #1; Wed, 04 Jun 2008 01:44:00 GMT
    • Open or create a module...press F1 while in the VBA editor.

      Paul Overway

      Logico Solutions

      http://www.logico-solutions.com

      "Thwork" <Thwork.ms-access.todaysummary.com.discussions.microsoft.com> wrote in message

      news:263AB6F7-85EF-47AD-82A0-6EC21FF58435.ms-access.todaysummary.com.microsoft.com...

      >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?

      #2; Wed, 04 Jun 2008 01:45:00 GMT
    • "Thwork" <Thwork.ms-access.todaysummary.com.discussions.microsoft.com> wrote in message

      news:263AB6F7-85EF-47AD-82A0-6EC21FF58435.ms-access.todaysummary.com.microsoft.com

      > 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.

      Dirk Goldgar, MS Access MVP

      www.datagnostics.com

      (please reply to the newsgroup)

      #3; Wed, 04 Jun 2008 01:46:00 GMT