Design Mode - Query memory error

[HMArch]

By any chance has anyone come across a problem with opening queries in design mode and access locking up or giving an out of memory error. It only happends when I have more than 14 feilds that I have a criteria statement for. Any suggestions would be appricated.

 

[BillieBurgess]

Please give the Error, it helps

 

[HMArch]

It is a Microsoft Access Error: There isn't enough memory to perform this operation. Close unneeded programs and try the operation again.

I get this when no other program is running and I have 512 of ram. The odd part is I can view the query in table mode just not design mode.


Here is the documenter for the query:
Properties
DateCreated: 6/21/2005 10:48:54 AM
DefaultView: Datasheet
DOL: Long binary data
FrozenColumns: 1
GUID: {guid {5A4208B0-DECE-41B1-885C-4053FF948EBA}}
MaxRecords: 0
NameMap: Long binary data
ODBCTimeout: 60
OrderByOn: False
Orientation: Left-to-Right
RecordLocks: No Locks
RecordsAffected: 0
RecordsetType: Dynaset
ReturnsRecords: True
Type: 0
Updatable: True


SQL

SELECT Projects.ProjectID, Projects.UnderDesign, Projects.AreTheseASetOfPlans, Projects.FillingYear,
Projects.ProjectName, Projects.CustomerID, Projects.ProjectDate, Projects.ProjectDate, Projects.ProjectType,
Projects.HouseStyle, Projects.BasementType, Projects.ComputerFile, Projects.FirstLevel, Projects.SecondLevel,
Projects.LowerLevel, Projects.FutureFinish, Projects.TotalSQ, Projects.TotalSQ, Projects.Master,
Projects.Bedrooms, Projects.Baths, Projects.GarageStalls, Projects.Notes, Projects.Width, Projects.Depth,
Projects.ImageEVE, Projects.ImageBFP, Projects.Image1FP, Projects.Image2FP, Projects.SitePlan,
Projects.Address1, Projects.Address2, Projects.City, Projects.SubDivision, Projects.Street,
Projects.MisClassification, Projects.[A or B], Projects.ABFlatFile, Projects.[C or D], Projects.CDFLatFile
FROM Projects
WHERE (((Projects.UnderDesign)=[Forms]![Seach]![UnderDesign] Or [Forms]![Seach]![UnderDesign] Is Null)
AND ((Projects.AreTheseASetOfPlans)=[Forms]![Seach]![FullPlans] Or [Forms]![Seach]![FullPlans] Is Null) AND
((Projects.ProjectName)=[Forms]![Seach]![ProjectName] Or [Forms]![Seach]![ProjectName] Is Null) AND
((Projects.CustomerID)=[Forms]![Seach]![CustomerSelection] Or [Forms]![Seach]![CustomerSelection] Is Null)
AND ((Projects.ProjectDate)>=[Forms]![Seach]![StartDate] Or [Forms]![Seach]![StartDate] Is Null) AND
((Projects.ProjectDate)<=[Forms]![Seach]![EndDate] Or [Forms]![Seach]![EndDate] Is Null) AND
((Projects.HouseStyle)=[Forms]![Seach]![HouseStyle] Or [Forms]![Seach]![HouseStyle] Is Null) AND
((Projects.BasementType)=[Forms]![Seach]![BasementType] Or [Forms]![Seach]![BasementType] Is Null) AND
((Projects.TotalSQ)>=[Forms]![Seach]![SQFTmin] Or [Forms]![Seach]![SQFTmin] Is Null) AND
((Projects.TotalSQ)<=[Forms]![Seach]![SQFTMax] Or [Forms]![Seach]![SQFTMax] Is Null) AND
((Projects.Master)=[Forms]![Seach]![MasterLocation] Or [Forms]![Seach]![MasterLocation] Is Null) AND
((Projects.Bedrooms)=[Forms]![Seach]![Bedrooms] Or [Forms]![Seach]![Bedrooms] Is Null) AND
((Projects.Baths)=[Forms]![Seach]![Bath] Or [Forms]![Seach]![Bath] Is Null) AND
((Projects.GarageStalls)=[Forms]![Seach]![GarageStalls] Or [Forms]![Seach]![GarageStalls] Is Null) AND
((Projects.Width)<=[Forms]![Seach]![WidthMax] Or [Forms]![Seach]![WidthMax] Is Null) AND
((Projects.Depth)<=[Forms]![Seach]![DepthMax] Or [Forms]![Seach]![DepthMax] Is Null) AND
((Projects.City)=[Forms]![Seach]![City] Or [Forms]![Seach]![City] Is Null) AND
((Projects.SubDivision)=[Forms]![Seach]![SubDivision] Or [Forms]![Seach]![SubDivision] Is Null) AND
((Projects.Street)=[Forms]![Seach]![Street] Or [Forms]![Seach]![Street] Is Null) AND
((Projects.MisClassification)=[Forms]![Seach]![MisClassification] Or [Forms]![Seach]![MisClassification] Is Null));
Query Parameters
Name Type
[Forms]![Seach]![SQFTmin] Text
[Forms]![Seach]![SQFTMax] Text
[Forms]![Seach]![MasterLocation] Text
[Forms]![Seach]![Bedrooms] Text
[Forms]![Seach]![Bath] Text
[Forms]![Seach]![GarageStalls] Text
[Forms]![Seach]![WidthMax] Text

\\Stacie\c\HMA Projects\RR New Design7.mdb Tuesday, June 21, 2005
Query: Search Page: 2
[Forms]![Seach]![DepthMax] Text
[Forms]![Seach]![City] Text
[Forms]![Seach]![SubDivision] Text
[Forms]![Seach]![Street] Text
[Forms]![Seach]![MisClassification] Text
[Forms]![Seach]![UnderDesign] Text
[Forms]![Seach]![FullPlans] Text
[Forms]![Seach]![ProjectName] Text
[Forms]![Seach]![CustomerSelection] Text
[Forms]![Seach]![StartDate] Text
[Forms]![Seach]![EndDate] Text
[Forms]![Seach]![HouseStyle] Text
[Forms]![Seach]![BasementType] Text