MS Access Calendar

[ADezii]

kashif73, You are quite welcome.

I'm helping someone out with a Project similar to yours and which also includes some functionality similar to what you had requested. Check in from time to time, since I feel I can further enhance your Project with a little modification of my current work. I'll Attach what I have developed for you at that time.

[ADezii]

Sure I'll keep an eye on this thread.
Best regards.

Download the Attachment and see if you can use the new functionality, if not, then nothing was lost. I intentionally did not Comment the New Code for the sake of brevity. Should you have any questions whatsoever, please do not hesitate to ask.

[kashif73]

Thank you very much Azedii. It looks great.This is exactly what I wanted. You've solved my problem. A real big THANKS for this.

[ADezii]

Thank you very much Azedii. It looks great.This is exactly what I wanted. You've solved my problem. A real big THANKS for this.

You are quite welcome, kashif73. I'm glad that it all worked out for you. Remember to peeriodically Compact/Repair the Database because of the nature of it.

[yiwen]

Hello Adezii,
Could you please post a link for a generic functionnality of the calendar.
There is no attachement on post 59 and 60 like mentionned in some posts.

Thanx

[ADezii]

Are we talking about a Single Date (Date) or Date Range (Between Date1 And Date2)?

[yiwen]

Hi
I am looking for the version wich could be better for managing appointements for each day. (it should be one date).

[ADezii]

Try this for a Single-Date Demo:

[mahogg]

Hi, I'm looking for a calander to sit in an Acc 2007 database. I was reading through this thread with interest, but cannot actually find a link or download for ADezii's calander. I'd love to take a look and see if it would fit my needs, assuming of course, you can still share the project?
regards,
mike.

[MMcCarthy]

mahogg

Can you see the attachment in ADezii's last post.

http://bytes.com/topic/access/answers/761255-ms-access-calendar#post3535204

[NeoPa]

Msquared is referring to post #189 of course. It may be that this particular one, doctored for the needs of the previous poster, is not what you're after. If so, then please indicate which version you're having trouble with and we can check to see what the problem may be.

[ADezii]

Hello Mike, if you clearly state exactly what your needs are, along with the relevant information and sample data, then I will be happy to retrofit the Calendar for a simple demo, and Attach it for you to view. It's up to you.

[mahogg]

Thanks for the prompt replies and your kind offer of help, Adezil.
I'm new to Access and have been learning on the hoof. I've adapted the Northwind sample in Acc2007, adding several tables, queries & forms of my own. I wanted to add a calendar to the 'Northwind Home' page, replacing the chart they use in the sample form. I'd like to be able to enter text representing events, tasks, reminders etc. and have either a daily, weekly or monthly view option. Your zip file in #189 looks like it might fit the bill. Would it be possible to link it to a separate tbls/qrys/subfrm's for Events, Meetings and Tasks? Excuse my rather shallow knowledge of databases so far, as I say, I'm learning on the go but I 'plateau' round about the level of amending pre written macro's . . .
I'm struggling to attach anything meaningful as there are so many underlying objects linked to the home page. Hopefully you can open the sample in Acc2007 and see what I'm referring to?
Thanks again guys.
Mike.

[ADezii]

Sorry Mike, not running Access 2007. The Calendar is an Unbound Access Form and as such cannot be Embedded or Linked To the Northwind Home Page. It can, however, be Opened in any manner from the Opening Form. It appears as though you are asking for a full blown Task Manager/Scheduler which the Calendar is not. It is simply used as a monthly, graphical display of limited data with full Navigation capabilities. Provide me with some simple data such as [Start Date], [End Date], [Event Name], [Originator], etc. and I'll see what I can do for you.

[nerd4access]

re: MS Access Calendar

ADezii,

I must say I love the Calendar_Single Date demo you posted. I have incorporated it into a database that I am building. I ran into a small issue in doing so. I am using an Access front end and a SQL 2005 backend. The code worked fine before upsizing the backend to SQL.

My current issue occurs when I click on a day in the calendar, the list box shows data for a date two days after the chosen date. For instance, if I click on January 3, 2010, the list box shows data for January 5, 2010. The list box consistently shows data for a date two days in the future regardless of the day chosen on the calendar. Do you have any idea why I am experiencing this issue?