Diary in Access

[sam_antoine]

Is it possible to create a diary to log all appointments, thus creating reminders in MSAccess? something similar to the claendar in MsOutlook.

 

[WayneRyan]

Sam,

tblDiary:
EntryNumber - AutoNumber
Event - Memo
DateDue - Date/Time
EventStatus - Boolean

You could have a table like above and when your main form opens:

AnyEvents = Nz(DLookUp("[DateDue]","tblDiary", "[DateDue] < #" & Date + 1 & "# and EventStatus = False"), 0)
If AnyEvents > 0 Then
   DoCmd.OpenForm "frmViewDiary", ...
End If

Otherwise, the user can select the above form from a menu
to enter future appointments and mark others as completed.

Wayne

 

[sam_antoine]

I have tried what you suggested but it's not working. EventStatus on your sample refers to what exactly? Please find attached a sample of what i want my form to look like.

 

[WayneRyan]

Sam,

The EventStatus is just a boolean field representing whether
the task has been completed or not. If something was incomplete
two days ago, you would still want to be reminded.

What is not working?

Wayne

 

[sam_antoine]

I think I may have placed the code in the wrong place. Did you see the form i attached? I want the reminder popup form to open on double click (per times). the control for each time span will have the subject and the popup form (which will also be used as the reminder form) will have details such as starttime, endtime, client, category, eventdetails....

I just need to know how and if I can achieve this goal. the reminder should popup with a message 5 minutes prior to event. I want it to work like OUTLOOK. I am not sure I am explaining it properly to you. Do you have an email. I can email you what i have done so far.

 

[WayneRyan]

Sam,

This is a PUBLIC forum. Please compact then ZIP then attach
your db. It will be small enough to fit. That way you will
get many people looking at, some of which may have already
developed what you need.

Make sure to do Tools --> Database Utilities --> Compact
Then ZIP it and post it.

Wayne

 

[sam_antoine]

Please find attached a copy of what I have done so far. What I am trying to achieve is a system that reminds you of an appointment 5 minutes before the time. I am not sure if I can achieve this but I am trying. Any help is greatly appreciated.

If you click into the time on the daily planner, you can enter the subject. However if you doulbe click on it, a popup form will open so you can add the details for the event/appoinment.

 

[WayneRyan]

Sam,

I'm moving computers right now, but will look at it soon.

Wayne

 

[WayneRyan]

Sam,

Still under construction. This is the only functional computer
I have and it doesn't have Access. Just wanted to promote it
back to the top.

Wayne

 

[sam_antoine]

Thanks, in the mean time I am still working on it. I have made a little progres. At present I am trying to insert a clock that will activate the timer and hence implement the reminder.

 

[djshrew]

how did or is this going on? i am hopeing to do something very similar. also prehaps use a slightly bigger calender and say what appointments i have on that day. in the calender.

 

[WayneRyan]

DJ,

It's going fine computers are moved and all is well.

Just Kidding,
Wayne

 

[djshrew]

DJ,

It's going fine computers are moved and all is well.

Just Kidding,
Wayne

Lol, dont suppose you know how sam got on with this? did u help assist her with this project, dont suppose you have the final version? or just what was posted?

Thanks

Shrew

 

[WayneRyan]

Shrew,

Sorry, just what was in the thread.

Wayne

 

[Dreamweaver]

I use the attached but did not develope it so can't post a copy I have made a lot of edits to it though.


I downloaded it from a forum back in 2005 I think and have checked the code which does not have any author tags.


I could create a sample but would need advice as it was not my original work


I have uploaded a second I cannot make the diary available as took me years of work to get it wright and it's so deep in my projects it would take days to sort it out but the project I'm working on will be free to all just not open sorry but hope it will give you a few idears