I use a timer form, With timer set to 1800000 (30 minutes), to open a form every 30 minutes to check for new work orders.
I need the form to open on top of any application that is currently open on my screen.
If I remember correctly, the form has to be set as "Model", but I don't remember how to do that.
TIA
---Start Code---
Private Sub Form_Timer()
RunCommand acCmdAppMaximize
DoCmd.OpenForm "WorkOdersAwaitingApproval"
End Sub
---End Code---
I need the form to open on top of any application that is currently open on my screen.
If I remember correctly, the form has to be set as "Model", but I don't remember how to do that.
TIA
---Start Code---
Private Sub Form_Timer()
RunCommand acCmdAppMaximize
DoCmd.OpenForm "WorkOdersAwaitingApproval"
End Sub
---End Code---