The SQL SELECT dbtask.TaskNum, dbtask was added the the Data1 (CIGARS) bar in the middle. "RecordSource"

I know this is asking to much. Could someone build this and send it to me. I am getting lost in where to put things in. All I wanted to do was have the screen i built refreashed every x number of seconds.

At least something good came out of this. They have agreed to send me to a class to learn basic VB next month.

I would gladly accomplish this task for you, however, I don't have access to SQL. Maybe someone else here does?

Using MS Office 2003 for this right now. Once we get the Network Platform working we will migrate to SQL.

Thanks

Alright, It's not "pretty" but it does what it's supposed to. You'll need to change the connection string to contain the path to the database, instead of "c:\" as I have it now. Let me know the results, and we can move on to the next phase.

http://www.aftermath.net/~coma/status/

Got it working with a few changes (Path). This is almost like I wanted it. I want to work with it some more. When I pull it up to see if I can show more records on the display. The Gray part where the Timer/Show all Records is at... streaches more and more while the top part opens just a little.

But that is something I want to learn how to fix. There things I want to see is if I can change the Fonts sizes, the Hight & Width of the cells in the Grid.

Thank you for ALL the help. And I hope to start working on the rest of the Application I want to rebuild around this. Taking the MS Outlook forms out of there and create them using VB.

And like I said when we spoke, Any assistance beyond this that you may need, just let me know. You have my e-mail, and I'd be glad to assist you further... I'm looking forward to helping you with the server app. A little tip, it's in the form resize event

Question on this utility. When I run the utility, I set it to poll every 30 seconds. Is the dbbase open all the time this runs or only every 30 seconds when it polls? Also, does it lock the db so nobody can access it during these periods?

Will I started to figure out how to use the Status Monitor and started to make some changes, Font style, Font size, Colmn width and a few other things.

Now I want to get ambitous. The Select statement uses dbtask.group to limit the display to "C". Is there a way that I can change the selections?
"SC", "T", "U', "GT", "LT", "M". To either just one the them or to several selections? Hopefull, with a field that I can change anytime from the utility?

' /* Actually Open the Table With The Aforementioned Criteria */
MyMainRecordset.Open "SELECT dbtask.TaskNum, dbtask.txtstatus, dbtask.Operator1, dbtask.Jobtype, dbtask.Reqby, dbtask.Sjob FROM dbtask WHERE (((dbtask.txtstatus)<>" & Chr(34) & "Finished" & Chr(34) & ") AND ((dbtask.group)=" & Chr(34) & "C" & Chr(34) & "));", MyConnection, adOpenStatic, adLockOptimistic

Once, I get this finished I am starting to work on Forms. Using a menu system, I select a form, "PC Conversion" and it displays a blank form. As a User I fill in all the fields and submit the request. What this will do is take the information and update an MS Access database using a "Job Number" to id each request.

Yeah, Changing The Query shouldn't be a big deal at all. I'm not sure how you want to go about doing it... I would suggest using a bunch of checkbox's and set it up with the checkbox's. In the timer event, search for which checkbox's are checked, and then modify the query string to fit the requested action. If you send me what you've got, I'll help you to modify it into something a little more versatile.

I included a zip of everthing I have. In the jpg I show at the bottom what I want to be to view, either one or several at a time.

BTW, the blank area at the bottom - above the Timer button - how do I get rid of the blank area?