Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / August 2008

Tip: Looking for answers? Try searching our database.

How can I set an ActiveX calendar for the Friday of week form is o

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
SC in Texas - 21 May 2008 16:52 GMT
How can I set an ActiveX Calendar for the Friday of the week that the form is
opened on.

This is for a report that is a sign up sheet for a weekly event.

I have set to current date with:
Me!CalendarX.value = Date

But what formula do I use to always get Friday.
Thanks,
Steve Callahan
Lubbock,Texas
SC in Texas - 21 May 2008 17:12 GMT
I made a formula that works:
Me!Calendar0.Value = DateSerial(YEAR(Date), Month(Date), Day((DatePart("ww",
(Date), vbSaturday) - 1) * 7) + 4)

Once again posting the questions broke the ice of a brain freeze.

Thanks anyway for anyone who is trying to help.
And for anyone with similar problems. I hope this helped.
SC

> How can I set an ActiveX Calendar for the Friday of the week that the form is
> opened on.
[quoted text clipped - 8 lines]
> Steve Callahan
> Lubbock,Texas
Tony Toews [MVP] - 26 May 2008 20:00 GMT
>How can I set an ActiveX Calendar for the Friday of the week that the form is
>opened on.

See the Calendar Tips page at my website
http://www.granite.ab.ca/access/calendars.htm

There could, likely will, be lots of version problems when you go to
distribute the MSCal.OCX..  

One alternative is MonthCalendar is a completely API generated Month
Calendar derived directly from the Common Control DLL.  There are
links to several downloadable calendar forms at my website.   As these
are forms you can also do anything with them you want.

You can also use the calendar form which comes in the Access <insert
your version here> Developers Handbook by Litwin/Getz/Gilbert,
publisher Sybex  www.developershandbook.com.  These books are well
worth spending money.  Every time I open one I save the price of the
book.

Duane Hookum has an awesome and simple calendar in a report.  See the
Calendar Reports sample section at
http://www.access.hookom.net/Samples.htm

Tony
Signature

Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
  Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Jan Baird - 27 May 2008 20:51 GMT
Jan Baird is out of the country until September 20.   Every effort will be
made to respond to messages, but please be patient.
supoch - 22 Aug 2008 06:02 GMT
> How can I set an ActiveX Calendar for the Friday of the week that the form
> is
[quoted text clipped - 9 lines]
> Steve Callahan
> Lubbock,Texas
Linq Adams - 22 Aug 2008 15:09 GMT
A little less cumbersome:

Me.Calendar0 = Date - Weekday(Date, vbFriday) + 1

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

supoch - 29 Aug 2008 19:45 GMT
> How can I set an ActiveX Calendar for the Friday of the week that the form
> is
[quoted text clipped - 9 lines]
> Steve Callahan
> Lubbock,Texas
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.