timer

[CaveMan]

Hello all,
My question concerns installing a timer in VB in MS Excel 2002.
I have designed a database that will be used by 150 to 200 individuals
on a network. If the database is left open at one location it can't
be used elsewhere.
I have found the vb code for a timer, but I would like the timer to
wait a specific amount of time, then a "yes/no" message box appears
with a question concerning keeping the database open, and if no
response is given within 60 seconds, close and save the database.

Curtis

 

[onedaywhen]

Take a look at Excel's OnTime method. Otherwise, use a Windows timer.
Chip Pearson has a page on his site about both, IIRC.

BTW, check your data provider doesn't already have functionality for
this kind of timeout behaviour. And if you are using ADO you may get
some mileage out of certain properties of the Connection object such
as ConnectionTimeout, CommandTimeout.

(Please don't tell me you are using an Excel workbook as a data source
for 150+ users...)