Debug Errror

[Bryan]

I need some help with the following

When I open this DB and click on a label which supposed to open a calendar
form I'm getting the following error message

1. there is no object in the control and it give me 3 option 1. end, 2.
Debug, 3. Help

when I click on Debug it brings me to the following codes.

Private Sub Label36_Click()

If Me.frm_DateChooser.Visible = False Then
Label36.Caption = "Hide Calendar..."
Me.frm_DateChooser.Visible = True
Forms!frm_MainScreen!frm_DateChooser.Form.src = "main"
If Text34 <> "" Then
Forms!frm_MainScreen!frm_DateChooser.Form.ActiveXCtl2 = Text34
Else
Forms!frm_MainScreen!frm_DateChooser.Form.ActiveXCtl2 = Date
End If
Else
Label36.Caption = "Show Calendar..."
Me.Text34.SetFocus
Me.frm_DateChooser.Visible = False
End If

End Sub

with the following line in yellow -
Forms!frm_MainScreen!frm_DateChooser.Form.ActiveXCtl2 = Date
End If

Can some one pls tell me what I need to do so I can fix this problem

thank You

 

[Paolo]

Hi Bryan,

I would suggest you to verify that the activex control used on the form is
correcly registered on the computer, 'cause usually this error is raised when
the control is not found

HTH Paolo

 

[Bryan]

Paolo,

How do I register an activex control

Hi Bryan,

I would suggest you to verify that the activex control used on the form is
correcly registered on the computer, 'cause usually this error is raised when
the control is not found

HTH Paolo

 

[Paolo]

Well, if my memory serves me well you open a VBA window, tools, references.
There you click on browse and you navigate to the directory containing the
library you choose it and your activex will be registered and available.

HTH Paolo

 

[Bryan]

Paolo,

Thank you for your help. I however have a few more question on this
application as you can tell I'm not an access person and we need this done
asap. I will compensate you for your time and help. Please feel free to call
me at 847-323-7731

thank You

 

[Paolo]

Bryan,

I'm sorry but I can't call. I answer question on this community in spare
time to share knowledge but I don't give advices on phone.

Regards Paolo

 

[Bryan]

Do you have an email where we can chat or do you have yahoo chat

 

[Paolo]

I don't give private advices.

Do you have an email where we can chat or do you have yahoo chat