Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Feb 2003
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access quary (97)

    I have a large list of peoples name in a database, I have created a quary table that requires one of the persons name to be typed into the message box to activate the quary and return the required data. As there are many names, typing each name in a message box is not the most effective way to undertake this task. Is there any way to replace the message box with a drop down table or list box with the peoples name already entered and then I can just select the name required?
    Any help would be much appreciated
    Thanks
    Jonathon

  2. #2
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Carrollton, Georgia, USA
    Posts
    123
    Thanks
    3
    Thanked 1 Time in 1 Post

    Re: Access quary (97)

    Jonathon ,

    I'm new to this forum, but maybe while other people are helping me, I can help you.

    One thing I do is, I create a form, say "frmSelectName". I don't give the form a source table. You can actually use the wizzard.

    When you have your new form in design mode, you can use the tool bar with the wizzard turned on to create a drop down list. The wizzard will walk you through setting up the drop down list. Tell it you want to select your information from a table, and select the table that stores your names. Then, once you have your pull down list, you can add in a command button (don't use the wizzard with the command button), that will open a form / query where your pull down list equals your name in your query.

    I don't know if there's a way to share a database with this forum. If there is, I'll be glad to do you a sample and send it to you.

    Hope this helps.
    KST

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

    Re: Access quary (97)

    The way you share a database is to create a zip file containing the database and post it as an attachment. Attachments are limited to 100Kb size, so your database needs to be very focused. In the reply window, you'll see a button just below the Check Spelling and Preview buttons for browsing to a file to attach. Once you select an attachment, previewing or spell checking will remove the attachment, so do those first and then select the file to attach.
    Charlotte

  4. #4
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Carrollton, Georgia, USA
    Posts
    123
    Thanks
    3
    Thanked 1 Time in 1 Post

    Re: Access quary (97)

    <P ID="edit" class=small>(Edited by charlotte on 23-Feb-03 12:50. to remove email address)</P>Jonathon,

    I have a sample database to send you, if you want to e-mail me.


    KST

  5. #5
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Carrollton, Georgia, USA
    Posts
    123
    Thanks
    3
    Thanked 1 Time in 1 Post

    Re: Access quary (97)

    Thanks Charlotte!

    Jonathon, I have created a little sample, I'm sure there are other ways to do it, but I've been doing it this way for years.

    Hope it helps.
    KST
    Attached Files Attached Files

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

    Re: Access quary (97)

    For you information and that of other newcomers to the Lounge, we request that you keep discussions in the public forums (see <!rule=10>Rule 10<!/rule> ). If a zipped file is too large to post as an attachment, you can almost always cut it down to a size than can be zipped to 100 Kb or less. You can add your email address to your profile if you wish, but please try to keep the problems and solutions public where they can benefit the largest number of loungers.
    Charlotte

  7. #7
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access quary (97)

    In addition to what Charlotte has said, by keeping it public, there are more eyes to make sure the the answer is correct. I'm not saying that you would make a mistake, just that it is easy to do, here is one of mine (I'm not adverse to using myself as an bad example when I can <img src=/S/grin.gif border=0 alt=grin width=15 height=15>)
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

Posting Permissions

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