Pop ups

[Tom]

Hi all,
How can you create a popup form reminder? (in general)

Thanks,
Tom

 

[Larry Linson]

Hi all,
How can you create a popup form reminder? (in general)

In general, use the Timer property and event of a Form to check for the
condition that triggers the reminder, then from code, use DoCmd.OpenForm to
open the reminder... use the Timer event of the reminder form, if you wish,
to close that form after an appropriate time.

Larry Linson
Microsoft Access MVP

 

[Billy Yao [MSFT]]

Hi Tom,

Thank you for using MSDN Newsgroup!

How is this issue going on your side currently? Does the Larry's suggestion helpful?

I'm just writing this short message to ask for the feedback if you are delighted with the support
provided to you. Please feel free to leave a short message by posting it in the newsgroup
letting us know if we help solve the problem or you need further assistance.

I'm not sure what exactly way you'd like to create the popup form reminder. You can follow
Larry's advice using the Timer Property and Event to create a reminder. Furthermore, if you'd
like to create the reminder when opening the database, you can try the code below (just a
sample).

The following code is used to create a reminder popup screen. In your database startup form,
include this code in the Form_Load or _Open
event to open your reminder form.

'''''''''''''''''''''''''''''''''''''''
Dim dbs as Database
Dim rst As Recordset
Dim sqlCheck as String

Set dbs = CurrentDB

sqlCheck = "......................­" ''''' Check Condition String

Set rst = dbs.Openrecordset(sqlCheck)

If rst.Recordcount > 0 Then
DoCmd.OpenForm "frmReminderForm"
Forms!frmReminderForm.txtMessage = rst!txtMessage
End If

rst.Close
Set rst = Nothing
dbs.Close
Set dbs = Nothing
'''''''''''''''''''''''''''''''

If there is anything more I can do to assist you, please feel free to post it in the group. Thanks
again for using MSDN Newsgroup!

Best regards,

Billy Yao
Microsoft Online Support