MS Access 2013 crashes continually on different computers.

You know... try opening in Acces 2010, I'd be surprised if it worked there and not in Access 2013.

 

Thanks for the kind words.

Gina,

I'm not sure what the solution is behind the main issue of this thread, but I have encountered the same problems and have determined somewhat of a workaround.  When I initially open a Table, Query, Form or Report from the left navigation menu it works perfectly.  But sometimes changing a view of an opened tab will create the issue of "Not Responding" for many seconds and sometimes minutes.

How I've worked around this is to save and close the tab, then Re-open it from the left menu into the desired view.  It's not efficient but it surprisingly works.  However, I'm not sure why.  At least it has become manageable as I can now work for more than 5 minutes without a freeze.

You know... try opening in Acces 2010, I'd be surprised if it worked there and not in Access 2013.

Thanks for the kind words.

Okay, I am stumped!  There is nothing in that code that is a problem or that should cause a problem.  Have you tried Debug > Compile to see if any errors present themselves?

No, I haven't. I'll check that out.

Last question if I may, do you think switching to Access 2010 might...... just maybe fix the problem?

Gina thank you very much, I appreciate you spending the time trying to help me. I'm grateful.

I also appreciate the existence of this forum so that people can get answers to their problems, you help so many. Keep up the good work.

Okay, I am stumped!  There is nothing in that code that is a problem or that should cause a problem.  Have you tried Debug > Compile to see if any errors present themselves?

Is this a split database?  Have you tried refreshing the links?  The Form you are opening, does it have code behind it?  Can you copy/paste that code here?

It's not a split database. There are five forms with a similar purpose and function. The issue is with all five of them. Here is the code behind one.

Option Compare Database

Option Explicit

Private Sub Form_Load()

'this will assign any checkbox ticks to the assigned Pool fence defect listids for this inspection record when the form first opens

On Error GoTo errtrap

Dim sListid As String

Dim rst As DAO.Recordset

Set rst = Me.Recordset

With rst

Do Until .EOF

sListid = rst!ListID

If InStr(gsNotInspDefectListids, sListid) > 0 Then  ' this defect was not inspected

cboResultStatus.SetFocus

cboResultStatus.Text = "Not Inspected"

ElseIf InStr(gsPassDefectListids, sListid) > 0 Then ' this defect was passed

cboResultStatus.SetFocus

cboResultStatus.Text = "Passed"

ElseIf InStr(gsDefectListids, sListid) > 0 Then ' this defect was failed

cboResultStatus.SetFocus

cboResultStatus.Text = "Failed"

Else

cboResultStatus.SetFocus    ' has never been asigned value

cboResultStatus.Text = "Not Inspected"

End If

.MoveNext

Loop

.MoveFirst ' move back to first record on form

Me.Filter = "ResultStatus = 'Failed'"  ' filter records on open

Me.FilterOn = True

'.Close

End With

'Set rst = Nothing

Exit Sub

errtrap:

MsgBox "Error from Form_load sub = " & Err.Number & Err.Description, vbCritical

Exit Sub

End Sub