Recent content by weeblebiker

  1. W

    Testing data in batches, entering in table directly or create a "pseudo" table?

    Re: Testing data in batches, entering in table directly or create a "pseudo" table? The root issue is currently using only 1 sensor and testing a unit repeatedly instead of multiple sensors and testing a unit once. This involves a lot of time and moving back and forth by the testing tech. The...
  2. W

    Testing data in batches, entering in table directly or create a "pseudo" table?

    Re: Testing data in batches, entering in table directly or create a "pseudo" table? no one?:confused:
  3. W

    Testing data in batches, entering in table directly or create a "pseudo" table?

    Testing data in batches, entering in table directly or create a "pseudo" table? I know entering info into the table directly is a no-no, but that is what I want to do: we do testing and are currently using a excel sheet. We test 6 to 12 units at a time. all the units are run through each test...
  4. W

    Pass-Through variable

    may be oversimplified but what about an unbound field for input and running re query on lost focus? http://www.access-programmers.co.uk/forums/showthread.php?t=244719
  5. W

    query to find any of 322 serial numbers in excel column in access db

    Hi, I've been asked to find repair history in my access DB for any unit made in the past 10 years with a specific output range from an excel sheet and see if they have come back for repair in my access db. I have linked the excel sheet to acces and have a query to generate a list of serial...
  6. W

    query code for contains (Like?) term typed in query pop up window

    thanks for the clarification of the logic
  7. W

    query code for contains (Like?) term typed in query pop up window

    that's the ticket! I was trying derivatives of WHERE (([XRS-3 repair].[Serial #])Like "*([Forms]![XRS-3 Repair Summary by Serial #]![Serial #])*"); Thanks!
  8. W

    query code for contains (Like?) term typed in query pop up window

    I have a query set up below which when launched, a pop up field appears to type in the serial number and returns all the repair entries containing that serial number. I want it to be able to return any serial numbers that contain a partial string in the pop up field ei: type "13" in the pop up...
  9. W

    (2007) easiest way to include query criteria in a query form

    can you post up your code?
  10. W

    (2007) easiest way to include query criteria in a query form

    then you did something wrong? the key is setting the the query to look at the unbound field on the form or report for the select criteria and setting the unbound field to "requery" on lost focus.
  11. W

    summarizing query of Date Diff query running really slow

    so sometimes walking away fixes things. it now runs under 10 seconds with a 2 year date range. slow, but acceptable, I suspect I wrote enough garbage code during the creation of the topic queries, that the back end db and server needed to be restarted to clear things out.
  12. W

    IIF statement

    you have 4 "(" and 5")"
  13. W

    summarizing query of Date Diff query running really slow

    Thanks, I'll work on it and get back in the next day or two, have a wires melting issue to help figure out first. Oh if only everything could be fixed at a keyboard,,,,,
  14. W

    summarizing query of Date Diff query running really slow

    what are my "block sizes"?
  15. W

    summarizing query of Date Diff query running really slow

    Is this what I want to do? (method 3) http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_9753-Creating-and-using-Temporary-Tables-in-Microsoft-Access.html
See more
Back
Top Bottom