Hi Crystal, I've downloaded your PopupCalendar_Crystal_120627_230p.accdb
but when I double-click the DateandTime1 text box on
f_PopupCalendar_Test the f_PopupCalendar should open up because of
Private Sub DateAndTime1_DblClick(Cancel As Integer)
'120627
DoCmd.OpenForm "f_PopupCalendar"
End Sub
but it doesn't, am I missing something?
Giorgio
--- In MS_Access_Professionals@yahoogroups.com, Crystal
<strive4peace2008@...> wrote:
>
> Hi James,
>
> Popup Calendar that works with Access 2007 and above!
>
> I posted a Popup Calendar form here:
>
>
http://tech.groups.yahoo.com/group/MS_Access_Professionals/files/Crystal\
/
>
> PopupCalendar_Crystal_120627_ACCDB.zip
>
>
>
>
>
>
>
>
>
>
>
> f_PopupCalendar_Test loads automatically when this database is opened.
>
> To use this feature in another database, import:
> f_PopupCalendar.
>
> I
> usually assign this Double-Click [Event Procedure] to each date
control:
> DoCmd.OpenForm "f_PopupCalendar"
>
> the popup calendar reads the ActiveControl to get date and,
optionally, time. When OK is clicked on the popup calendar, the control
you came from is updated with what was chosen.
>
> Feedback is appreciated, thank you.
>
>
> Warm Regards,
> Crystal
>
> http://www.AccessMVP.com/strive4peace
>
> *
> (: have an awesome day :)
> *
>
>
>
> ________________________________
> From: Crystal
> Sent: Friday, June 15, 2012 9:29 PM
> Subject: Re: [MS_AccessPros] Re: Calendar
>
>
> Hi James,
>
> I have recently written a replacement for the ActiveX Calendar control
that was depreciated in 2007. I still have to pull it out of where it
is and write an interface to hook it up to resident tables ... Pat Wood
is going to help me ;) Ideally that will get done in the next couple
weeks -- I'll post it on RogersAccessLibrary.com (MVP Libraries) and
here ... so check periodically if you are still looking for ideas
>
>
> If you are wanting something that is capable of colorful reporting, I
have code to output data from a query that you specify to HTML format
and it lets you set colors ... it isn't posted yet but I will try to
remember to dig that out too
>
> Warm Regards,
> Crystal
>
> http://www.AccessMVP.com/strive4peace
>
>
> *
> (: have an awesome day :)
> *
>
>
> ________________________________
> From: Duane duanehookom@...
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Friday, June 15, 2012 7:49 PM
> 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, "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]
>
Tidak ada komentar:
Posting Komentar