ACCESS FEED: RE: [MS_AccessPros] A,D, - An inspiration to me

A.D.

I remember when John announced his retirement here. What a fury! There was much
wailing and gnashing of teeth.

Then he never did leave us. And we're all glad he didn't.

Regards,

Bill

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of A.D. Tejpal
Sent: Saturday, June 23, 2012 9:37 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] A,D, - An inspiration to me - Calendar

Bill,

It would be safe to conclude that John's MVP status is de-facto on lifetime
basis. By renewing it yearly, Microsoft are simply going through the ritual.
They should feel honored and thankful to John for accepting the award.

I suggest that in case of John, if at all the question of retirement from active
participation in the forum rears its head, the decision should not be left to
him alone. It should be subject to ratification by the moderators. In fact, even
his short absence is felt so acutely, that it calls for advance notice on his
part - so that members could brace themselves for the said period.

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

----- Original Message -----
From: Bill Mosca
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
Sent: Sunday, June 24, 2012 02:23
Subject: RE: [MS_AccessPros] A,D, - An inspiration to me - Calendar

John

Twenty consecutive years with one product should earn you a lifetime MVP award.
Guess you couldn't retire then, huh?

Regards,

Bill

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 John Viescas
Sent: Friday, June 22, 2012 11:15 PM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: RE: [MS_AccessPros] A,D, - An inspiration to me - Calendar

Carolyn-

Yeah, well.. Microsoft keeps awarding me MVP status. OK, that's a lame
excuse. Actually, if I get re-awarded in October, I will be the only MVP who
has 20 consecutive years with the same product. Maybe then I'll really retire!

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

----------------------

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 carolyn
Sent: Friday, June 22, 2012 11:02 PM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: [MS_AccessPros] A,D, - An inspiration to me - Calendar

I have been officially retired for almost two years now and I am tired of
Netflix. Have watched everything on Amazon and Hulu and am ready to get
back in the game.

As I understand it, A.D. didn't even get into Access until he retired.
True? Amazing the stuff you do.

So I have just gone to the Company Store and bought my copy of Office 2010
Pro and when it comes I am going to install it. I have Office 2007 now but
haven't clicked on Access since I installed it almost two years ago. Will
do so now. I'm going to start with this Calendar thingy.

Thanks, A.D. You art really an inspiration.

And John V. also. I remember when you said you had retired to France and we
weren't going to be hearing from you much any more. That didn't happen.

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 A.D. Tejpal
Sent: Tuesday, June 19, 2012 9:03 PM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
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
<mailto:ms_access_professionals%40yahoogroups.com>
<mailto:ms_access_professionals%40yahoogroups.com>
<mailto:ms_access_professionals%40yahoogroups.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%40yahoogroups.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>
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Duane
Sent: June 19, 2012 10:52 AM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.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>
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.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%40yahoogroups.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>
<mailto:MS_Access_Professionals%40yahoogroups.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>
<mailto:ms_access_professionals%40yahoogroups.com>
<mailto:ms_access_professionals%40yahoogroups.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%40yahoogroups.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>
<mailto:MS_Access_Professionals%40yahoogroups.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>
<mailto:MS_Access_Professionals%40yahoogroups.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>
<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]

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