A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

calendar showing multiple months



 
 
Thread Tools Display Modes
  #1  
Old March 18th, 2010, 08:43 PM posted to microsoft.public.access
Mark Andrews[_4_]
external usenet poster
 
Posts: 169
Default calendar showing multiple months

I'm looking for a calendar that will let a user pick MULTIPLE days from a
large calendar (6 months or maybe a year).

Stephen Lebans version looks good except I don't think it supports multiple
day selecting. The days selected might be the first wednesday of each month
for 5 months for example.

I would use this to then create records in the database for those days
selected.

Can anyone point me to a NON ActiveX version.

I already know of some good activeX versions (but hoping to avoid using
ActiveX for this project, since I only need date selection).


Mark

  #2  
Old March 18th, 2010, 09:12 PM posted to microsoft.public.access
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default calendar showing multiple months

Stephen's implementation of the built-in Windows calendar supports picking
multiple days.

Open the Customer form in his example and double-click on the date in the
"Show Range of Dates" area.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Mark Andrews" wrote in message
...
I'm looking for a calendar that will let a user pick MULTIPLE days from a
large calendar (6 months or maybe a year).

Stephen Lebans version looks good except I don't think it supports
multiple day selecting. The days selected might be the first wednesday of
each month for 5 months for example.

I would use this to then create records in the database for those days
selected.

Can anyone point me to a NON ActiveX version.

I already know of some good activeX versions (but hoping to avoid using
ActiveX for this project, since I only need date selection).


Mark



  #3  
Old March 18th, 2010, 09:52 PM posted to microsoft.public.access
Mark Andrews[_4_]
external usenet poster
 
Posts: 169
Default calendar showing multiple months

Doug,

I only see that you can select a continuous range of dates. Example March
17 thru 22
I want to select March 17, March 24, April 13

Am I missing something?
Mark

"Douglas J. Steele" wrote in message
...
Stephen's implementation of the built-in Windows calendar supports picking
multiple days.

Open the Customer form in his example and double-click on the date in the
"Show Range of Dates" area.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Mark Andrews" wrote in message
...
I'm looking for a calendar that will let a user pick MULTIPLE days from a
large calendar (6 months or maybe a year).

Stephen Lebans version looks good except I don't think it supports
multiple day selecting. The days selected might be the first wednesday
of each month for 5 months for example.

I would use this to then create records in the database for those days
selected.

Can anyone point me to a NON ActiveX version.

I already know of some good activeX versions (but hoping to avoid using
ActiveX for this project, since I only need date selection).


Mark



  #4  
Old March 19th, 2010, 12:27 AM posted to microsoft.public.access
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default calendar showing multiple months

Sorry, I don't have the time to go through his code at the moment, but I
seem to recall that there was a way to bold specific days: there's a private
type defined in class module clsCalendar, if memory serves.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Mark Andrews" wrote in message
...
Doug,

I only see that you can select a continuous range of dates. Example March
17 thru 22
I want to select March 17, March 24, April 13

Am I missing something?
Mark

"Douglas J. Steele" wrote in message
...
Stephen's implementation of the built-in Windows calendar supports
picking multiple days.

Open the Customer form in his example and double-click on the date in the
"Show Range of Dates" area.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Mark Andrews" wrote in message
...
I'm looking for a calendar that will let a user pick MULTIPLE days from
a large calendar (6 months or maybe a year).

Stephen Lebans version looks good except I don't think it supports
multiple day selecting. The days selected might be the first wednesday
of each month for 5 months for example.

I would use this to then create records in the database for those days
selected.

Can anyone point me to a NON ActiveX version.

I already know of some good activeX versions (but hoping to avoid using
ActiveX for this project, since I only need date selection).


Mark




  #5  
Old March 19th, 2010, 01:25 PM posted to microsoft.public.access
Mark Andrews[_4_]
external usenet poster
 
Posts: 169
Default calendar showing multiple months

Ok I found this post by Stephen Lebans when searching to see if someone ever
changed it to allow for multiple day selection:

"Boris you would have to modify my Calendar but it does expose the
DayState property which can be used to mark multiple days. The issue
would be to modify the Calendar to only close when the "Close Calendar"
button/menu is clicked. Additonally, you would have to use the exposed
MCN_SELCHANGE message to raise an event in the MonthCalendar class. From
this event you would update the DayState property to include the date
the user just clicked on."

Anyone feel like giving this a try? I'm torn between going down this route
or just using the activeX control
I know works well.

Mark


"Douglas J. Steele" wrote in message
...
Sorry, I don't have the time to go through his code at the moment, but I
seem to recall that there was a way to bold specific days: there's a
private type defined in class module clsCalendar, if memory serves.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Mark Andrews" wrote in message
...
Doug,

I only see that you can select a continuous range of dates. Example
March 17 thru 22
I want to select March 17, March 24, April 13

Am I missing something?
Mark

"Douglas J. Steele" wrote in message
...
Stephen's implementation of the built-in Windows calendar supports
picking multiple days.

Open the Customer form in his example and double-click on the date in
the "Show Range of Dates" area.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Mark Andrews" wrote in message
...
I'm looking for a calendar that will let a user pick MULTIPLE days from
a large calendar (6 months or maybe a year).

Stephen Lebans version looks good except I don't think it supports
multiple day selecting. The days selected might be the first wednesday
of each month for 5 months for example.

I would use this to then create records in the database for those days
selected.

Can anyone point me to a NON ActiveX version.

I already know of some good activeX versions (but hoping to avoid using
ActiveX for this project, since I only need date selection).


Mark



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:00 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.