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 Chriss Miller 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. rich001

    Form code

    I am pulling my hair out on this one. Everytime I use the combo box I get "The object dosen't contain the automation object POrderDetails". The main form is POrder and the subform is POrderDetails. The code below is attached to the after update event of a combo box setting the price of an item...
  2. rich001

    Access Query

    I am trying to count the number of columns in one query and select all records with a (-1) in all columns.
  3. rich001

    Access Query

    I am writing a query with 6 tables being included in it. All tables are check boxes except for the key. Is there an easy way to count all columns in the tables and display all records that = yes with out defining "yes" in each field?
  4. rich001

    Updateable query

    I figured it out using code and a login form instead of a query. I just got this working. Thanks Private Sub txtSSN_AfterUpdate() Dim strDuty As String strDuty = DLookup("DutySection", "Personnel", "SSN = '" _ & Me!txtSSN & "'") If strDuty = "Admin" Or strDuty = "Support" Then...
  5. rich001

    Updateable query

    The attached is giving me fits. Is there any way to make this query updateable and still do the some thing? I need to beable to view [Expr1] because it validates a field in my table. SELECT Personnel.*, (SELECT DutySection FROM Personnel WHERE SSN=[What is your SSN]) AS Epr1, * FROM Personnel...
  6. rich001

    List box

    I am trying to refine this query with a list box to select the appropiate result. the form is [emplist] and the box is [choosen](table it sends data to is tblChoose) What is the easiest way to do this filtering the fields StatusA, B, and C? ****NOTE: I DID NOT CREATE THIS MESS I AM JUST TRYING...
  7. rich001

    Filter/Display records

    That is it thanks for the help. I have been trying this for a couple of days with no luck but it works like a champ now.
  8. rich001

    Filter/Display records

    What I am trying to do is display all records if after entering the SSN the [DutySection] equals “Admin or “Support”
  9. rich001

    Filter/Display records

    I am trying to create a query that asks the user to input [SSN] if the [SSN] matches "Admin" or "Support" in the DutySection field display all records if not then only display the selected [SSN]. I don't remember how to enter an if then statement that will override the select query if a the...

Part and Inventory Search

Back
Top