473,327 Members | 2,081 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes and contribute your articles to a community of 473,327 developers and data experts.

MS Access Calendar - OVERVIEW

ADezii
8,834 Expert 8TB
MS Access Calendar – OVERVIEW

Many times over the years, a similar type question has been asked of us here at Bytes, namely: How Can I Incorporate Calendar Like Functionality Solely Within The Context Of My Access Application? The individuals posting these questions are not referring to the varied ActiveX Calendar Controls that essentially present a Popup Dialog that enables you to select a Date then populate a Form Field with that Date, but something a little more interactive such as the Outlook Calendar where you can double click on a Date, then add some data relative to that Date for display and later retrieval.

This all started back on January 19, 2008 when a regular Member asked if there was an Outlook like Calendar option that can be used for data entry. Now, 340 Posts later, Bytes finds itself in a situation, where it must Close the Thread due primarily for efficiency reasons. Needless to say, this Topic has generated an unprecedented amount of interest which we will now attempt to keep alive via this Insight as well as a Link to the Original Thread.

Before I go any further, I would like to state that the basic Calendar functionality that I previously described does exist here at Bytes in what we affectionately call the MS Access Calendar. After proceeding with some background information on its inception, I will then go on to describe its implementation, as well as providing Attachments for the two Versions available, namely the Wide and Standard Calendars.

The Original Calendar was created many years ago by a friend and co-worker of mine, Carl Broll. We were both Fire Fighters at the time, and the Department needed a Scheduler complete with Date listings, a display of working platoons for each day of the week, and a mechanism to input basic information referring to scheduled appointments. This was how the Original Calendar came to be.

I joined TheScripts (now Bytes) back in April of 2006, and soon realized that this need for an Access based Calendar can be mostly fulfilled by an adaption of the Original Calendar. With Carl’s explicit permission, I soon made some modifications and enhancements to it, basically tailoring it to each requestor’s specific needs. It now exists in two Versions: Wide (for Screen Resolutions >= 1024 X 768) and Standard (all other Resolutions).

The primary function of the MS Access Calendar is to provide a graphical representation of a limited amount of Data generated from a DAO Recordset. The source of this Recordset can be a Query, Table, or SQL Statement. This Recordset can contain either a single Date Field or a Range of Date Fields (From…To) and populates the Calendar Grid accordingly. It can also be enhanced so that you can double-click on a specific Date Block, and Open a Form in which you can now Add, Modify, or Delete Records in the underlying Data Source. At this point, the Calendar will need to be in sync with the Data Source and this can easily be accomplished via a Sync Command Button.

I will not get into any of the technical aspects of the MS Access Calendar at this point, but reserve that discussion for the IMPLEMENTATION Section to follow.

If you have any questions about the original application in the MS Access Calendar thread please start a new thread in MS Access by clicking on the Start a Discussion button and link to the original thread in your question.
May 17 '11 #1
10 8311
MMcCarthy
14,534 Expert Mod 8TB
A very nice introduction ADezii.

I worked on something a couple of years ago which had to show a one year / 365 day view. I remember how complex it was and I only had to deal with a single piece of data, nothing like a recordset.

I'm looking forward to seeing the implementation of this laid out in an insight.

Mary
May 17 '11 #2
NeoPa
32,556 Expert Mod 16PB
Me too :-D (even as far as chatting with Mary about the project she's talking about).

Here's a thought I just had, and it may be somewhat more than trivial I know. What about producing a calendar facility (or possibly Diary as the term Calendar doesn't really do it justice) which determines dynamically whether or not it can be a Wide version or Standard. Just a thought.
May 18 '11 #3
ADezii
8,834 Expert 8TB
@NeoPa - Not crystal clear on what you are saying, NeoPa. Are you suggesting that I dynamically determine the User's Screen Resolution, then Load the appropriate Version of the Calendar Form? It could be done, but it would add to the complexity of the Code, make the OVERVIEW already obsolete, and add another Control laden Form. Think it is worth the trade-off, assuming this was the original suggestion?
May 18 '11 #4
NeoPa
32,556 Expert Mod 16PB
That's certainly what I was suggesting you consider ADezii. Please bear in mind that I am not in a position to know all about your considerations as I am not the architect of the project. My understanding of it is considerably more limited than yours.

That said, I would be interested to see such a project, and probably even interested enough to work with you on it, though my time currently is more limited than yours I suspect. Maybe you will decide it is not practical enough for now, but might be considered again sometime in the future. I can't say, as it is for you to consider.
May 18 '11 #5
ADezii
8,834 Expert 8TB
@NeoPa - Definitely worth considering, I'll have to sleep on it for awhile. Thanks for the insight.
May 18 '11 #6
ADezii
8,834 Expert 8TB
@NeoPa - Just wanted to let you know that I carefully considered both your suggestions concerning the Vertical Scroll Bars and Resolution Determination within the MS Access Calendar. Both have now been integrated within the Calendar, and there is no longer any need for a 'Standard' and 'Wide' Version. What I have done is:
  1. At an entry point into the Database, in my case the AutoExec Macro, call a Public Function (fMain()). This Function will determine the User's Screen Resolution, and if it is >=1024 AND >=768, then The Wide Version (Form) of the Calendar will be Opened, and if not the Standard Version (Form) will. A Public Variable (gstrCalForm) will also be Set indicating which Form is Loaded, either frmStandardCalendar or frmWide Calendar. The Application needs to know which Form is being utilized at any given time.
  2. After the Calendar itself is populated, a Sub-Routine (SetScrollBars()) is executed only if the 'Wide' Version is being utilized. This Routine Loops thru every Date Block (Text Boxes) on the Current Form, then counts the Number of CrLfs in its Value. If this Value is greater than a pre-determined Number, 4 in this case, there is a need for Vertical Scroll Bars, if not, not are required.
  3. It all seems to work quite well, with a minimal amount of overhead. If you would like to see the specific Code, I would be more than happy to supply it. Once I tweak it a little, I would like to send you and Mary the DB in its entirety, and perhaps you can come up with a couple of other valued suggestions. Thanks for the input, it is appreciated.
  4. Once this gets all ironed out, I'll start working on the IMPLEMENTATION aspect. For now, I cannot go in and either Edit or Add information to what I previously posted, and made Mary aware of this situation.
May 20 '11 #7
NeoPa
32,556 Expert Mod 16PB
Stunning job!

I'd be very interested in seeing what you've got my friend. Whenever you're ready is good.
May 20 '11 #8
Hi, I have downloaded the calendar app's to have a look at. Are they the latest though as this thread implies there is just the one app now which works out screen res rather than the two (wide & std). Also are you in the US? I'm in the UK and when I enter todays date it appears as a Friday not a Tuesday in the graphical calendar and just wondered if that is why. I would love to use this to track holidays in our organisation although I'd have to amend to include start and end dates. Thanks...
May 14 '13 #9
ADezii
8,834 Expert 8TB
@labessade
I have attached one of the later Versions of the Calendar without the Resolution determination Code that seems to work quite well. Download it and see if it suits your needs.
Attached Files
File Type: zip Calendar.zip (56.8 KB, 565 views)
May 14 '13 #10
Great, I shall have a play - it looks like a good start to what I need thank you!!!
May 15 '13 #11

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: nh_capricorn | last post by:
Hi, I am fairly new to .NET (coming from a Java background) and I am trying to port an application that I originally wrote in Java, to .NET / C#. My problem is that I cannot find a C# analog for...
8
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?
3
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...
7
by: Mike Charney | last post by:
I am trying to use the calendar control in Access (Calendar Control 11.0) I have it working but for only one form. I do not know VB/VBA very well, but how can I open the calendar control, which...
1
by: afr0ninja | last post by:
Hello all, and thank you in advance for your assistance. I'm pretty new to access and I'm trying to teach myself some VBA by using various bits of code I find here and there mixed with my own....
1
by: Robert Waggoner | last post by:
My Access 97 database is on a public network so it can be accessed by a dozen users. On my computer the Active X calendar shows the GridFont as 8 pt. On some user's computers the gridfont size is...
16
rcollins
by: rcollins | last post by:
I have a calendar on my form that inputs the date selected. Right now, the date isn't updated until I click on the date box after selecting the date. Is there a way for me to update as I click on the...
76
by: apartain | last post by:
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...
340
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...
1
by: Dalia Allencher | last post by:
I have to plan the work schedule. For example: The process has several steps. Steps Step 1 Step 2 Step 3 Due dates 2/5/2011 2/10/2011 2/15/2011 I want to create a calendar...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.