Thanks to everyone for your help. Turn out while doing work in the database inside of access I sorted the records not using the key which is an autonumber. This was causing the crash.
Access is the database. The program just terminates unexpectedly.
Public Sub Update(rec As clsParts)
mdiInventory.Cursor_Hourglass
Dim found As Boolean
Dim rsTemp As New ADODB.RecordSet
Dim sqlstring As String
rsTemp.Open "Select * from [PartsInv] where...
I'm developing an application that is causing errors only when compiled, and only on computers other than the one I developed it on.
I've narrowed down the problem to the following code. If anyone can help me I would love to hear from you.
SaveRec rsTemp, rec
rsTemp.Update
Private Sub...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.