Calendar 9.0

[Arvin Meyer]

There are several calendars with the code to do that on my website:

[url]http://www.datastrat.com/Download/XCalendar2K.zip[/url]
and
[url]http://www.datastrat.com/Download/Calendar2K.zip[/url]

more can be found at Stephen Lebans website:

[url]http://www.lebans.com[/url]

and at the MVP website:

[url]http://www.mvps.org/access[/url]
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
[url]http://www.datastrat.com[/url]
[url]http://www.mvps.org/access[/url]

"Matt" <mattcrighton@era-ltd.com> wrote in message
news:086301c35678$613344c0$a601280a@phx.gbl...

> Could someone please help with the following problem.
>
> I have a form which is called "frmProjectTime", this has a
> field in it called "DateWorked". What happens currently is
> that when the form opens, the user will automatically find
> themselves in the "Dateworked" field ready to enter data.
>
> What I would like to happen is to write some code in
> the "on Enter" button which will take me to my Calendar
> Form, which is the Calendar 9.0. Then when the person
> clicks on the date that is relevant, this will
> automatically, close the calendar form, pass the date
> selected into the "dateworked" field and go to the next
> field that needs to be entered.
>
> In the "On Enter" event procedure I have:
>
> Private Sub DateWorked_Enter()
> DoCmd.OpenForm "frmCalendar"
> End Sub
>
> This opens the calendar OK, but then I cannot get it to,
> pass the date selected back to the "dateworked" field,
> close the frmCalendar and pass to the next field.
>
> Could someone please advise.
>
> Thanks
>
> Matty

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system ([url]http://www.grisoft.com[/url]).
Version: 6.0.504 / Virus Database: 302 - Release Date: 7/24/2003

[MikeB]

This is an oft asked question. I have added an example Access 2k Mdb file with two forms on
my website.
There is a readme file with it and notes in the code.
The Calendar form has the MSCAL.Calendar.7 calendar on it. You can call this calendar from any
form in your app using modifications of the example code provided on the TestForm that is included.
The examples include calling the calendar by command button and by double clicking in the textbox.
Works in standard form mode and datasheet mode.

Goto [url]http://www.byerley.net/BdcDownSup.htm[/url] and scroll down to the AccessCalDemo.zip file.

HTH


"Matt" <mattcrighton@era-ltd.com> wrote in message news:086301c35678$613344c0$a601280a@phx.gbl...

> Could someone please help with the following problem.
>
> I have a form which is called "frmProjectTime", this has a
> field in it called "DateWorked". What happens currently is
> that when the form opens, the user will automatically find
> themselves in the "Dateworked" field ready to enter data.
>
> What I would like to happen is to write some code in
> the "on Enter" button which will take me to my Calendar
> Form, which is the Calendar 9.0. Then when the person
> clicks on the date that is relevant, this will
> automatically, close the calendar form, pass the date
> selected into the "dateworked" field and go to the next
> field that needs to be entered.
>
> In the "On Enter" event procedure I have:
>
> Private Sub DateWorked_Enter()
> DoCmd.OpenForm "frmCalendar"
> End Sub
>
> This opens the calendar OK, but then I cannot get it to,
> pass the date selected back to the "dateworked" field,
> close the frmCalendar and pass to the next field.
>
> Could someone please advise.
>
> Thanks
>
> Matty