Changing PopUp Value using VBA

[geraldcor]

I have a form that will quit Access at a certain time so that A backup script can run and maintenance can be performed. The form uses the timer event and displays a countdown in 10 second increments (the timer increment). I want the user to be able to finish whatever work they are working on and then exit on their own or just let Access quit automatically. The problem is that every 10 seconds the form pops up over the other forms where they are working, making it very unusable. I set the main forms that they use to PopUp = Yes. I also set the warning form to PopUp = Yes so that it will actually show up rather than be hidden by the front most form. My plan was to have a button that they could click that would change the PopUp value to false using VBA so the form could be sent to the back. I get runtime error 2448 You can't assign a value to this object. Is this true? I thought you could change any value using VBA. I used the syntax Me.PopUp = False and Forms!frmAppShutDownWarn.PopUp = False.

Anyone know how to change the popup value or else a way to keep that form down?

Sorry for the long post, just trying to add all the details

Greg

 

[geraldcor]

Given Up

Ok. So I've given up on that idea but only because I discovered Snarl. This is a customizable messaging service for windows that works with VB. It is based on Growl for Mac. It solved all my problems. I would still like an answer as to why I couldn't change the popup value, but I also wanted to spread the good news.

Greg