Access Question - Make Box on Form Take Date from Calendar

traversd · Apr 3rd, 2002, 04:32 AM

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 · Apr 3rd, 2002, 04:46 AM

Quote:

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 · Apr 3rd, 2002, 04:55 AM

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 · Apr 3rd, 2002, 05:02 AM

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 · Apr 3rd, 2002, 05:09 AM

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 · Apr 3rd, 2002, 05:14 AM

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/microsof...gettingstarted

Regards,
Dan

[ This Message was edited by: dk on 2002-04-03 04:14 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 3rd, 2002, 04:32 AM	#1
traversd Board Regular Join Date: Mar 2002 Posts: 82	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

Apr 3rd, 2002, 04:55 AM	#3
traversd Board Regular Join Date: Mar 2002 Posts: 82	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

Apr 3rd, 2002, 05:02 AM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Darren So long as both forms are loaded into memory you can use: Private Sub frmCalendar_Click() frmActions.Text0 = frmCalendar.Value End Sub

Apr 3rd, 2002, 05:09 AM	#5
traversd Board Regular Join Date: Mar 2002 Posts: 82	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

Apr 3rd, 2002, 05:14 AM	#6
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	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/microsof...gettingstarted Regards, Dan [ This Message was edited by: dk on 2002-04-03 04:14 ]