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 Rhinorhino 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. robbro

    monitor switches on and off

    ya... get a new one... but seriously, first thing you should do is check to make sure the cables are hooked up nice and tight... i've seen two monitors that have done this and all they needed was a bit of cleaning of the video cable leads... plug it back in (tight!) and they worked fine... i...
  2. robbro

    Simple IIf statement Problem involving multiple combo boxes Pt. 2

    Ok, I've now shortened the statement and updated the "or" operand properly to: =IIf([Equip Status]="N/A" Or [Equip Status]="Accepted",[Review Status]="Reviewed",[Review Status]="Not Reviewed") Now I dont get an error, but my "Review...
  3. robbro

    Simple IIf statement Problem involving multiple combo boxes

    What I want to do is this: On my form, (only one exists) when any one of the 3 combo boxes (each is referanced to a value list) are updated (On Update) I want another box to automatically update. I've placed this event procedure into the "On Update" property of each box: =IIf(([Equip...
  4. robbro

    Criteria Problem in Query

    Thanks a bunch. That worked excellently. Now my only problem is when the location field is left blank. I would like these to display in the "all" case, but they are ignored. I've taken a big step though, Thanks.
  5. robbro

    Criteria Problem in Query

    Im trying to specify a criteria that allows me to input either "A", "B", "C" or "All". ("All" meaning A, B, and C) If I use [Enter A, B, or C], I can run the query specific to each individual location, but I havent been able to come up with a...

Part and Inventory Search

Back
Top