473,729 Members | 2,235 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

calendar in Access

58 New Member
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?
Jan 17 '07
76 24177
ADezii
8,834 Recognized Expert Expert
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.
Jan 20 '07 #11
apartain
58 New Member
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]
Jan 20 '07 #12
eriktheviking
13 New Member
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.
Oct 24 '07 #13
JamieHowarth0
533 Recognized Expert Contributor
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
Oct 24 '07 #14
CrostonScottish
36 New Member
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
Oct 24 '07 #15
glamster7
33 New Member
If its possibly could I have a copy of this as well. email addy is Email address removed per site rules!
Nov 6 '07 #16
eriktheviking
13 New Member
This is a great calendar, but something strange is happening with some of the dates. I've uploaded some screen-shots to http://s238.photobucket.com/albums/ff21/eriktheviking/ so you can see what I mean.

For example, the Calendar is showing that October 1 2007 was on a Wednesday (Oct07a.jpg) when it was actually on a Monday. The Events form shows it correctly (Oct07b.jpg).

November is correct on both the Calendar and the Events form (see Nov07a.jpg and Nov07b.jpg).

December is similar to November, with the Calendar showing 1 Dec 2007 on a Friday when it will really be on a Saturday (see Dec07a.jpg and Dec07b.jpg).

I have not modified the code at all and am completely stumped about what's going on. Any help much appreciated.

ADezii: I have PM'd you, but realise you must be very busy so I decided to post here too.
Nov 6 '07 #17
ADezii
8,834 Recognized Expert Expert
This is a great calendar, but something strange is happening with some of the dates. I've uploaded some screen-shots to http://s238.photobucket.com/albums/ff21/eriktheviking/ so you can see what I mean.

For example, the Calendar is showing that October 1 2007 was on a Wednesday (Oct07a.jpg) when it was actually on a Monday. The Events form shows it correctly (Oct07b.jpg).

November is correct on both the Calendar and the Events form (see Nov07a.jpg and Nov07b.jpg).

December is similar to November, with the Calendar showing 1 Dec 2007 on a Friday when it will really be on a Saturday (see Dec07a.jpg and Dec07b.jpg).

I have not modified the code at all and am completely stumped about what's going on. Any help much appreciated.

ADezii: I have PM'd you, but realise you must be very busy so I decided to post here too.
eriktheviking, I am more stumped than you are, since I show none of these anomalies such as you describe. I have no reply right now, but I'll continue to look into it.
Nov 6 '07 #18
eriktheviking
13 New Member
eriktheviking, I am more stumped than you are, since I show none of these anomalies such as you describe. I have no reply right now, but I'll continue to look into it.
Ok, thanks ADezii. I look forward to hearing from you.
Nov 7 '07 #19
martin DH
114 New Member
Give me your E-Maill address and I'll send it as a File Attachment.
ADezii,
I would also be interested in a copy of this calendar if still available!

Email address removed per site rules!

Thanks.
Dec 11 '07 #20

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
4229
by: Michael Holberton | last post by:
Hi All, I have Access 97, 2000 & 2002 installed in different directories under Win2K Server on a new PC box I built. The Calendar Control on my Date Selector Form is not working and causing various problems. The file in C\winnnt\system32 appears to be the version for Access97. Even if I register the version for Access 2000, that resides in the Office directroy of my Office 2000 installation(or move it to the C\winnnt\system32...
1
2064
by: Marco Simone | last post by:
Hi, If someone can answer how to add calendar control on form, where you can choose date. I think there is Calendar control in ActiveX add in, but I don't know how to implement it. Thanks for your help, Marco
8
2457
by: Shyguy | last post by:
Is it possible to create a calendar that shows previous input data and also allows for input of new data?
1
4173
by: Norman Fritag | last post by:
Hi there I have avoided to use active x controls because I thought they are causing more problems then they are doing any good. I a new application I would want to use the tree and list view control in access 2002. Prior to that I like to fine some information or here some feed back from developers who have use active x controls success fully in there application, what their experience was.
3
8233
by: Matthew | last post by:
I currently have a form in MS Access that has certain combo boxes which specify criteria in order to run a query based on that criteria. I want to add to this, a calendar from which a user will be able to click on a date, where the chosen date will then be used as the criteria for the control source of the calendar. What do I need to do to make the calendar active?? I can physically get it on my form, and specify the criteria in my...
16
3055
by: DFS | last post by:
If you're listening, I want the middle of the calendar (showing 1 month) to open below the cursor position. It currently opens just to the right and below the cursor position. I hunted through the code, but can't determine what to alter. Very nice piece of work, by the way. Thanks
9
5814
by: Greg | last post by:
Hi, I have a table with "dates", i'd like to display those dates on a calendar. I've put a calendar in a form, linked to my "date" field, and it works, but only showing one "date" per calendar. I can see all "dates" moving to next records, but one per calendar. :-( Ex: 17/06 on one claendar, then if i click on next record, I can see my calendar with 24/06 ...etc ...
1
3004
by: xian2 | last post by:
Hi, I wanted to create a calendar in Access that would call on data stored within tables in the database (dates in forms) and would show it visually on a calendar when the calendar was opened. I was told about calendar control fundtion and created a calendar in a form but cannot work out how to call on the data within the tables so it appears as an entry in the calendar when the calendar is opened. Please can you give me some advice on...
2
1958
by: BerkshireGuy | last post by:
I need to create a form that is a giant calendar. For each day of the month (users should be able to browse the months) the date is a different color if: 1) The daily routine ran 2) If the daily routine didnt run. The idea is that a daily routine needs to happen everyday (unfortunately scheduling is not an option right now).
340
108806
by: MyWaterloo | last post by:
This thread has been closed as it has gotten just too big. If you have any questions about the application discussed in this thread please start a new thread in MS Access by clicking on the Start a Discussion button and link to the this thread in your question. Just wondering...Am I the only one in the access universe that would like an Outlook like calendar option? Is there such a thing as a calendar that can be used for data entry? ...
0
8924
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9428
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9286
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9153
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6722
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6026
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4797
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2689
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2165
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.