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

[SC in Texas]

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]

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

 

[Tony Toews [MVP]]

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
--
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]

Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.

 

[supoch]

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

 

[supoch]

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