Tickler Form 1

[deadhead7]

I need to build a tickler form that will popup and remind a user to do something. For instance: if the are logged on to a database and the form was set to remind them on feb 20th to do something, then I would like a form to popup and remind the user they need to do something. Can this be done.

 

[DreamerZ]

You could build in a check on Form load that looks at the current date:

myDate=Date
If myDate=Date(2/20/04) then
 (open form, pop up msg box, etc).
End if

You might want to look at different formatting for Date() to make sure the system date that Date uses is what you have in the check.

Hope that helps.


DreamerZ
simplesolutions@prodigy.net
[ignore]

http://www.geocities.com/simplesolutions@prodigy.net

[/ignore]

 

[deadhead7]

Where would I put this code?

 

[DreamerZ]

If you go into the properties of the form, select the Event Procedure for the OnOpen function. Click the ... to the right of the function and the VBA screen will open.

You should see something like:

Private Sub Form_Open(Cancel As Integer)
(place the code here)
End Sub

What this does is everytime the form is open it runs the code. So, if myDate = 2/20/04 then the code is run. If it doesn't then the Sub ends. You might want to read up on the Date Function for more information on it's format.
Your code could look something like this:

    myDate = Date
    If myDate = "2/20/2004" Then
        MsgBox "Date checked"
    Else: MsgBox "Wrong Date"
    End If

Camaris: Your's can be done too. Take a look at the DatePart function for information on pulling out a specific day. I think Monday is equivalent to Day=2. Your code could look like this:

    If DatePart("w", Date) = 2 Then
        MsgBox "Date checked"
    Else: MsgBox "Wrong Date"
    End If

The "w" stands for the Interval Weekday.

Hope that helps.


DreamerZ
simplesolutions@prodigy.net
[ignore]

http://www.geocities.com/simplesolutions@prodigy.net

[/ignore]