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 John Tel 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: *

  • Users: CCRT
  • Content: Threads
  • Order by date
  1. CCRT

    Passing "ALL" or "*" from Combo Box to Query?

    I'm trying to add "*" to a combo box and then pass it to a query. to select all records. I've used faq702-4538 as best I can but cannot get it to query without error. Here is the SQL for the Combo Box (This works as it adds the "*" to the combo box) SELECT qryComponentNumber.ComponentNumber...
  2. CCRT

    Multiple Combo Box Values Won't Sum Unless All Are Populated

    I have 6 combo boxes on a form (cbodd1, cbodd2.......cbodd6) I have a text box "Sec1Sum" with this expression =([cbodd6]+[cbodd5]+[cbodd4]+[cbodd3]+[cbodd2]+[cbodd1]) The problem is if one or more of the combo boxes are not populated the "Sec1Sum" remains blank. I've tried using the Iff...
  3. CCRT

    Time Calculation Days & Hours

    I'm trying to figure out why the first record returns a value of 2 days given the start and end times are less than 7 hours apart? Additionally, Is there an easy way to caluculate the exact hours? Fuction used in query results below: ComplaintSentDate CustContactedDate ResponseTimeDays...
  4. CCRT

    Enable after Update from Calendar

    I can't seem to find the correct method to enable "Command8" "TextEndDate" is the field on the form that is pouplated by a calendar. I'm trying to make the Command8 object only available after the "TextEndDate" is populated. Thanks --Dave Private Sub Form_Load()...
  5. CCRT

    Synchronizing Cascading Combo Boxes

    I have a form with 3 cascading combo boxes cboProblemMain cboProbLevel1 cboProbLevel2 It works fine unless the user decides to go back and change the cboProblemMain or cboProbLevel1 after initial input. Then they are out of sync. Is there anything I can add to my code that will refresh to a...
  6. CCRT

    Use of wildcard in "Case" statement

    The following snipet of code is from the second tier of 3 cascading combo boxes. Id like to know if there is a way to use a wildcard instead of typing each Case senerio. Example: Instead of listing each case "No Power", "No Display", "Error 1" for Electrical problems. I would add a prefix...
  7. CCRT

    Multiple "Not Equal" Criteria

    What is the correct format to declare a multiple “Not Equal” criteria? I’ve made a sample table that contains one field named “Color” I’m querying the field using criteria of Not "Blue" Or "Red" The query result only excludes the value “Blue” the value “Red” remained. What an I doing...

Part and Inventory Search

Back
Top