Form freezing

[Ruth Isaacs]

Hello All

I have a split FE/BE A2K mdb, with the FE on 5 PCs. On 4 of the PCs all is
well, but on the 5th there is a problem with one form: the combobox
'CboMoveTo' doesn't work - gives error message "Compile error - method or
data member not found", and the code halts on the line:

If Not IsNull(Me.cboMoveTo) Then

This combobox and the code behind it was created using the wizard, and
taking the option to 'Find a record based on the value selected ...' .


Also on the form, a button that fires an append query and then has the line:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

causes the mdb to freeze on that line - only Ctrl-Alt-Del gets me out.

If I rem out that line, the code behind the button does continue with some
other commands but then halts with the message "Object invalid or no longer
set" on the first line of the following function (and again only
Ctrl-Alt-Del gets me out):

Function fOSMachineName() As String
'Returns the computername
Dim lngLen As Long, lngX As Long
Dim strCompName As String
lngLen = 16
strCompName = String$(lngLen, 0)
lngX = apiGetComputerName(strCompName, lngLen)
If lngX <> 0 Then
fOSMachineName = LEFT$(strCompName, lngLen)
Else
fOSMachineName = ""
End If
End Function


These problems cannot be due to a corrupt FE, because it is identical to the
FEs on the other PCs, where none of these problems occur. I have checked
that all the references are also the same on each PC.

Hope someone can help.
Many thanks
Leslie Isaacs

 

[Ruth Isaacs]

Hello Bonnie

Thanks for your reply.
I don't seem to have scandisk on the PC: should it be part of windows2k?

Les

 

[Leslie Isaacs]

Hello Bonnie

OK - found it - ran it - no difference!

If you have any other suggestions I'd be really grateful.

Thanks again
Les

Hi Leslie,

Programs - Accessories - System Tools - Disk CleanUp (or something close
to
this).

Bonnie
http://www.dataplus-svc.com

Hello Bonnie

Thanks for your reply.
I don't seem to have scandisk on the PC: should it be part of windows2k?

Les

If everything else is the same, try running scan disk to see if there is
a
hardware problem.?

[quoted text clipped - 46 lines]

Many thanks
Leslie Isaacs