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. mguy27

    input string as filter criteria in Excel

    from what I've seen so far, it looks like the max is 1,048,576 rows....kind of a random number if you ask me. Thanks for the help!!! -Taylor
  2. mguy27

    input string as filter criteria in Excel

    So I have a list of data that is over 1 million rows long. the headers of the 5 colums are as follow: Local Date Local Time Host Date Host Time Journal Message What I need to do is cut down the size of the data to just what I need to look at. And I'm building this for a supervisor who...
  3. mguy27

    Excel: Assign [COUNTIF result] a variable

    Skip, on tha Query, I couldn't get it to work just right, but a co-worker suggested making it simpler and doing a "find", so I was trying an alternate method. John, that method was perfect, and yet WAY to easy. Thanks. gotta love the KISS principle. And thank you both for helping me with...
  4. mguy27

    Excel: Assign [COUNTIF result] a variable

    Ultimately I am trying to take a huge amount of data (9500-10000 rows with 6-7 colums) and do a search for text including the words "Violated Door Alarm". I then want to take the rows which contain that text in the description, copy and paste them into another workbook in Excel. I have created a...
  5. mguy27

    VB in Excel: IF [text] is in a cell THEN...

    I posted it here again at your suggestion, and I will try that Query out and see how it goes. Thanks! -Taylor
  6. mguy27

    VB in Excel: IF [text] is in a cell THEN...

    I'm kinda new to this VB in Excel thing, so bear with me on this one. We have a program here at our facility which monitors thousands of alarm points. Activity of these alarm points can be exported to an excell file. An entry would look something like this: Col. A Col. B Col. C Col. D...
  7. mguy27

    VB in Excel

    I'm kinda new to this VB in Excel thing, so bear with me on this one. We have a program here at our facility which monitors thousands of alarm points. Activity of these alarm points can be exported to an excell file. An entry would look something like this: Col. A Col. B Col. C Col. D...
  8. mguy27

    If/Then type autolookup

    Anyone have any ideas for me?
  9. mguy27

    If/Then type autolookup

    OK, breakthrough...sort of. The person the report needs to be sent to now shows up in the form automatically. I did this by creating a TextBox with a DLookup function as the ControlSource. Problem 1: It does not automatically update right away. I have to close the form, then reopen it, and then...
  10. mguy27

    If/Then type autolookup

    I forgot to mention that in my main table (where all the reports are entered and recorded) I already have a primary key, which is an autonumber assigned to each report. The autonumber is the only thing that makes each report in the main table unique from all the rest.
  11. mguy27

    If/Then type autolookup

    Ok TheAceMan1, I've read through the materials and feel much more acquainted with the program. Without knowing the terminology when I first did it, here's what my first attempt at my problem was: I have a table wherein I have a field (Building) that indicates a particular building. This field...
  12. mguy27

    If/Then type autolookup

    As an addendum (or possibly clarification, rather) to my previous post, I could say that I have a minimal understanding of the program, i.e. how forms, tables, queries, and reports all work together; designing each of the aforementioned; and some other bare basics. As for the "ins-and-outs", not...
  13. mguy27

    If/Then type autolookup

    TheAceMan1, thanks so much for your help, it's gotten me headed down the right path. The name of the table where we store our massive list of reports is called 'TR Reports 2007'. The field where we want the name of the supervisor to appear is called 'Send'. The name of the field in the form...
  14. mguy27

    If/Then type autolookup

    Background: I have written a small program to enter brief reports taken by people on various buildings in our complex. They are categorized by time, date, building, and room number. We then build a report from these entered reports and email them on to the corresponding building supervisors. We...

Part and Inventory Search

Back
Top