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@yahoogroups.com] On Behalf Of A.D. Tejpal
Sent: Tuesday, June 19, 2012 9:03 PM
To: MS_Access_Professionals@yahoogroups.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>
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@yahoogroups.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>
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> , "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@yahoogroups.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>
> 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@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 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>
> 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> , "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]
Tidak ada komentar:
Posting Komentar