How do I maximise MS Access - the application

[StuKregor]

I have a form with a timer that reminds users every half an hour to enter their data.

At the moment a msgbox comes up which they click OK. (when access is minimised the msgbox comes up flashing on the task bar)

When they click OK I would like to maximise Access, to save them having to then click it on the windows task bar.

Any ideas?

 

[tlbroadbent]

Add the following code to a VB module. Thanks to Michael Kaplan for posting this in the comp.databases.ms-access Newsgroup. In the timer event of the form, just before the message box, add the line Call MaximizeAccess.

Private Declare Function ShowWindow Lib "user32" _
(ByVal hWnd As Long, ByVal nCmdShow As Long) As Long

Private Const SW_MAXIMIZE As Long = 3

Function MaximizeAccess()
MaximizeAccess = ShowWindow(hWndAccessApp, SW_MAXIMIZE)
End Function
Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes

 

[StuKregor]

Thanks Terry, thats exactly what I needed!