Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    St. Marys, Ontario, Canada
    Posts
    270
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Explanations of Built-in Functions

    Can anybody recommend a good book or site where I can get a simple explanation of all of the built-in functions in Access with easy-to-understand language of how they work (examples of each would be nice, too)?

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    The Netherlands
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Explanations of Built-in Functions

    Hi John,

    There are lots of books about access, but the simplest way to get help on all of the functions is just put the cursor on the function you want help on and press the famous F1 button.
    The access help is pretty good and on each function are one or more examples available.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    St. Marys, Ontario, Canada
    Posts
    270
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Explanations of Built-in Functions

    Bart, what version of Access do you have? I have 2000 and when you hit F1 the help you receive is not too great (in my opinion) and when you hit the Help button it takes you to something that gives you general help on the expression builder. I know that the F1 key and the Help button were useful in earlier versions of Access.

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

    Re: Explanations of Built-in Functions

    Help in Access 2000 definitely requires getting used to, and a lot of sample code that used to be included no longer exists in the help files. There is sample code, but not everything that was there before.

    It's also context sensitive in a new way. The help you see from the database window is not the same help you see from the VB IDE, and searching on the same expression in the answer wizard won't give you the same results. I do find that the index is almost useless, but the answer wizard is much more "helpful". The trick is to word the expression you type in as a "how do I" kind of question. Mind you, I didn't say it was easy to use; but I've been using TechNet and MSDN for years anyhow, so I'm not as bothered by it as most people. I just wish they had included a better search engine, because the one they used definitely needs work.

    In the VB IDE, F1 is highly useful if you position your cursor on a function, object, method or property and the press F1. That will take you directly to help for the specific item...usually. This version of help seems to founder easily, so sometimes you have to try getting there another way. F1 is also useful from the object browser, which is what I use instead of the Help index.
    Charlotte

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    The Netherlands
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Explanations of Built-in Functions

    I use several versions.
    Last couple of months mainly 97, but also 2000.
    Sometimes still some work in Access 2.0.

    I also use Technet and MSDN a lot.
    It takes a little bit experience to ask the right questions, but it still can give you most answers.

    A good resource is alse the access web: http://www.mvps.org/access/toc.htm
    or Helen Feddema's home page: http://www.helenfeddema.com/
    or Peters Software home page: http://www.peterssoftware.com/index.htm

    Check them out!

  6. #6
    Star Lounger
    Join Date
    Dec 2000
    Location
    Hellertown, Pennsylvania, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Explanations of Built-in Functions

    I would recommend the Que Special Edition Using Access 2000. Pages 328..350 have excellent function examples that I find to be very helpful. You can visit my web site at http://www.absupport.com for some built in function examples....

Posting Permissions

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