Results 1 to 3 of 3

Thread: [form!] lanuage

  1. #1
    Join Date
    Jul 2010
    Posts
    6

    Red face Unanswered: [form!] lanuage

    In QUERY CRITERIA, how does it the language work?

    i.e. Form![Formname???]! ???

    what does each phrase refer to and the '[ ]' mean?

    I want to try to get to a set of dates, that's in a table, based on RegNo/TagNo that's in a table.



    need help!!

  2. #2
    Join Date
    May 2010
    Posts
    601
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    The brackets are optional. They are only required if you have an entity with spaces in the name. For instance, if you were to say something like: "forms!my form with spaces in the name!control", Access would assume you intended to say "forms!my" and then followed it up with something else that should be compilable. Whereas if you wrap it in brackets: "forms![my form with spaces in the name]!control", it knows that everything in between the brackets is to be treated as the identifier you're trying to go after.

    The same idea applies to specifying entities in a query. Table/query/field names may or may not be surrounded by brackets, unless the names have a space in them. Then you have no choice.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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