Search results

  1. R

    Limiting Results by another Column

    Thanks GumbyD!!! That's very good advice!!! Have a nice day:) Bill
  2. R

    Limiting Results by another Column

    Hello All- I am running queries off of very large data sets (100,000's rows). I want to limit my results to a specific category. I have 3 "Product Types" (HW, SW, and Services) that "Customers" can purchase. I'm trying to analyze the "Customers" that have purchased "Services" and thier...
  3. R

    Locking Down my Database

    Ok, I've created my database Tables, Forms, Queries and Reports and now I'm ready to deploy this application to my users....How do I create user access priviledges for my application? I want users obvioulsy to Add,Delete and Change the data via the forms I created, view and run the queries and...
  4. R

    Inserting data from forms w/ Junction Tables

    Dgm, thanks again for your advice...I'm not really a programmer, so fancy code is probably not good for me...I think you're right, I'll have to trust my users to add a part to the order... Thanks for your help with this problem...Have a nice day...Bill
  5. R

    Inserting data from forms w/ Junction Tables

    dgm, your awesome I get it now...last problem (I hope)...I have all my required fields from the main form (Orders) all set, but now I want at least 1 part # entered as part of Order....Since the Part# is being pulled in as a Combo Box within the subform, how do I make this a required field on...
  6. R

    Inserting data from forms w/ Junction Tables

    DGM, Thanks for the reply....Yes my main form will be the Orders Table....I assumed my subform needed to be the Parts table, cuz that where the Parts information is stored...what I'm trying to do is create an Order that can constist of many Part #'s...The Order # and the Part# needs to create a...
  7. R

    Inserting data from forms w/ Junction Tables

    I am looking to create a form that will insert data into my Junction Table that I created for my Many-to-Many relationship between Orders and Part #'s. I didn't have a problem when I created the form with a One-to-Many Relationship between Parts and Orders. Now that I want an Order to consist...
Back
Top Bottom