Diary in Access (1 Viewer)

sam_antoine

Registered User.
Local time
Today, 15:41
Joined
Apr 30, 2003
Messages
18
Is it possible to create a diary to log all appointments, thus creating reminders in MSAccess? something similar to the claendar in MsOutlook.
 

WayneRyan

AWF VIP
Local time
Today, 15:41
Joined
Nov 19, 2002
Messages
7,122
Sam,

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

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

Code:
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

Registered User.
Local time
Today, 15:41
Joined
Apr 30, 2003
Messages
18
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.
 

Attachments

  • dairy.jpg
    dairy.jpg
    88.7 KB · Views: 276

WayneRyan

AWF VIP
Local time
Today, 15:41
Joined
Nov 19, 2002
Messages
7,122
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

Registered User.
Local time
Today, 15:41
Joined
Apr 30, 2003
Messages
18
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

AWF VIP
Local time
Today, 15:41
Joined
Nov 19, 2002
Messages
7,122
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

Registered User.
Local time
Today, 15:41
Joined
Apr 30, 2003
Messages
18
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.
 

Attachments

  • copy of event calendar.zip
    54.4 KB · Views: 338

WayneRyan

AWF VIP
Local time
Today, 15:41
Joined
Nov 19, 2002
Messages
7,122
Sam,

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

Wayne
 

WayneRyan

AWF VIP
Local time
Today, 15:41
Joined
Nov 19, 2002
Messages
7,122
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

Registered User.
Local time
Today, 15:41
Joined
Apr 30, 2003
Messages
18
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

Registered User.
Local time
Today, 15:41
Joined
May 29, 2006
Messages
60
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

AWF VIP
Local time
Today, 15:41
Joined
Nov 19, 2002
Messages
7,122
DJ,

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

Just Kidding,
Wayne
 

djshrew

Registered User.
Local time
Today, 15:41
Joined
May 29, 2006
Messages
60
WayneRyan said:
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
 

Dreamweaver

Well-known member
Local time
Today, 15:41
Joined
Nov 28, 2005
Messages
2,466
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
 

Attachments

  • 2018-11-11 (1).png
    2018-11-11 (1).png
    14.6 KB · Views: 35
  • 2018-11-11 (2).png
    2018-11-11 (2).png
    65.1 KB · Views: 34
Last edited:

Users who are viewing this thread

Top Bottom