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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|