I also un-checked all of the check boxes in the database's Startup options menu. I then added a button to the form so that the user can close the database, and another button so that the form can minimized. I made the minimize button so that when it was used, something would show-up on the taskbar and not on the desktop (above the Start button). I figured the users would get confused when they had multiple windows open and couldn't find the database on the taskbar. Here's the code I put in the minimize button's On Click event:
- Private Sub Image37_Click()
-
Dim stDocName As String
-
Dim stLinkCriteria As String
-
-
Me.Form.Modal = False
-
stDocName = "MinimizeForm"
-
DoCmd.OpenForm stDocName, , , stLinkCriteria
-
fSetAccessWindow (SW_SHOWMINIMIZED)
-
-
Exit_Image37_Click:
-
Exit Sub
-
-
Err_Image37_Click:
-
MsgBox Err.Description
-
Resume Exit_Image37_Click
-
-
End Sub
But once the form is minimized (I realize that it's really the main database window that's minimized, because that's what's shown on the taskbar), is there a way to maximize/re-open the form (just like it is when it's initially opened) without the main database showing-up? I tried, but I couldn't figure out a way to use SetAccessWindow (SW_HIDE) again.
So anyway, sorry for the long explanation, but just let me know if anyone has any questions or ideas.
Thanks.