Results 1 to 5 of 5

Thread: Using queries

  1. #1
    Join Date
    Apr 2004
    Posts
    11

    Unanswered: Using queries

    Hi

    I'm an access newcomer, and I need to be able to create a query based on a customer number i input. When I enter a number, I need all of the specific details for that customer to appear.

    It needs to be run when I enter the customer number and click an 'OK' button in a form.

    Any help appreciated, cheers.

  2. #2
    Join Date
    Apr 2004
    Location
    South Arica
    Posts
    125
    is it to display data on the form? ie. If you select customer 1, then information is shown for customer 1?

  3. #3
    Join Date
    Apr 2004
    Posts
    11
    No I need the information in a query, cheers

  4. #4
    Join Date
    Mar 2004
    Posts
    118
    I'm not sure exactly what you want.

    How I would do it, is have a little text box on a from with a button, where you enter a string and press ok and it pops up a query with the data.

    The hardest thing would be making the query... Its probably gona look something like this :

    PARAMETERS [textbox0] String;
    SELECT *
    FROM customers
    WHERE (((customers.customer_id)=[textbox0]));

    I dont know what fields you want or if you want all of them... You would need to save that as a query and write a little event on the OK button.
    Last edited by YevSnow; 04-20-04 at 07:28.

  5. #5
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Originally posted by digsy
    No I need the information in a query, cheers
    I'm not so sure you do...

    Could you please provide a detailed explanation of exactly what you would like to see happen?

    I have a hunch you may be better off with a combo box lookup, but I can't tell for sure.

Posting Permissions

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