Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2004
    Posts
    85

    Unanswered: Query? Please Help

    Yay its me Newbie Booby again

    lte me thank everyone thats tried to help me..

    I have one last Question..................(for now)

    Okay...

    I want to do a Query on a field from my form (Suburb)

    so in Query where it says Criteria what shall i type

    and do i need to set up a relationship..

    Hope you can help or throw me some ideas..



    wish there was a MS Word forum. so then i good help people

  2. #2
    Join Date
    Apr 2004
    Location
    Sydney Australia
    Posts
    369
    If you want to select from your field Suburbs you type some of the following

    "Hurstville"

    That will produce all the records where the suburb is hurstville

    "*ville"

    That will produce all the records where the suburb names ends with ville

    "Hursville" or "Kingsgrove" will produce all the records that contain either Hurstville or Kingsgrove

    "S*" will produce every record where the suburb name starts with S.

    That should keep you busy for a while

    Mike

  3. #3
    Join Date
    Mar 2004
    Location
    www.scirocco.ca
    Posts
    346
    Could you please describe your table structures and what data do you want to extract from them?
    http://www.scirocco.ca/images/banner...occobanner.gif

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

  4. #4
    Join Date
    Apr 2004
    Posts
    85

    Red face thanks for asking

    i have a form page with fields like "name" "address" "suburb" e.t.c that the user fills in and it automacally stores in the table (Table1)

    I have another table of Drivers "name" "area code" "suburb" "mobile number". e.t.c

    when the user enters in the form of a order i have a command button that runs a query. What i want it to do is to sort through the drivers list and show the details of the driver from the suburb entered into the form.

    my query button works but shows the whole list of drivers. instead i need to show the whole record of just one of the drivers that work in the suburb that was entered into the form

    i just need the code to put into criteria "that says [suburb]!form1" or something like that.

    thanks for your time again


    Jessy xxx

  5. #5
    Join Date
    Apr 2004
    Posts
    85

    Angry anyone know?

    am i making sense?

    what do i type in critera to bring up a certain record based on text from a form.


    anyone?

  6. #6
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    two questions away from the answer:

    stored access query or strSQL from code?

    code is running in the same form that has the text box (Me!)? or a subform of it? or where?

    izy
    currently using SS 2008R2

  7. #7
    Join Date
    Apr 2004
    Posts
    85

    i did it

    i worked it out

    [Forms]![Form name ]![Field Name]


    thats all i wanted to know.

    hope this helps out somone else



    if only they had a MS Word Forum. then i could help people

Posting Permissions

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