Calendar with appointments and schedules

[blogmk]

Hi,

I'm creating a database for a sales team. They need a calendar where they can enter the reminder like "call peter at 10:30 on 11th july" and reminder like " call frederik on july12 at 12:30am,etc. And they need a popup when the reminder is due. Is this possible in access. Please let me know how to do this.Thanks a lot.

 

[blogmk]

How to develop a appointment calendar for multi user environment. Each person sees their appointment and a popup to the respective user if their appointment is due.Please can some one guide me in this.Thanks

 

[blogmk]

Searched the thread and found this link . "members.shaw.ca/glenk/access2000.html"
But the link doesnt exist any more.

 

[Valery]

I am also looking for something similar. I found the attached on the web. May be what you need. As for me, I need an appointment calendar for several nurses and their home appointments. Have not found anything that quite works yet.

 

[CJ_London]

need a popup when the reminder is due. Is this possible in access

Yes - you would need to make use of the form timer event and the form needs to be open (but can be minimised).

Suggest you probably need two reminders, one say 15 minutes before and one 5 minutes before.

Suggest you set the timer interval to 30000 - equivalent to 5 minutes and the timer code would be something like:

Dim Rst as recordset
Dim Fld as Field
set rst=currentdb.openrecordset("SELECT ApptID, ContactName, ContactNumber FROM tblAppointments WHERE AppointmentCompleted=false and appointmentTime<" & dateadd("n",15,now()))
AppointmentListBox.rowsource=""
while not rst.eof
    for each fld in rst.fields
       AppointmentListBox.rowsource=AppointmentListBox.rowsource & fld.value & ";"
    next fld
wend
set rst=nothing

AppointmentListBox is a listbox with rowsource type set to Valuelist and number of columns set to 3 and the first columnwidth set to 0 - these can obviously be changed to suit your requirements

If you have an apptID to identify the record, you can put some code in the on click event to open the appointment record

 

[spikepl]

Just curious - why would you want to duplicate a functionality that already exists in Outlook, and presumably is also in use there? You can add appointments from Acceess to Outlook.

 

[blogmk]

Just curious - why would you want to duplicate a functionality that already exists in Outlook, and presumably is also in use there? You can add appointments from Acceess to Outlook.

My customers don't use outlook. But still can I use the functionality in Access? If so how does it work? Thanks