Re: I just installed Office 2003...

Tech-Archive recommends: Speed Up your PC by fixing your registry

1) Try using the all-API date picker Stephen Lebans has at
http://www.lebans.com/monthcalendar.htm instead of the ActiveX control.

2) Make sure you're setting the Caption property of the label. (I just
checked using Access 2003, and it works)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Manuel" <Manuel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C946E2EC-4E53-4052-A211-7B97FB07990C@xxxxxxxxxxxxxxxx
Hi,

I've just installed Access 2003 at home - the install was successful and
I'm
able to open Access without issue. The problem is that when I open a
database that I created at work (database was created using Access 2003),
I
receive several messages.

1st - I have a form which uses the Microsoft Office Date Picker Active X
control. When I open the form at home I receive the following message:

Your database or project contains a missing or broken reference to the
file
'MSCOMCT2.OCX' version 2.0.

When I open References... I see that there is a missing reference for
Microsoft Windows Common Controls-2 6.0 (SP4). And the location of the
'MSCOMCT2.OCX' file is C:\WINNNT\System32\MSCOMCT2.OCX, however, I cannot
find this file in the above directory. Can I download this file from
somewhere?

2nd - on the OnOpen event of a form I have a macro which runs the SetValue
command to assign a value to a label. When I open this form the Action
Failed box appears, and when I click Halt I receive the following error
message:

Run-time error '2770':
The object you reference in the Visual Basic procedure as an OLE object
isn't an OLE object.

Any idea's on how to go about addressing these two issues? The 2nd issue
I
find more disconcerting then the 1st.

Thanks,
Manuel



.

Relevant Pages

  • Re: Working with controls in a word document
    ... Private Sub DoSomething ... You just have to make sure that the Properties/Methods you reference are ... valid for the type of control you're passing to the procedure. ... >> assign any ActiveX control to a an MSForms object of type Control. ...
    (microsoft.public.word.vba.general)
  • Re: access database asctrls.ocx
    ... An ActiveX control is usually added to a form / report ... Now when I try to open my database I get the following error ... Your database or project contains a missing or broken reference to ...
    (microsoft.public.office.misc)
  • RE: Built in function errors.
    ... located on other tabs in a tab control. ... I had to find a way to use the reference. ... TLBs on the client computer. ... reselect libraries simply makes the application not worth building using ...
    (microsoft.public.access.modulesdaovba)
  • Re: Reference forms and fields with variables
    ... There are so many ambiguities here, that it may not really help to follow ... If Field2 is a field in the underlying recordset, ... but the reference is unstable. ... LinkChildFields property of a subform is NOT represented by a control in the ...
    (microsoft.public.access.formscoding)
  • RE: f7s4r4v
    ... speaking this is a reference to the current instance of the class, ... Similarly any references to a control on the form simply by the ... Private Sub Form_AfterUpdate ... intSecond As Integer) ...
    (microsoft.public.access.gettingstarted)