Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Apr 2002
    Location
    SF Bay Area, California, USA
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Expression/Function Syntax Quick Reference Sheet? (Access 2002 SP1)

    I have books, manuals and tutorials, but when I am adding a calculated field or expression to a query or report, I usually leave out a bracket, or quote or paren or something important and have to go searching through various indexes (indices?) for the correct format/synatax. I was hoping <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16> that somebody here might know of a quick reference guide or some such small booklet that doesn't weigh over 5 lbs that might have just this limited type of information for somebody like me that can't remember all the bits.

    Thank you.

  2. #2
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Expression/Function Syntax Quick Reference Sheet? (Access 2002 SP1)

    This web site has a useful reference on how to refer to controls in different circumstances within VBA.

    I tend to print out certain help pages which I often need to refer to so you end up building your own reference over time. Other than that I don't know of a small 'bible' which is available.

    HTH a bit.
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Expression/Function Syntax Quick Reference Sheet? (Access 2002 SP1)

    Adding to Steve's suggestion, if you haven't discovered the Help files for Access functions, it's because they are all in the VBA help, not in the Access help - even though many of them can be used in calculated expressions in queries and the like. To get to those, open a module (or start a new one) and then select help. At that point you can find out for example what RND and what it does. Print out the ones you use frequently, but also look at the index to see all the different functions that you can use. Hope this helps.
    Wendell

Posting Permissions

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