Pop ups

  • Thread starter Thread starter Tom
  • Start date Start date
Tom said:
Hi all,
How can you create a popup form reminder? (in general)
Click to expand...

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
 
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
 
Back
Top