By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,850 Members | 970 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,850 IT Pros & Developers. It's quick & easy.

calendar in Access

P: 58
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 #1
Share this Question
Share on Google+
76 Replies


nico5038
Expert 2.5K+
P: 3,072
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)
Jan 17 '07 #2

ADezii
Expert 5K+
P: 8,616
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.
Jan 18 '07 #3

P: 58
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.
Jan 19 '07 #4

P: 58
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.
Jan 19 '07 #5

nico5038
Expert 2.5K+
P: 3,072
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)
Jan 19 '07 #6

P: 58
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
Jan 19 '07 #7

ADezii
Expert 5K+
P: 8,616
I am absolutely interested. Thank you so much.
Give me your E-Maill address and I'll send it as a File Attachment.
Jan 19 '07 #8

P: 14
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.Your calendar sounds perfect , if possible could you send me a copy too.

Many Thanks

Email address removed per site rules!
Cheer
Jan 19 '07 #9

nico5038
Expert 2.5K+
P: 3,072
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)
Jan 19 '07 #10

ADezii
Expert 5K+
P: 8,616
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.Your 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

P: 58
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

P: 13
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

codegecko
Expert 100+
P: 533
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

P: 36
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

P: 33
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

P: 13
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
Expert 5K+
P: 8,616
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

P: 13
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

100+
P: 114
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

missinglinq
Expert 2.5K+
P: 3,532
Come on, people! Site rules forbid the posting of email addresses and they will be removed by the moderators!

If you need communication outside of the thread you need to use PMs. But remember, information shared via PMs is not available to other members/guests!

Linq ;0)>
Dec 11 '07 #21

P: 13
I would really like to use this calendar, but at the moment it is not aligning the days and dates correctly and I cannot work out how to make it right. I've tried the raw file on two computers, both with their timezone set to GMT, and it shows 1 December 2007 falling on a Friday, instead of Saturday; 1 January 2008 on a Tuesday, which is correct; 1 February 2008 on a Wednesday, instead of a Friday; 1 March on a Thursday instead of a Saturday; 1 April on a Friday, instead of a Tuesday......and so on. Grateful for any advice.
Dec 11 '07 #22

ADezii
Expert 5K+
P: 8,616
I would really like to use this calendar, but at the moment it is not aligning the days and dates correctly and I cannot work out how to make it right. I've tried the raw file on two computers, both with their timezone set to GMT, and it shows 1 December 2007 falling on a Friday, instead of Saturday; 1 January 2008 on a Tuesday, which is correct; 1 February 2008 on a Wednesday, instead of a Friday; 1 March on a Thursday instead of a Saturday; 1 April on a Friday, instead of a Tuesday......and so on. Grateful for any advice.
Sorry Erik, but I do not know what to tell you, it works perfectly on all my PCs. It must be something to do with your System (Date/Time setings). Have you checked your Date/Time settings in Control Panel?
Dec 11 '07 #23

P: 13
Yes, the date and time settings on both the pcs I tried it on are fine (GMT Standard Time). I even tried it on my work pc and got the very same error!
Dec 12 '07 #24

BradHodge
Expert 100+
P: 166
Looks like a future Tip of the Week, huh ADezii? :)

Brad.
Dec 13 '07 #25

ADezii
Expert 5K+
P: 8,616
Looks like a future Tip of the Week, huh ADezii? :)

Brad.
Sure, as soon as I find out what the problem is, and how I can relate a Topic to it (LOL).
Dec 13 '07 #26

P: 13
Hi, any progress with this?

I've found some other calendars here http://www.accessmvp.com/JConrad/acc...calendars.html, e.g http://www.access-programmers.co.uk/...9&d=1148031828. They all display the dates and days correctly, but are not as easy to use as yours.
Jan 25 '08 #27

mshmyob
Expert 100+
P: 903
Not that this helps but I have the same calendar aqnd it works just fine on two of my computers.


I would really like to use this calendar, but at the moment it is not aligning the days and dates correctly and I cannot work out how to make it right. I've tried the raw file on two computers, both with their timezone set to GMT, and it shows 1 December 2007 falling on a Friday, instead of Saturday; 1 January 2008 on a Tuesday, which is correct; 1 February 2008 on a Wednesday, instead of a Friday; 1 March on a Thursday instead of a Saturday; 1 April on a Friday, instead of a Tuesday......and so on. Grateful for any advice.
Jan 25 '08 #28

ADezii
Expert 5K+
P: 8,616
Not that this helps but I have the same calendar aqnd it works just fine on two of my computers.
Thanks mshmyob, this is really driving me out of my mind. I can come to no other soluyion but to state that the problem with the Calendar as far as eriktheviking goes, must be PC specific. Specific to what - I don't know! (LOL).
Jan 25 '08 #29

P: 13
Thanks mshmyob, this is really driving me out of my mind. I can come to no other soluyion but to state that the problem with the Calendar as far as eriktheviking goes, must be PC specific. Specific to what - I don't know! (LOL).
If it's specific to my computers, then it's weird that I get the same result on my 4 home computers and 3 computers I've tried at my place of work!!! So it is specific and general then. LOL.
Jan 28 '08 #30

mshmyob
Expert 100+
P: 903
What timezone are you using. I saw that you said GMT but which GMT. Give us the exact timezone. What OS are you using?

If it's specific to my computers, then it's weird that I get the same result on my 4 home computers and 3 computers I've tried at my place of work!!! So it is specific and general then. LOL.
Jan 28 '08 #31

P: 13
(GMT) Greenwich Mean Time: Dublin, Edinburgh, Lisbon, London.

Windows XP.
Jan 28 '08 #32

ADezii
Expert 5K+
P: 8,616
(GMT) Greenwich Mean Time: Dublin, Edinburgh, Lisbon, London.

Windows XP.
The only logical assumption is that the Time Zone may be the root of the problem. Shortly, I'll have another Version of the Calendar with several enhancements. As soon as it is finished, and I get the OK from the Author, I'll post it here for you to download and we'll see what happens. Stay tuned to this station. (LOL).
Jan 28 '08 #33

P: 13
As soon as it is finished, and I get the OK from the Author, I'll post it here for you to download and we'll see what happens. Stay tuned to this station. (LOL).
Thanks, ADezii. I eagerly await the post.
Jan 29 '08 #34

ADezii
Expert 5K+
P: 8,616
Thanks, ADezii. I eagerly await the post.
I'm still waiting, should have it shortly. I mentioned your dilemma to the Original Author and he does 'not' thing that your Regional Settings are the cause of the anomaly. We are still working on it, please be patient.
Jan 29 '08 #35

P: 13
OK, thank you. I appreciate your help.
Jan 30 '08 #36

ADezii
Expert 5K+
P: 8,616
OK, thank you. I appreciate your help.
This may not be the 'final' Version, but I wanted to give you something to work with:
Feb 1 '08 #37

P: 13
This may not be the 'final' Version, but I wanted to give you something to work with:
Thanks, but I still get the same error, see: Feb 2008 and March 2008.

and

Feb2008 and Mar2008
Feb 3 '08 #38

ADezii
Expert 5K+
P: 8,616
Thanks, but I still get the same error, see: Feb 2008 and March 2008.

and

Feb2008 and Mar2008
I'll keep on trying, but I am really running out of options here. (LOL).
Feb 3 '08 #39

ADezii
Expert 5K+
P: 8,616
Thanks, but I still get the same error, see: Feb 2008 and March 2008.

and

Feb2008 and Mar2008
Please keep the Graphic Links active, I've contacted the Author and requested he have a look at them. If he cannot get to the bottom of this, I don't know who can.
Feb 4 '08 #40

MMcCarthy
Expert Mod 10K+
P: 14,534
Just a thought ADezii. Could this have anything to do with the problem using European formatted dates in Access?
Feb 5 '08 #41

ADezii
Expert 5K+
P: 8,616
Just a thought ADezii. Could this have anything to do with the problem using European formatted dates in Access?
Would the actual formatting cause the Dates to be out of sync? Don't really know at this juncture. Anyone I have ever known who has used this Calendar has never had this problem. The same Calendar in everyone's PC works correctly except for erikthevikinig's, who happens to be in the Greenwich Time Zone. The logical deduction, at least in my mind, is that it must have something to do with the Regional Settings or with the European Formatting of Dates as indicated by yourself. A real dilemma to say the least. The original Author, whom I know well, has not given up on this neither, it's just that we are both stumpped at this point.
Feb 5 '08 #42

MMcCarthy
Expert Mod 10K+
P: 14,534
Would the actual formatting cause the Dates to be out of sync? Don't really know at this juncture. Anyone I have ever known who has used this Calendar has never had this problem. The same Calendar in everyone's PC works correctly except for erikthevikinig's, who happens to be in the Greenwich Time Zone. The logical deduction, at least in my mind, is that it must have something to do with the Regional Settings or with the European Formatting of Dates as indicated by yourself. A real dilemma to say the least. The original Author, whom I know well, has not given up on this neither, it's just that we are both stumpped at this point.
Unfortunately, Access is unpredictable with these date issues when regional settings are to European date format. Sometimes they work and sometimes they don't. Imposing a format helps.

Check out Ade's tutorial on the subject.

Literal DateTimes and Their Delimiters (#)
Feb 5 '08 #43

ADezii
Expert 5K+
P: 8,616
Unfortunately, Access is unpredictable with these date issues when regional settings are to European date format. Sometimes they work and sometimes they don't. Imposing a format helps.

Check out Ade's tutorial on the subject.

Literal DateTimes and Their Delimiters (#)
Hello Mary, if you get a few minutes could you possibly download Calendar.zip contained in Post #37. Perhaps you can see something in the coding that may be causing this anomaly, something I missed. Thanks.
Feb 5 '08 #44

MMcCarthy
Expert Mod 10K+
P: 14,534
OK the problem is in the date format.

Looking at the following code...

Expand|Select|Wrap|Line Numbers
  1. Private Sub PopulateCalendar()
  2. On Error GoTo Err_PopulateCalendar
  3.  
  4. Dim strFirstOfMonth As String, bytFirstWeekdayOfMonth As Byte, bytBlockCounter As Byte
  5. Dim bytBlockDayOfMonth As Byte, lngBlockDate As Long, ctlDayBlock As Control
  6. Dim bytDaysInMonth As Byte, bytEventDayOfMonth As Byte, lngFirstOfMonth As Long
  7. Dim lngLastOfMonth As Long, lngFirstOfNextMonth As Long, lngLastOfPreviousMonth As Long
  8. Dim lngEventDate As Long, bytBlankBlocksBefore As Byte, bytBlankBlocksAfter As Byte
  9. Dim astrCalendarBlocks(1 To 42) As String, db As Database, rstEvents As Recordset
  10. Dim strSelectEvents As String, strEvent As String, strPlatoons As String
  11. Dim intMonth As Integer, intYear As Integer, lngSystemDate As Long  'CFB added 1-25-08
  12. Dim ctlSystemDateBlock As Control, blnSystemDateIsShown As Boolean  'CFB added 1-25-08
  13.  
  14.     lngSystemDate = Date    'CFB added 1-25-08
  15.     intMonth = objCurrentDate.Month
  16.     intYear = objCurrentDate.Year
  17.     lstEvents.Visible = False
  18.     lblEventsOnDate.Visible = False
  19.     lblMonth.Caption = MonthAndYear(intMonth, intYear)
  20.  
  21.     strFirstOfMonth = Str(intMonth) & "/1/" & Str(intYear)
  22.     bytFirstWeekdayOfMonth = Weekday(strFirstOfMonth)
  23.  
  24.  
strFirstOfMonth value (for today) is "2/1/2008" which is fine for US dates and will return the correct Weekday. However under European dates this is being translated as Jan 2nd. Therefore the wrong Weekday number is being returned (4 instead of 6) for the start of the month.

The following would work for European standards but not for US.

strFirstOfMonth = "1/" & Str(intMonth) & "/" & Str(intYear)

I would suggest trying the following instead as I think it is consistent accross the board.

strFirstOfMonth = Str(intYear) & "/" & Str(intMonth) & "/1"
Feb 5 '08 #45

P: 13

I would suggest trying the following instead as I think it is consistent accross the board.

strFirstOfMonth = Str(intYear) & "/" & Str(intMonth) & "/1"
I think that's sorted it! Many, many thanks.
Feb 5 '08 #46

ADezii
Expert 5K+
P: 8,616
OK the problem is in the date format.

Looking at the following code...

Expand|Select|Wrap|Line Numbers
  1. Private Sub PopulateCalendar()
  2. On Error GoTo Err_PopulateCalendar
  3.  
  4. Dim strFirstOfMonth As String, bytFirstWeekdayOfMonth As Byte, bytBlockCounter As Byte
  5. Dim bytBlockDayOfMonth As Byte, lngBlockDate As Long, ctlDayBlock As Control
  6. Dim bytDaysInMonth As Byte, bytEventDayOfMonth As Byte, lngFirstOfMonth As Long
  7. Dim lngLastOfMonth As Long, lngFirstOfNextMonth As Long, lngLastOfPreviousMonth As Long
  8. Dim lngEventDate As Long, bytBlankBlocksBefore As Byte, bytBlankBlocksAfter As Byte
  9. Dim astrCalendarBlocks(1 To 42) As String, db As Database, rstEvents As Recordset
  10. Dim strSelectEvents As String, strEvent As String, strPlatoons As String
  11. Dim intMonth As Integer, intYear As Integer, lngSystemDate As Long  'CFB added 1-25-08
  12. Dim ctlSystemDateBlock As Control, blnSystemDateIsShown As Boolean  'CFB added 1-25-08
  13.  
  14.     lngSystemDate = Date    'CFB added 1-25-08
  15.     intMonth = objCurrentDate.Month
  16.     intYear = objCurrentDate.Year
  17.     lstEvents.Visible = False
  18.     lblEventsOnDate.Visible = False
  19.     lblMonth.Caption = MonthAndYear(intMonth, intYear)
  20.  
  21.     strFirstOfMonth = Str(intMonth) & "/1/" & Str(intYear)
  22.     bytFirstWeekdayOfMonth = Weekday(strFirstOfMonth)
  23.  
  24.  
strFirstOfMonth value (for today) is "2/1/2008" which is fine for US dates and will return the correct Weekday. However under European dates this is being translated as Jan 2nd. Therefore the wrong Weekday number is being returned (4 instead of 6) for the start of the month.

The following would work for European standards but not for US.

strFirstOfMonth = "1/" & Str(intMonth) & "/" & Str(intYear)

I would suggest trying the following instead as I think it is consistent accross the board.

strFirstOfMonth = Str(intYear) & "/" & Str(intMonth) & "/1"
Thanks a million Mary, you have no idea how much I appreciate your response, and subsequent solution to the problem. If you were in front of me right now, I'd kiss ya! (LOL). P.S. - I'll notify the Original Author since I'm sure that he will be interested also. Thanks again.
Feb 5 '08 #47

ADezii
Expert 5K+
P: 8,616
I think that's sorted it! Many, many thanks.
That Mary's something, isn't she? For both of us, I'm happy your issue got resolved.
Feb 5 '08 #48

P: 13
That Mary's something, isn't she? For both of us, I'm happy your issue got resolved.
She sure is. Thanks for sticking with it ADezii. You're a star.
Feb 5 '08 #49

MMcCarthy
Expert Mod 10K+
P: 14,534
Happy to help!
Feb 5 '08 #50

76 Replies

This discussion thread is closed

Replies have been disabled for this discussion.