How do set a pop-up reminder and auto execute it?

Discuss the database features
Post Reply
stanmarsh
Posts: 30
Joined: Sun Dec 20, 2009 10:25 am

How do set a pop-up reminder and auto execute it?

Post by stanmarsh »

Hello everyone!

I'm trying to create a pop-up reminder that would auto execute the reminder Form when the database start, i was able to do it in Access and now i would like to create the same thing in Base.

The reminder is a query of delivery dates, it will just show the list of deliveries for the current date in a Form. In access, the code is Date(). What is the equivalent of Date() in Base?

The auto execute part is the hard one, luckily i was able to find it here - http://www.databasedev.co.uk/reminders.html, i just replaced some strings and was able to make it work. Is there an equivalent to Base?

Code: Select all

Private Sub Form_Load()

'On Load of the switchboard check Jobs table for any uncompleted jobs

Dim intStore As Integer

'Count of uncomplete jobs that are past the Expected Completion Date
intStore = DCount("[JobNumber]", "[tblJobs]",
"[ExpectedCompletionDate] <=Now() AND [Complete] =0")

'If count of uncomplete jobs is zero display switchboard
'Else display message box detailing amount of jobs
'and give the user the option as to whether to view these or not.
    If intStore = 0 Then
            Exit Sub
                Else
                    If MsgBox("There are " & intStore & " uncompleted jobs" & _
                    vbCrLf & vbCrLf & "Would you like to see these now?", _
                    vbYesNo, "You Have Uncomplete Jobs...") = vbYes Then
                    DoCmd.Minimize
                    DoCmd.OpenForm "frmReminders", acNormal
                Else
            Exit Sub
        End If
    End If
End Sub
cheers
OpenOffice 3.1 on Windows XP
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: How do set a pop-up reminder and auto execute it?

Post by Villeroy »

Base is by far more simplistic than Access while the API is so much more complicated to use. It takes a multitude of time and effort to implement things like this in Base. I would add a subform at the bottom of the working form which shows the records of the remaining tasks or no records.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
stanmarsh
Posts: 30
Joined: Sun Dec 20, 2009 10:25 am

Re: How do set a pop-up reminder and auto execute it?

Post by stanmarsh »

Thanks Villeroy for the suggestion, do you know the equivalence to Date() in Base?

thanks
OpenOffice 3.1 on Windows XP
Anthony
Posts: 1
Joined: Sat Feb 28, 2009 4:55 pm

Re: How do set a pop-up reminder and auto execute it?

Post by Anthony »

Hi Stanmarsh,

Here is the suggestion...
http://www.linux-magazine.com/w3/issue/ ... kspace.pdf
OOo 3.0.X on MS Windows Vista
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: How do set a pop-up reminder and auto execute it?

Post by Villeroy »

Anthony wrote:Hi Stanmarsh,

Here is the suggestion...
http://www.linux-magazine.com/w3/issue/ ... kspace.pdf
Wow! :super:
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
stanmarsh
Posts: 30
Joined: Sun Dec 20, 2009 10:25 am

Re: How do set a pop-up reminder and auto execute it?

Post by stanmarsh »

Thanks Anthony! base is giving me headache. :crazy:
OpenOffice 3.1 on Windows XP
Post Reply