SteveAJones71

Again, I'm another who didn't receive the e-mail

Another way to create a handler dynamically for each control you create, for example: AddHandler [your control].click, AddressOf Sub_do_my_click But as I'm sure you've guessed there are many ways to skin a cat!

Yeah the USB should connect to their laptops. Are the projectors ceiling mounted though, you may need USB extenders to connect if they are?

The Epson EMP-S4 features 'instant power off' which means that it should be able to fairly saely turned off instantly via a timer switch (though please verify before trying!), also this model features a USB port which allows the use of ESC/VP21 commands to 'remotely', amongst other things, turn the projector off. A little software utility I have wrote enables at set times for a messge to be displayed to the user to gently remind them to turn the projector off; I have also considered the possibility of writing a screen saver utility that would utilise the ESC/VP21 commands to automatically shutdown the projectors during extended 'non-use' periods.

So what make and model is it? I know many newer models allow for an 'instant off' thus making your idea of the timer switch more than possible.

If you are making changes then you should not be INSERTing but UPDATEing the records, there are fairly basic ways to iterate through your recordset finding just the records that have changed and then you can manually update the relevant entries. During this process you can also find new records and write them to the database via a slightly different method. If it help I'll be willing to have a look at the code for you.