Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can anyone explain what might cause

Status
Not open for further replies.

Pire

Technical User
Sep 29, 2002
13
0
0
US
Can anyone explain what might cause an "Error accessing file. Network Connection may have been lost" error?

The debugger takes me to this script:

Private Sub Command255_Click()
On Error GoTo Err_Command255_Click


DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70

Exit_Command255_Click:
Exit Sub

Err_Command255_Click:
MsgBox Err.Description
Resume Exit_Command255_Click

End Sub

I also get it when trying to select a record using a combo box and debugger points to:

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

Set rs = Me.Recordset.Clone
rs.FindFirst "[PROJ_PKEY] = " & Str(Me![Combo2303])
Me.Bookmark = rs.Bookmark
End Sub

All of my tables are in the database. How can I get a network error?

Thanks,
Trent
 
DoMenuItem is in affect deprecated, so for starters I would upgrade it to RunCommand which is meant to be its replacement, hopefully this might fix part of your problem or give you a more meaningful error message.
 
Thanks, Celtc. That doesn't seem to be the problem but I have made the change and appreciate the advice.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top