Debug Errror

G

Guest

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
 
G

Guest

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
 
G

Guest

Paolo,

How do I register an activex control

Paolo said:
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
Click to expand...
 
G

Guest

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
 
G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Debug and report question 1
Field is not getting value in Access 2007 3
ByPass key ms access 2016 0
Selstart and cursor position 11
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Re Post about Cursor Position and Leaving field 5
Forms ControlSource with DAO 1
Print multiple copies of Word doc 3

Top