Message boxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 14 Mar 2007 21:52 GMT

Is there any way to close open message boxes programmatically before forcing
a database to quit?

Thanks in advance
Dave

Reply to this Message

Ofer Cohen - 14 Mar 2007 22:58 GMT

You can create a Form that looks like a message box, open it with the
message, and use the form timer to close it.

check this link on how to create a form that can replace a message box

http://www.applecore99.com/dld/dld002.asp

Signature

Good Luck
BS"D

> Is there any way to close open message boxes programmatically before forcing
> a database to quit?
>
> Thanks in advance
> Dave

Reply to this Message

Dave - 14 Mar 2007 23:38 GMT

> You can create a Form that looks like a message box, open it with the
> message, and use the form timer to close it.
>
> check this link on how to create a form that can replace a message box
>
> http://www.applecore99.com/dld/dld002.asp

Replacing all of Access's notifications along with all the existing custom
message boxes with custom made forms would be a fairly large task. I just
want a hidden form to check for any system messages and close them before
forcing a shut down. At the moment, system messages left open during a forced
shutdown are creating lost instances of Access which can only be terminated
in Task Manager.

Reply to this Message

Keith Wilby - 15 Mar 2007 11:44 GMT

> Replacing all of Access's notifications along with all the existing custom
> message boxes with custom made forms would be a fairly large task. I just
[quoted text clipped - 4 lines]
> terminated
> in Task Manager.

No offence Dave but I have to say I'm at a loss to imagine a scenario where
a message box would pop up without user-interaction. Perhaps you could
elaborate on the circumstances and someone might be able to suggest a
workaround. Maybe it's a question of educating users about the perils of
leaving their machine with a message box unchecked.

Regards,
Keith.
www.keithwilby.com

Reply to this Message

Dave - 15 Mar 2007 23:10 GMT

> No offence Dave but I have to say I'm at a loss to imagine a scenario where
> a message box would pop up without user-interaction. Perhaps you could
[quoted text clipped - 5 lines]
> Keith.
> www.keithwilby.com

Hi Keith,
No offence taken. Like you, I'm at a loss also.
In a nutshell, our environment allows for very basic data entry on the shop
floor by the shop staff : 100+ of them logging in to dozens of terminals.
They're great at their given trade, but their understanding of IT systems is
low. As a result, they will wander off without clicking 'Yes', 'No' or
'Cancel' when a prompt is on the screen. They've been instructed to address
all such prompts, but it's still a requirement that the system checks for
these message boxes first before forcing a shutdown.
Hopefully someone has a good solution.
Thanks
Dave

Reply to this Message

Keith Wilby - 16 Mar 2007 09:36 GMT

>> Maybe it's a question of educating users about the perils of
>> leaving their machine with a message box unchecked.
[quoted text clipped - 5 lines]
> these message boxes first before forcing a shutdown.
> Hopefully someone has a good solution.

Hmm ... AIUI message boxes of a modal nature which means that code execution
is suspended until the box is dismissed so I *think* a coded solution is a
no-no.

Keith.

Reply to this Message

paddyIE - 16 Mar 2007 12:50 GMT

Dave,
Do a search in this forum for "inactivity". You will see three postings for
detecting user inactivity. Assuming your app has a FE and BE, you could check
for "inactivity" on each " terminal" and quit the app. This might be
something you could try.

Signature

Patrick

> > No offence Dave but I have to say I'm at a loss to imagine a scenario where
> > a message box would pop up without user-interaction. Perhaps you could
[quoted text clipped - 18 lines]
> Thanks
> Dave

Reply to this Message

Dave - 18 Mar 2007 23:09 GMT

> Dave,
> Do a search in this forum for "inactivity". You will see three postings for

Hi Patrick,
Thanks for your reply.
My system does employ BE/FE and already has a user inactivity process. This
is what triggers the forced shutdown mentioned above. No user inactivity
process that I've seen so far handles closing message boxes.
Thanks for your link, but it produces the same error I'm getting now. To
reproduce what I'm seeing, download the file from your link and do the
following:
Open frmLogOffafterNonuse in design view.
Open the Properties for the first text box and enter this for the On Got
Focus event:
Private Sub Text6_GotFocus()
Msgbox "Sample message to emulate problem"
Call UpdateActivity
End Sub

Change to form's TimerInterval property to a smaller interval to speed
things up a little if you like.

Now open the form and click in the first text box. When the message box
appears, DON'T close it. Allow it to sit on the screen until the shutdown
process kicks in. You'll now see that you've got an instance of Access in
your task bar that can't be closed. I'm using A97 on Win2K and it happens
every time a message box is left unattended. Only way to close it is through
Task Manager. That's not so bad, unless Group Policy disables Task Manager,
then it's a bigger problem.
Dave

Reply to this Message

paddyIE - 19 Mar 2007 13:53 GMT

Dave,

Sorry it didn't help. To deep for me(TDFM). Good luck.

Signature

Patrick

> > Dave,
> > Do a search in this forum for "inactivity". You will see three postings for
[quoted text clipped - 26 lines]
> then it's a bigger problem.
> Dave

Reply to this Message