A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Popup Form Help Needed Please.



 
 
Thread Tools Display Modes
  #1  
Old November 2nd, 2006, 02:31 PM posted to microsoft.public.access.forms
Terry DeJournett
external usenet poster
 
Posts: 12
Default Popup Form Help Needed Please.

Does anyone know of a way to make a custom message box (a small form that I
have created) to pop up at a specific time each day at 4:00 pm?

Any help or suggestions would be greatly appreciated.

Terry


  #2  
Old November 2nd, 2006, 03:10 PM posted to microsoft.public.access.forms
Klatuu
external usenet poster
 
Posts: 7,074
Default Popup Form Help Needed Please.

Your application will have to have a form that stays open as long as the
application is open. Then set a TimerInterval for the form and use the
form's timer event to check the current time and open the form at the desired
time.

"Terry DeJournett" wrote:

Does anyone know of a way to make a custom message box (a small form that I
have created) to pop up at a specific time each day at 4:00 pm?

Any help or suggestions would be greatly appreciated.

Terry



  #3  
Old November 2nd, 2006, 03:22 PM posted to microsoft.public.access.forms
Terry DeJournett
external usenet poster
 
Posts: 12
Default Popup Form Help Needed Please.

I'm not quite sure how to write this code. Do you by any chance have any
example code that you could share?

Thanks,
Terry

"Klatuu" wrote in message
...
Your application will have to have a form that stays open as long as the
application is open. Then set a TimerInterval for the form and use the
form's timer event to check the current time and open the form at the
desired
time.

"Terry DeJournett" wrote:

Does anyone know of a way to make a custom message box (a small form that
I
have created) to pop up at a specific time each day at 4:00 pm?

Any help or suggestions would be greatly appreciated.

Terry





  #4  
Old November 2nd, 2006, 03:39 PM posted to microsoft.public.access.forms
Klatuu
external usenet poster
 
Posts: 7,074
Default Popup Form Help Needed Please.

Private Sub Form_Timer()
Static blnTimeGoneBy As Boolean

If Time = #9:34:00 AM# And Not blnTimeGoneBy Then
blnTimeGoneBy = True
'Open your form here
End If
End Sub

Set the TimerInterval in design view of the form. the interval is
milliseconds, so each second = 1000
each minute = 60000

"Klatuu" wrote:

Your application will have to have a form that stays open as long as the
application is open. Then set a TimerInterval for the form and use the
form's timer event to check the current time and open the form at the desired
time.

"Terry DeJournett" wrote:

Does anyone know of a way to make a custom message box (a small form that I
have created) to pop up at a specific time each day at 4:00 pm?

Any help or suggestions would be greatly appreciated.

Terry



  #5  
Old November 2nd, 2006, 03:52 PM posted to microsoft.public.access.forms
Terry DeJournett
external usenet poster
 
Posts: 12
Default Popup Form Help Needed Please.

Thank you very much! I'm learning so much from this newsgroup. I really
appreciate everyones time in helping me learn more programming in Access.
Thanks again.

Terry

"Klatuu" wrote in message
...
Private Sub Form_Timer()
Static blnTimeGoneBy As Boolean

If Time = #9:34:00 AM# And Not blnTimeGoneBy Then
blnTimeGoneBy = True
'Open your form here
End If
End Sub

Set the TimerInterval in design view of the form. the interval is
milliseconds, so each second = 1000
each minute = 60000

"Klatuu" wrote:

Your application will have to have a form that stays open as long as the
application is open. Then set a TimerInterval for the form and use the
form's timer event to check the current time and open the form at the
desired
time.

"Terry DeJournett" wrote:

Does anyone know of a way to make a custom message box (a small form
that I
have created) to pop up at a specific time each day at 4:00 pm?

Any help or suggestions would be greatly appreciated.

Terry





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:59 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.