[AccessD] Database that stays in background

[Stuart McLachlan]

Here's the core to minimize/restore your application based on a Timer on a form which is set 
as the Default Form on statrup.   Based on this, a few conditionals should meet all of your 
requirements easily:

Option Compare Database
Option Explicit
Dim flg As Boolean
Private Sub Form_Timer()
If flg = 0 Then
flg = 1
DoCmd.RunCommand acCmdAppMinimize
Else
flg = 0
DoCmd.RunCommand acCmdAppRestore
End If
End Sub


On 12 Sep 2015 at 1:58, Bill Benson wrote:

> I am creating a timekeeper database application that helps me track
> time in two hour increments throughout the work day. I am wanting this
> database to pop up and ask me what I am doing every 2 hours. If I do
> not answer after 10 minutes for example if I am away from my computer
> I would like the database to be minimized again and not pop up until
> the next two hour.
> 
> I might also like the database to shutdown at the end of the work day
> for example 8 p.m. because I frequently leave my computer on all day.
> On the other hand it doesn't really matter if it pops up every 2 hours
> when I'm not there as long as it goes away again. Is something like
> this doable? -- AccessD mailing list AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd Website:
> http://www.databaseadvisors.com
>