Carolyn
You understood correctly. A.D. took up Access as a hobby after he retired. And he tends to take on big challenges, leaving the simple stuff to the rest of us here. :O)
You didn't miss anything by not using 2007. What a dog! (No offense to the canine population). 2010 has some amazing features, but when you come right down to it, it's the basic application that gets used and not much of that has changed.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca
--- In MS_Access_Professionals@yahoogroups.com, "carolyn" <carolamrt@...> wrote:
>
> 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