Combo box problem

[Kirstie Adam]

Dear All,

Since yesterday afternoon i have been unable to use a combo box, or create
one.
If i try to use one (in ANY database) i get "Run Time Error 429" and it asks
me to debug.
When i try to create a combo box using the controls wizard, i get the
message
"Activex compent can't create object"

Can anyone help?

Kirstie

 

[Drew]

check your reference in VBA window. Your are probobly
missing the ActiveX reference and the API call will not
work.

Drew

 

[Kirstie Adam]

Drew,

Sorry, but i don't understand. The coding looks fine to me.

Private Sub Combo7_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[Nominal] = " & Str(Nz(Me![Combo7], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

Can you tell me what's wrong?

Kirstie

 

[Kirstie Adam]

If, when i am in VB window, i go to tools-references, then there are four
options ticked
1. Visual Basic for Applications
2. Microsoft Access 10.0 Object Library
3. OLE Automation
4. Microsoft ActiveX Data Object 2.1 Library

Is this correct, or should i have something else in there ticked too?

Kirstie

 

[Kevin]

Kirstie,

Drew was refering to the application reference libraries.
Open a vba window (any code page will work). Go to Tools,
References. If one was previously there but is now gone,
it will show as MISSING in the list of reference
libraries. There should be one there for ActiveX
Components.

Hope this helps!

Kevin

 

[Drew]

There is a newer version of the Active X Ojbects. IT is
now at 2.5. Your refs are depending on what you need and
the controls you have on your form. The current project
I am working on has over 15 differents refs.

 

[Kirstie Adam]

Kevin & Drew,

I have selected 2.5, but it doesn't make a difference, and there also isn't
any saying missing.
Could it be anything else?
At this rate, the only other thing i can think to do is uninstall and
reinstall the whole program.

Kirstie