Nero
Shop smart, shop S-Mart
- Local time
- Today, 15:10
- Joined
- Jan 8, 2002
- Messages
- 217
Hi,
There is probably an easy answer to this but here goes..
I have a db that logs all calls to our IT dept.
I want to mail a report each week showing all calls not resolved.
I'm stuck trying to decide where is best to put the code for the event.
If the db was open 24/7 then I could use the on timer event or if the db was opened once a day I could use the on open event.
The problem is that the db could be open for 2 or 3 days at a time and then closed and reopened again.Or it could be opened 4 or 5 times a day.In both cases the events would not work.
Any suggestions would be gratefully received.
Kev.
There is probably an easy answer to this but here goes..
I have a db that logs all calls to our IT dept.
I want to mail a report each week showing all calls not resolved.
I'm stuck trying to decide where is best to put the code for the event.
If the db was open 24/7 then I could use the on timer event or if the db was opened once a day I could use the on open event.
The problem is that the db could be open for 2 or 3 days at a time and then closed and reopened again.Or it could be opened 4 or 5 times a day.In both cases the events would not work.
Any suggestions would be gratefully received.
Kev.
