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

Discuss the database features

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

Postby stanmarsh » Tue Dec 22, 2009 8:35 am

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   Expand viewCollapse view
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
stanmarsh
 
Posts: 30
Joined: Sun Dec 20, 2009 10:25 am

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

Postby Villeroy » Tue Dec 22, 2009 4:47 pm

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 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17274
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Postby stanmarsh » Wed Dec 23, 2009 2:25 am

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

thanks
OpenOffice 3.1 on Windows XP
stanmarsh
 
Posts: 30
Joined: Sun Dec 20, 2009 10:25 am

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

Postby Anthony » Fri Dec 25, 2009 6:51 am

Hi Stanmarsh,

Here is the suggestion...
http://www.linux-magazine.com/w3/issue/ ... kspace.pdf
OOo 3.0.X on MS Windows Vista
Anthony
 
Posts: 1
Joined: Sat Feb 28, 2009 4:55 pm

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

Postby Villeroy » Fri Dec 25, 2009 11:49 am

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 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17274
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Postby stanmarsh » Sun Dec 27, 2009 2:41 am

Thanks Anthony! base is giving me headache. :crazy:
OpenOffice 3.1 on Windows XP
stanmarsh
 
Posts: 30
Joined: Sun Dec 20, 2009 10:25 am


Return to Base

Who is online

Users browsing this forum: No registered users and 8 guests