I just whipped up a really simple little VB program to try something. What I have is a Report table sitting on an SQL server. People submit a request for a report, and I'm making a status piece so they can see what the queue looks like. So it is currently just doing select * from Requests order by priority
No problems, works like a champ. What I would like to do though, is somehow designate which requests in the queue belong to the person that is looking at the list.
i.e. the Requests table has a "ClientName" field and if their NT login matches this, then display that whole record with red text...or something like that. Just so they can glance at it and know "Oh my first request is third in line, and my 2nd request is last in the queue"
Am I using the wrong control for this? The DBList seems really sort of cut and dry simple without too much flexibility. If I can do it with this, than great, but if not let me know how and what I should be using instead. Thanks!