calendar in Access

[apartain]

Has anyone ever created a shared calendar within Access? It would be similar to MS Outlook, but clearly not as in-depth. I would need to use it for employees to enter their availability so managers can assign projects accordingly. As well, it would be nice if it actually LOOKED like a calendar.

Do you recommend the ActiveX Calendar Control?

[nico5038]

Why create this with Access ?
Personally I would look into web based solutions like the Yahoo agenda so every employee with an internet browser can have access to the calendar....

Nic;o)

[ADezii]

Has anyone ever created a shared calendar within Access? It would be similar to MS Outlook, but clearly not as in-depth. I would need to use it for employees to enter their availability so managers can assign projects accordingly. As well, it would be nice if it actually LOOKED like a calendar.

Do you recommend the ActiveX Calendar Control?

If you are interested, I have a fully functional Calendar created entirely within Access via 1 Table, 2 Forms, 1 Class, and 1 Standard Code Module. It was used as a simple Appointment Calendar for a certain Unit within the Philadelphia Fire Department. It is quite simplistic and easily adaptable. Let me know if you are interested.

[apartain]

If you are interested, I have a fully functional Calendar created entirely within Access via 1 Table, 2 Forms, 1 Class, and 1 Standard Code Module. It was used as a simple Appointment Calendar for a certain Unit within the Philadelphia Fire Department. It is quite simplistic and easily adaptable. Let me know if you are interested.

I am absolutely interested. Thank you so much.

[apartain]

Why create this with Access ?
Personally I would look into web based solutions like the Yahoo agenda so every employee with an internet browser can have access to the calendar....

Nic;o)

This is a very interesting database. The users would love to have the calendar in the same database as their projects and employee time for cross-reference. They also need to be able to input availabilty so projects can be assigned accordingly. I'm with you, why not use Outlook or something, but they asked me to try.
Thanks as always for your helpful responses. You are very appreciated.

[nico5038]

Hmm, your comment triggered for me the thought to incorporate a Webbrowser in a page and have that pointing to the Yahoo (or other) web calendar :-)

Main question is or all people that need to enter their availability do have access to your .mdb.
For most of these systems I know the users are on a distance and have no access to the .mdb.

Nic;o)

[apartain]

Hmm, your comment triggered for me the thought to incorporate a Webbrowser in a page and have that pointing to the Yahoo (or other) web calendar :-)

Main question is or all people that need to enter their availability do have access to your .mdb.
For most of these systems I know the users are on a distance and have no access to the .mdb.

Nic;o)

Yes, the are on an inter-office network so they all have access to the database. They also have a vpn, which concerns me because I'm not sure how the database will operate with all that traffic.

They use Outlook now, but want it in the database. If I can't figure it out, they'll just have to continue using Outlook. If I can, they'll think I'm really smart. hehe

Not really, I'll give credit where due.

At the very least, I can create a simple table and sort it by date and they can look at it that way.

By the way, I don't know VBA code very well, so if you were to be kind enough to help me out, could you please give specific instructions?

Thanks,
ang

[ADezii]

I am absolutely interested. Thank you so much.

Give me your E-Maill address and I'll send it as a File Attachment.

[Noob]

Hi
I would also be interested in the calender file as im looking for a way to incorporate a courtesy car booking calendar into my database for a qiuck visual reference showing availability.Yo ur calendar sounds perfect , if possible could you send me a copy too.

Many Thanks

Email address removed per site rules!
Cheer

[nico5038]

You might use automation to access the appointments from outlook, checkout:

http://support.microsoft.com/kb/209963/en-us

Thus the users don't have to learn new tricks :-)

Nc;o)

[ADezii]

Hi
I would also be interested in the calender file as im looking for a way to incorporate a courtesy car booking calendar into my database for a qiuck visual reference showing availability.Yo ur calendar sounds perfect , if possible could you send me a copy too.

Many Thanks

Cheer

As soon as I get the OK from the original Creator of this Database, I'll send it to you.

[apartain]

Give me your E-Maill address and I'll send it as a File Attachment.

Thank you so much for this. I am also looking at the link you sent, but am not sure if I can do it or not.

[Only give email addresses by PM]

[eriktheviking]

If you are interested, I have a fully functional Calendar created entirely within Access via 1 Table, 2 Forms, 1 Class, and 1 Standard Code Module. It was used as a simple Appointment Calendar for a certain Unit within the Philadelphia Fire Department. It is quite simplistic and easily adaptable. Let me know if you are interested.

I'd very much like this calendar file too please. I'm trying to develop a booking system for a small after school club and am struggling with the calendar system in MS Access. Thanks.

[JamieHowarth0]

Hi folks,

Just to add my tuppence' worth, I've seen a good calendar sample here (from ASP101) which various individuals have taken, altered and tweaked to end up with a generic Access DB-powered calendar (which obviously you can then tweak to your specific requirements). It includes CSS for custom styling as well.

If you are after a fully shared calendar, I would advise looking at Google Calendar, because if you really want some kudos points from your bosses, there's a way that you can set up numerous calenders on the Google system, and because it supports iCalendar format as well as XML, you can create a direct link to Outlook so people can share the calendar directly in Outlook's interface (I think, but have never tried... but then I use Exchange Server so don't need a custom calendar app).

Best regards,

medicineworker

[CrostonScottish]

Saw this thread and instantly thought how useful it would be for a database we are developing for our education department to look at what rooms are booked and what staff are free to teach. If you don't mind i would love a copy to adapt.

Email address removed per site rules!

Cheers