Re: Displaying and modifying 1:N data in forms?

stephan.vanbeerschoten@xxxxxxxxx wrote in
news:1125418355.993736.175940@xxxxxxxxxxxxxxxxxxxxxxxxxxxx:

> Don't worry about the line. It were form deviding lines,
> controlled by a boolean that I found and set to false.
>
> I have one more thing I need to figure out, perhaps someone
> can help me with this too. I have a subform with several
> TextBoxes that hold dates. I want a
> calender to become visible when users dblclick on it, and be
> able to pick a date etc etc. I have all of this working in a
> test form I created, but my real form situation is a little
> different:
>
> I don't have space on my subform to create the calender, so I
> placed the calendar
> on the main (parent) form. I was able to control the
> calender's properties from
> the sub form by using Parent.Calender.Visible=True etc, but
> how can I do the reverse?
> How can I modify the TextBoxes in my subform based on a date I
> select on the Calendar (on the parent form) so I can do
> something like: subForm.TextBox.Value = Calendar.Value
>
> Thanks,
> Stephan
>
> Reply
>
see http://www.mvps.org/access/forms/frm0057.htm or just
download the application
databasehttp://www.mvps.org/access/downloads/datepicker.zip

It is a popup calendar. I suppose you could embed it into your
form, but It's just wonderful on continuous forms as it is.



--
Bob Quintal

PA is y I've altered my email address.
.

Relevant Pages

  • Re: How to access a control from subform
    ... When I step through the modules startdate_click closes before calendar click ... helpful, but, where you say <"Grades" is the name of the control that holds ... the subform> It sounds like you are saying that this is NOT the subform ... Private Sub StartDate_click ...
    (microsoft.public.access.formscoding)
  • Re: Calendar code not working
    ... the workbook or worksheet being protected (you also checked the workbook, ... and Insert controls, in the ActiveX controls I have listed "Calendar Control ... I do have the mscal.ocx file on my office computer. ...
    (microsoft.public.excel.misc)
  • Re: Calendar code not working
    ... I chose to "Repair" the installation and the Calendar control now works ... I presume it's hidden within the sheet somehow and you need ... I do have the mscal.ocx file on my office computer. ...
    (microsoft.public.excel.misc)
  • RE: Actual Date
    ... control is populated programmatically as it is in this case. ... The only thing wrong with that is that now the calendar ... Private Sub cmdMonthDown_Click ... Select Case KeyCode ...
    (microsoft.public.access.gettingstarted)
  • Re: Calendar code not working
    ... I had tried to insert the Calendar by being in design mode. ... The Calendar control really confuses me as, where does it go when you do ... Objects have been inserted into a sheet. ... I do have the mscal.ocx file on my office computer. ...
    (microsoft.public.excel.misc)