Access Question - Make Box on Form Take Date from Calendar

[traversd]

Hi,

I've been working on a little app in Access and am trying to make a textbox take the date from the ActiveX Calendar supplied within "More Tools" in access. But have no idea where to start. Anyone got any ideas ?

Cheers
Darren

 

[dk]

I've been working on a little app in Access and am trying to make a textbox take the date from the ActiveX Calendar supplied within "More Tools" in access. But have no idea where to start. Anyone got any ideas ?

Hi,

If the calendar control is called MyCalendar and the textbox is called text0 put this code in the form's code module i.e. right click it and choose Build Event.

Private Sub MyCalendar_Click()
With Me.Text0
.SetFocus
.Value = Me.MyCalendar.Value
End With
End Sub

HTH,
Dan

 

[traversd]

Dan,

Thanks for the reply.

Nothing happened there, so i'll try a little more detail.

I have a form called frmActions and a from called frmCalendar

I have re-named the text box on the actions form to Text0 and the Calendar on frmCalendar to MYCalendar to match the code snippet you gave me.

Would there be other changes with that info ?

Cheers
Darren

 

[Dave Hawley]

Hi Darren

So long as both forms are loaded into memory you can use:

Private Sub frmCalendar_Click()
frmActions.Text0 = frmCalendar.Value
End Sub

 

[traversd]

Hi Dave,

when I try to compile that, I get an error message that says variable not defined and highlights the frmCalendar word in the middle line of the code. Any Ideas ?

Thanks
Darren

 

[dk]

Hi,

I tried doing this:-

Private Sub MyCalendar_Click()
Form_frmActions.Text0.Text = Me.MyCalendar.Value
End Sub

but got an Out Of Memory error (!?)

I'm still learning Access and am in no way a guru. You'll get a quick and easy response if you post your question here:-

news://msnews.microsoft.com/microsoft.public.access.gettingstarted

Regards,
Dan
This message was edited by dk on 2002-04-03 04:14