Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    Loudon, New Hampshire, USA
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Expression Builder (Access 2000)

    Hi to All,
    I wonder if any one knows where I can find an explanation of all of the functions in Expression Builder. So far help has been helpless. Books do not seem to cover the functions.
    What is the deal? Is there another place to search for an answer???? About the only one of the functions I know is IIF. I am sure some of the others may help me in the future, if I only
    knew what they do.
    Still Cornfused,
    Sarge <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Expression Builder (Access 2000)

    The functions in the expression builder are whatever functions are in your project, whether built-in, or user-defined, or provided through a reference to another object library. There is no help for the user-defined functions, but if you go into the VBE (Alt + F11) and bring up the object browser, you can find the syntax for the built-in functions and on-line help should have explanations and usage samples. Does that help?
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Jun 2002
    Location
    Loudon, New Hampshire, USA
    Posts
    125
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Expression Builder (Access 2000)

    Hi Charlotte,
    Sorry, when I depress Alt. + F11, all I get is I go back to the from I came from. It really is the Expressions in Queries that make me scratch my head. The Built in Functions are what I would like to find out more about. The only function I can say I know is "IIF". The others for the most part are a mystery.
    More cornfused,
    Sarge <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Expression Builder (Access 2000)

    Alt + F11 opens the VB editor. What are you trying to do? You can't get a builder in queries, so you'll have to rely on help and the object browser to get the syntax for the functions. The only place you can do that is from the VB editor. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  5. #5
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Expression Builder (Access 2000)

    If you're looking for context-sensitive help for built-in functions (like you get with Excel formula builder) there is none in Access Query Expresssion Builder. As Charlotte recommended you have to open VB Editor (Alt + F11 or Tools>Macro menu) before you open Expression Builder. Since VBE opens in own window you can switch back & forth between Expression Builder and VBE. Open Help in VBE and then search for function name.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •