Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. DantheDbaseMan

    Autofill table by using data from another table

    I'm not interested in only one field. Ok.. Combo box, the user selects ABC RV Center. Then the other fields associated with ABC RV CENTER gets filled in like ABC RV CENTER code number, and ABC RV CENTER REP_NO, and RV CENTER code number.... The "other" fields are from another table...
  2. DantheDbaseMan

    Autofill table by using data from another table

    TO: GingerR I'm sorry.. I will not post anymore. I will print your last e-mail and will try to figure this out based by the info that you provided. Thank you for being patient with me. I bought a book that cost $54.00 and sometimes these books don't give the answers that I need. This forum is...
  3. DantheDbaseMan

    Autofill table by using data from another table

    To GINGERR: Thanks Ginger. This makes alot of sense. Now, once I create all these table how do I auto populate the DATA ENTRY table after the end user selects the DEALER NAME to autopopulate the DEALER CODE, STORE_NO, REP_NAME and REP_NO? I'm not really sure whether to use VBA CODE or the...
  4. DantheDbaseMan

    Autofill table by using data from another table

    TO: BOXHEAD The DEALER NAMES are not unique. There may be a case where there are three of the same DEALER NAMES but with different STORE_NO and REP_NO and REP_NAME in each record.
  5. DantheDbaseMan

    Autofill table by using data from another table

    To ToeShot: This is just an "example" as posted in my original message. The DATA ENTRY table actually contains 35 fields. Instead of actually posting the entire data structure, I just wanted to convey only those fields that I want to auto populate. Can you help?
  6. DantheDbaseMan

    Autofill table by using data from another table

    Here is my two tables (exmples only) TABLE NAME=DEALER CODES DEALER NAME: DEALER CODE: STORE NUMBER: REP_NAME REP_NO TABLE NAME=DATA ENTRY DEALER NAME: DEALER CODE: STORE NUMBER: REP_NAME REP_NO I would like the end user to Enter the Dealer Name in the Data Entry table by selecting the Dealer...
  7. DantheDbaseMan

    Autofill table by using data from another table

    Here is my two tables (exmples only) TABLE NAME=DEALER CODES DEALER NAME: DEALER CODE: STORE NUMBER: REP_NAME REP_NO TABLE NAME=DATA ENTRY DEALER NAME: DEALER CODE: STORE NUMBER: REP_NAME REP_NO I would like the end user to Enter the Dealer Name in the Data Entry table by selecting the Dealer...
  8. DantheDbaseMan

    AUTO POPULATE FIELD

    I have two table as examples below: DEALER_CODE DATA ENTRY =========== ========== DEALER_CODE DEALER_CODE DEALER_NAME DEALER_NAME REP_NAME REP_NAME <--Want auto populate with REP_NAME in DEALER CODE table when...
  9. DantheDbaseMan

    SELECT QUERY - NOT TO INCLUDE TWO STATE

    How do you write in the criteria if you want to select all address records in the United States except Oregon and Texas?
  10. DantheDbaseMan

    Selecting specific records based on low/high street address fields.

    I have a table that consists of the following fields:<br> Low Address Range Data example: 300<br> High Address Range Data example: 900<br> Street Name Data example: Main <br> Street Suffix Data example: St<br> ZipCode Data example: 75228<br> City...
  11. DantheDbaseMan

    Autofill City and State by entering zip code only

    I have a table with the following fields: cities, zipcode and State. <br> <br> I would like to autofill the city and state whenever the zip code is entered within a data entry form. Can anyone help on how to do this?

Part and Inventory Search

Back
Top