Results 1 to 5 of 5

Thread: Query Question

  1. #1
    Join Date
    Aug 2006
    Posts
    559

    Unanswered: Query Question

    Hey all!

    I was wondering if it is possible for a query to run and check the contents of a memo field?

    A bit more into it...

    I am going to have a list-box where a user can pick a specific item (ie: U.S. state). When they pick this state, I was trying to have another list box populate with the cities / counties within that state for the user to choose from. However, what I wanted to do was if the city / county is NOT in the list, can the user add directly to it?

    EXAMPLE:

    Pick state -> California , list cities from tblState (field: City_Name), user looks to see if the city is listed. If not, they can type directly into the list box the city that they have to add to the list. Then a query is run to update the listing in the table field City_Name. That way when the next person goes into the database, the city name will be listed there and they don't have to worry about it, they can just select it.

    Is this possible? Did I explain it well enough? Or did I confux everyone?

  2. #2
    Join Date
    Jun 2008
    Posts
    163
    Pick state -> California , list cities from tblState (field: City_Name), user looks to see if the city is listed. If not, they can type directly into the list box the city that they have to add to the list.
    Hmm, try setting the "limit list" option of the combo/list box to "no". It seemed to work for me, let me know if it doesn't work for you.

    I haven't used memo fields, so I don't know about those.

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yeah, I'm not sure where a memo field would fit into this.

    A combo box has a special event "On Not In List" that you can use to add in an item that the user keys in that isn't already in the list. Check it out
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Aug 2006
    Posts
    559
    Thanks for the suggestions, I'm going to look into it. Just trying to eliminate unneccessary tables from the DB.

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    That's always a good idea too
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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