Error on all but one machine...

[diamondgator]

I have a weird challenge.
All computers are running XP sp 3, and the latest updates for Office.
The file was initally created in A2002. the entire office currently has
A2003, with the exception of a couple of people (A2007) who do not use this
file.

I can open a specific Access DB on my computer fine with no errors.
I did not create the file.
Everyone else gets a compiling error upon trying to open it.


I have, on my computer, attempted to convert the A2002 file to A2003
version. I got no errors but it did not help.
The Database does not use a switchboard, but uses a noded form (frmTree) to
do most functions.

The Compiling error says that it cannot find the project or library and it
highlights the first "StrConv" in the following code (from the basTree module)
______________________________________
'Create necessary Key and Relative strings.
'StrConv() allows for potential Text values as keys.
Do Until .EOF
If Not noKey Then strkey = _
StrConv(fldKey, vbLowerCase) & "L" & LvlNum
If Not noParent Then strRelative = _
StrConv(fldParent, vbLowerCase) & "L" & (LvlNum - 1)

'Add the node.
Set objNode = ctlTree.Nodes.Add(Text:=.Fields(TxtField))
With objNode
'Set Key and Parent properties when necessary
If Not noKey Then .Key = strkey
If Not noParent Then
Set .Parent = ctlTree.Nodes(strRelative)
.Parent.Sorted = True
End If
End With
.MoveNext
Loop
..Close
End With

Set fldKey = Nothing
Set fldParent = Nothing
Set fldText = Nothing
Set objNode = Nothing
Set Rst = Nothing
Db.Close
Set Db = Nothing

End Sub
_________________________________

if I merely exit the debugger, I can acces the DB but without the directory
form.

-- update now I right clicked on highlighted term and chose "List
Properties/Methods" from the menu and then selected the exact same term. then
saved the module. Now on other computers will not open up. Still opens on
mine just fine. Thankfully I have a backup. Grrr....

 

[diamondgator]

Sorry, File was initially in A2000 format, not A2002

~ Rich

 

[Douglas J. Steele]

Any time an application works on one machine but not on another (or used to
work on a machine and suddenly stops working), the first thing to do is
check the References collection.

While in the VB Editor, select Tools | References from the menu bar.

If any of the selected references (the ones with the check marks in front of
them at the top of the list) have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected.

NOTE: write down what the references are before you delete them, because
they'll be in a different order when you go back in!

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


"(e-mail address removed)"

 

[Tony Toews [MVP]]

(e-mail address removed)

Set objNode = ctlTree.Nodes.Add(Text:=.Fields(TxtField))

So you're using a Treeview control here.

You likely got hit by a killbit set on an older version of the
mscomctl.ocx file.

See if the version at Visual Basic 6.0 Service Pack 6 Runtime Extended
Files http://support.microsoft.com/?kbid=957924 fixes the problem.

Tony