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 / July 2005

Tip: Looking for answers? Try searching our database.

Open form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Scott Viney - 15 Jul 2005 20:44 GMT
Hi All,

I have a subform datasheet view.  One row holds a date.  I have created a
form with only the calendar control on it.

What I want to do is when the user clicks the date, the form with the
calendar is opened and then the date chosen is placed in the date field of
the subform.

How do I do this?  I know I have to use the mousedown event.  But I dont
know how to get the other form to open and then pass back the value selected
in the calendar.

Any help would be appreciated

Cheers,
Scott V
Wayne Morgan - 15 Jul 2005 21:29 GMT
For something that works better than the calendar control, I recommend the
following by Stephen Lebans.

http://www.lebans.com/monthcalendar.htm

For the reason to use this over the calendar control, see this link. This
link also has another one to an example of using the calendar control.

http://www.granite.ab.ca/access/calendars.htm

Signature

Wayne Morgan
MS Access MVP

> Hi All,
>
[quoted text clipped - 13 lines]
> Cheers,
> Scott V
 
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.