Out of Memory Find ACCESS 97

aingram

Registered User.
Local time
Today, 19:41
Joined
Jun 20, 2005
Messages
29
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"
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 ????????
 

Users who are viewing this thread

Back
Top Bottom