Search results for query: *

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

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

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

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

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

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

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

Anyone have any ideas for me?

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

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.

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

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

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

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