Question 1
How would I determine if the Now() is X Date but before 8 am

ie.

SELECT EventID FROM Event WHERE Now() = Today AND Now() < 8am;



--------------------------
Question 2

Is it possible to keep my VB project updated on some sort of timer without lagging the program.

My database has over 2000 contacts and I want to be able to autoupdate the treeview I have that has all the contacts in their vaious subgroups updated semi-regularly without lagging the server and/or program.

When I first log on, connect to the database and then select all the contact it takes a good 10 seconds.