R
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
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