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!

  • Congratulations dencom 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. crystal0streaks

    Multiplying information 7 times

    I have a query taking from a couple tables and queries, everything works fine, but the information is duplicated 7 times...how do i fix this??? -crys
  2. crystal0streaks

    Pasword and Hiding a Worksheet

    I am sending a Excel book to some clients and was wondering if it is possible to password protect a hidden worksheet. I would like to have 4 worksheets available, but only one visible. I will give specific clients passwords to open one of the three hidden worksheets. How can this be setup? I...
  3. crystal0streaks

    Combo boxes Linking to Other Data

    I'm still new to access and I've tried many things to automatically input data into specific columns and it hasn't worked. In my main table, I have combo boxes for [MODEL#] and I would like to have the combo box link to the [PRICE] column so it will insert the appropriate price. I have the...
  4. crystal0streaks

    Combo boxes and Lookup Tables

    I have a table that has combo boxes of [MODEL#] and [PRICE] how do I make it so when I select a Model# the appropriate price is automatically inserted in the [PRICE] column? I've been told I should do this with a Lookup Table, but when I use the wizard it creates a combo box like the one I...
  5. crystal0streaks

    SQL based on query

    I have a query with [MODEL#] and [PRICE] is there a way to make it automatically select the appropriate price for individual models? I'm assuming this can be done in SQL? -crys
  6. crystal0streaks

    creating an if-than statement that will take from 2 fields

    My employer wants to have a Due Date automatically inputted if the information in the field [TERMS] is "NET 30 DAYS" he wants it to add 30 days to the date in the [CURRENT_DATE] field. We know we have to make as an Expression, we just don't quite know how. Any help at all will be greatly...

Part and Inventory Search

Back
Top