Hi All
I have a database that everyone in the office uses daily
I have made a small change to it, so that an order raised in this system can be canceld by a tick box, so i have a small code in the from "on current"
Ever since making the change user have notice that when using find, and the "search only current field" is not ticked (ie search every field) a error box appers saying
There isn;t enough memory to perfomrm this operation. Close unnedded programs and try the operation again
but there are no other programs running.
The database hold 20285 records and the form with the errors has 20 fields and 1 sub form with 6 fields
Any clues ????????
I have a database that everyone in the office uses daily
I have made a small change to it, so that an order raised in this system can be canceld by a tick box, so i have a small code in the from "on current"
Code:
If CANCELED_BOX = -1 Then
Me.Label331.Caption = "Cancelled On"
Me.WO_Can_Lbl.BackColor = 255
Else
Me.Label331.Caption = "Actual Completion Date"
Me.WO_Can_Lbl.BackColor = 12632256
End If
Ever since making the change user have notice that when using find, and the "search only current field" is not ticked (ie search every field) a error box appers saying
There isn;t enough memory to perfomrm this operation. Close unnedded programs and try the operation again
but there are no other programs running.
The database hold 20285 records and the form with the errors has 20 fields and 1 sub form with 6 fields
Any clues ????????