ACCESS FEED: Re: [MS_AccessPros] Re: Calendar

You are most welcome Jim! Thanks for the kind words.

Best wishes,
A.D. Tejpal
------------

----- Original Message -----
From: Jim Wagner
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, June 22, 2012 19:35
Subject: Re: [MS_AccessPros] Re: Calendar

A.D.

This database is really awesome. It is going to really help my tasks and projects database a lot. I might need to run an update query to the table from my main tasks table to really be interactive.

Thank You

Jim Wagner
________________________________

________________________________
From: A.D. Tejpal <adtp@airtelmail.in>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, June 22, 2012 1:01 AM
Subject: Re: [MS_AccessPros] Re: Calendar

Jim,

That is a nice suggestion.

I have updated the sample (Crosstab_CalendarStyleTaskPlanner) accordingly. Apart from using existing combo boxes, the user now has the alternative of clicking Next / Prev buttons for year as well as month.

If Next button for month is clicked while it is already at December, the month changes to January, with simultaneous increase of year by one. Similarly, if Prev button for month is clicked while it is already at January, the month changes to December, with simultaneous decrease of year by one.

Best wishes,
A.D. Tejpal
------------

----- Original Message -----
From: Jim Wagner
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, June 21, 2012 22:07
Subject: Re: [MS_AccessPros] Re: Calendar

A.D.

What about having the ability to move to the next or previous months with an arrow instead of choosing from a drop down?

Sorry to infringe on your development design. Just wanted to throw that out for an idea

Jim Wagner
________________________________

________________________________
From: A.D. Tejpal <adtp@airtelmail.in>
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, June 21, 2012 8:55 AM
Subject: Re: [MS_AccessPros] Re: Calendar

You are most welcome Jim! Thanks for kindly checking it out.

Best wishes,
A.D. Tejpal
------------

----- Original Message -----
From: Jim Wagner
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, June 21, 2012 19:31
Subject: Re: [MS_AccessPros] Re: Calendar

A.D.

I just downloaded it. It goes right to the current date. That is awesome. I am thinking of implementing this into my task and project database. I might see if I can change the employees to projects.

Jim Wagner
________________________________

________________________________
From: A.D. Tejpal <adtp@airtelmail.in>
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, June 21, 2012 4:49 AM
Subject: Re: [MS_AccessPros] Re: Calendar

Jim,

Thanks for the corroboration. In the present version, initial focus goes to first Monday on second row - as a safe destination for all combinations of year months.

I have since updated the sample db (Crosstab_CalendarStyleTaskPlanner). On opening the form, current year and current month are shown, and current day of the month gets highlighted. As the user makes selections from the year and month combos, current day is highlighted if the year month combination happens to be current one, otherwise, first day of the selected month gets highlighted.

You might like to verify this behavior in updated version and confirm.

Best wishes,
A.D. Tejpal
------------

----- Original Message -----
From: Jim Wagner
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, June 20, 2012 22:41
Subject: Re: [MS_AccessPros] Re: Calendar

A.D.

I did a fresh download of the database and it works. Not sure what happened. When I open the f_TaskPlan form the highlighted cell is on the 4th of June 2012. Is it supposed to go the current date?

Jim Wagner
________________________________

________________________________
From: A.D. Tejpal <adtp@airtelmail.in>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, June 20, 2012 9:29 AM
Subject: Re: [MS_AccessPros] Re: Calendar

James,

I conducted a trial by fresh download from Roger's site. The sample db is found to work smoothly at my end (Access 2003 on Win XP).

Drop down list for the year combo box holds four years starting from current one, apart from all the earlier years if any data has previously been added. Combo box for months enables selection of desired month. On opening, the form, default values are current year and current month respectively.

What is your version of access? Is the form responding at all? Do you see the drop down lists on clicking the combo boxes? As a first step, you should try out the sample db in its original state, as it is (without making any change). You might like to make another attempt. If still unsuccessful, you could send your downloaded copy to me for further examination.

Best wishes,
A.D. Tejpal
------------

----- Original Message -----
From: Jim Wagner
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, June 20, 2012 19:38
Subject: Re: [MS_AccessPros] Re: Calendar

A.D.

I downloaded that awhile back and I went in to the calendar database and I had some tasks entered and noticed that I could not move to any month other than June. I could go to any year but not any month. Am I doing something wrong?

Jim Wagner
________________________________

________________________________
From: A.D. Tejpal <adtp@airtelmail.in>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, June 19, 2012 9:03 PM
Subject: Re: [MS_AccessPros] Re: Calendar

James,

My sample db named Crosstab_CalendarStyleTaskPlanner might be of interest to you - for providing some working ideas. It demonstrates user interaction directly into individual cells on a form, in a style similar to that for a wall calendar and incorporates generation of corresponding reports - in calendar format. The sample is in Access 2000 file format and is available at Rogers Access Library. Link:
http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45

In this context, two of my other sample db's as mentioned below (both available at the above site) might also be of interest:

(a) Form_VirtualRecordsMatrix
(b) Query_CrosstabAttendanceMarking

Form_VirtualRecordsMatrix incorporates task planner in two styles (a - As per each day of the given month) and (b - As per half hourly time slots on the given day). It uses a modified version of calendar form originally developed by Allen Browne. Following features have been incorporated while implementing the adaptation:

(a) Use of calendar form as a subform.
(b) Mild highlighting (persistent) of today's date - This is in addition to strong highlighting of selected date.
(c) Two way synchronization between calendar subform and task planner subform.

Best wishes,
A.D. Tejpal
------------

----- Original Message -----
From: Wedel, James E
To: ms_access_professionals@yahoogroups.com
Sent: Wednesday, June 20, 2012 04:04
Subject: RE: [MS_AccessPros] Re: Calendar

Thanks Duane

Fortunately the form doesn't need to be editable - just dynamic -
changing with the year of the date that is put on the form. The text box
thing sounds daunting - a minimum of 365 (plus the odd extra one) -
actually is 37 per month given the shift thing that can happen which
makes it 444 for a year.

James Wedel, BSc, RN, COHN(C)

Health Advisor, Employee Health Resource Centre

t | 403-777-7788 ext. 2403

f | 403-777-6065

The contents of this email & any attachment(s) are confidential &
intended for the named recipient only. If you have received this email
in error, please notify the sender immediately, delete this email & do
not copy, use or disclose it.

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane
Sent: June 19, 2012 10:52 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Calendar

James,
It's a bit more difficult to create a form with the calendar style
particularly if you require it to be editable.

When I have needed to do this with a form, I have
-created a totally unbound form with code to fill and format text boxes
-push data to an un-normalized table for display on a continuous form

There are also third party controls you can purchase for this.

Duane Hookom
MS Access MVP

--- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> , "Wedel, James E"
<jewedel@...> wrote:
>
> Hi Duane
>
> Ok I can figure this out to the point of generating the queries and
> tables for this endeavour, but I am coming up short on the form needed
> to display the calendars.
>
> James
>
> From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Wedel,
> James E
> Sent: June 18, 2012 8:55 AM
> To: ms_access_professionals@yahoogroups.com
<mailto:ms_access_professionals%40yahoogroups.com>
> Subject: RE: [MS_AccessPros] Re: Calendar
>
> Thanks - Duane. The one with the x out days is sort of what I was
> looking for; however, I am looking to have it as part of a form versus
a
> report to print out is this possible (I'm thinking it should be
possible
> to do this)? I also need to start the display for a year that starts
in
> August.
>
> I noticed that you need a table for all the dates for the year-I'm
> thinking this can be generated using a loop if a year is not present.
>
> Not quite sure how I will do this but will mess with this. Thanks
again.
>
> James
>
> From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> [mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of
Duane
> Sent: June 15, 2012 7:50 PM
> To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> Subject: [MS_AccessPros] Re: Calendar
>
> I have a sample annual calendar report at
> http://www.access.hookom.net/Samples.htm. It's real basic but might
get
> you started.
>
> Duane Hookom
> MS Access MVP
>
> --- In MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com>
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "James"
> <jewedel@> wrote:
> >
> > I would like to be able to draw out a year's worth of calendars and
> have various dates colored in based on a table of stats, days closed,
> etc. This is not a date picker calendar, just a display of the year.
Are
> there any links to this type of thing already done? If not where would
I
> start?
> >
> > James

[Non-text portions of this message have been removed]