Error 3270

  • Thread starter Thread starter hje
  • Start date Start date
H

hje

*sigh*

Have a beautifully working database, finally, thanks to a
lot of help from these boards. It is created in Access
2000 on my laptop.

Transferred the whole lot to the network for test
implementation, which has Access 2003 on it. Now I am
getting an error message 3270 Property Not Found. This
happens when a command button is selected (this command
button has been coded that on a click, does the following:

Private Sub Delete_Button_Click()
On Error GoTo Err_Handler
If MsgBox("Are you sure you want to delete this
record?", _ vbQuestion + vbYesNo, "Delete Record?") _ =
vbYes _

Then
DoCmd.SetWarnings False
RunCommand acCmdDeleteRecord
End If

Exit_Point:
DoCmd.SetWarnings True
Exit Sub

Err_Handler:
MsgBox Err.Description, vbExclamation, "Error " &
Err.Number
Resume Exit_Point

End Sub

I retested it on the laptop, and the command button works
fine.

Is there a problem with this code in 2003 that I am
unaware of? How do I correct this?

Thanks in advance for any help!!!
 
In VB check and make sure that the desktop has exactly the same references
under tools in visual basic, and that the order of the references is the
same as the ones on your laptop.

It is the one area I often forget to check and get caught out. It would be
nice if there were a way to have the references loaded automatically when
the database is run.

But try that check first.
 
Tested in A2003 (beta) with the line breaks removed. The code works fine.

Open the database on the computer where it fails, and see if the code
compiles. Comment out the error handler, so you can see exactly which line
generates the error.
 
Back
Top