P
Pi
Is there a size limit on a query?
This is the query I have attached to a form. When I try to edit it in the
Design View it tells me there isn't enough Memory and I should shut down some
programs.
SELECT TblEQMain.X_datetime_insert, TblEQMain.InsertedBy,
TblEQMain.PropertyNo, TblEQMain.year, TblEQMain.Model,
TblEQMain.Manufacturer, TblEQMain.ReplacementStatus, TblEQMain.description,
TblEQMain.SerialNo, TblEQMain.EquipType, TblEquipType.EquipType,
TblEQMain.TechID, TblEQMain.Unit, TblEQMain.Site, TblEQMain.Agency,
TblEQMain.OpsCode, TblEQMain.ReplCode, TblEQMain.EquipStatus,
TblEQMain.AssociatedEquipID, TblEQMain.Vendor, TblEQMain.WarrantyExpDate,
TblEQMain.PlannedRetireDate, TblEQMain.RetireDate, TblEQMain.PlannedDelDate,
TblEQMain.DeliveryDate, TblEQMain.PlannedInSrvDate, TblEQMain.InServiceDate,
TblEQMain.PurchasePrice, TblEQMain.OutFittingCost, TblEQMain.BaseCost,
TblEQMain.CapitalizedValue, TblEQMain.ReplacementRate, TblTechs.Tech,
TblLocationSite.SiteName, TblLocationUnit.name, TblLocationUnit.Dist,
TblLocationUnit.RSU, TblLocationRSU.name, TblLocationDist.name,
TblLocationRSU.name, TblAccountCodesOpsExp.name FROM TblTechs RIGHT JOIN
(TblLocationRSU RIGHT JOIN ((TblLocationDist RIGHT JOIN TblLocationUnit ON
TblLocationDist.Dist=TblLocationUnit.Dist) RIGHT JOIN (TblLocationSite RIGHT
JOIN (TblEquipType RIGHT JOIN ((TblAccountCodesOpsExp RIGHT JOIN TblEQMain ON
TblAccountCodesOpsExp.ACCT_acct_code=TblEQMain.OpsCode) LEFT JOIN
TblEqMainComments ON TblEQMain.PropertyNo=TblEqMainComments.PropertyNo) ON
TblEquipType.EquipTypeID=TblEQMain.EquipType) ON
TblLocationSite.SiteID=TblEQMain.Site) ON
TblLocationUnit.Unit=TblEQMain.Unit) ON
TblLocationRSU.RSU=TblLocationUnit.RSU) ON TblTechs.TechID=TblEQMain.TechID
WHERE (((TblEQMain.PropertyNo) Like Forms!FrmFilterEQMain!PropertyNo Or
Forms!FrmFilterEQMain!PropertyNo Is Null) And ((TblEQMain.year) Like
Forms!FrmFilterEQMain!year Or Forms!FrmFilterEQMain!year Is Null) And
((TblEQMain.Model) Like Forms!FrmFilterEQMain!Model Or
Forms!FrmFilterEQMain!Model Is Null) And ((TblEQMain.Manufacturer) Like
Forms!FrmFilterEQMain!Manufactuer Or Forms!FrmFilterEQMain!Manufactuer Is
Null) And ((TblEQMain.ReplacementStatus) Like
Forms!FrmFilterEQMain!ReplacementStatus Or
Forms!FrmFilterEQMain!ReplacementStatus Is Null) And ((TblEQMain.SerialNo)
Like Forms!FrmFilterEQMain!SerialNo Or Forms!FrmFilterEQMain!SerialNo Is
Null) And ((TblEQMain.EquipType) Like Forms!FrmFilterEQMain!EquipType Or
Forms!FrmFilterEQMain!EquipType Is Null) And ((TblEQMain.TechID) Like
Forms!FrmFilterEQMain!TechID Or Forms!FrmFilterEQMain!TechID Is Null) And
((TblEQMain.Unit) Like Forms!FrmFilterEQMain!Unit Or
Forms!FrmFilterEQMain!Unit Is Null) And ((TblEQMain.Site) Like
Forms!FrmFilterEQMain!Site Or Forms!FrmFilterEQMain!Site Is Null) And
((TblEQMain.Agency) Like Forms!FrmFilterEQMain!Agency Or
Forms!FrmFilterEQMain!Agency Is Null) And ((TblEQMain.OpsCode) Like
Forms!FrmFilterEQMain!OpsCode Or Forms!FrmFilterEQMain!OpsCode Is Null) And
((TblEQMain.ReplCode) Like Forms!FrmFilterEQMain!ReplCode Or
Forms!FrmFilterEQMain!ReplCode Is Null) And ((TblEQMain.EquipStatus) Like
Forms!FrmFilterEQMain!EquipStatus Or Forms!FrmFilterEQMain!EquipStatus Is
Null) And ((TblEQMain.AssociatedEquipID) Like
Forms!FrmFilterEQMain!AssociatedEquipID Or
Forms!FrmFilterEQMain!AssociatedEquipID Is Null));
This is the query I have attached to a form. When I try to edit it in the
Design View it tells me there isn't enough Memory and I should shut down some
programs.
SELECT TblEQMain.X_datetime_insert, TblEQMain.InsertedBy,
TblEQMain.PropertyNo, TblEQMain.year, TblEQMain.Model,
TblEQMain.Manufacturer, TblEQMain.ReplacementStatus, TblEQMain.description,
TblEQMain.SerialNo, TblEQMain.EquipType, TblEquipType.EquipType,
TblEQMain.TechID, TblEQMain.Unit, TblEQMain.Site, TblEQMain.Agency,
TblEQMain.OpsCode, TblEQMain.ReplCode, TblEQMain.EquipStatus,
TblEQMain.AssociatedEquipID, TblEQMain.Vendor, TblEQMain.WarrantyExpDate,
TblEQMain.PlannedRetireDate, TblEQMain.RetireDate, TblEQMain.PlannedDelDate,
TblEQMain.DeliveryDate, TblEQMain.PlannedInSrvDate, TblEQMain.InServiceDate,
TblEQMain.PurchasePrice, TblEQMain.OutFittingCost, TblEQMain.BaseCost,
TblEQMain.CapitalizedValue, TblEQMain.ReplacementRate, TblTechs.Tech,
TblLocationSite.SiteName, TblLocationUnit.name, TblLocationUnit.Dist,
TblLocationUnit.RSU, TblLocationRSU.name, TblLocationDist.name,
TblLocationRSU.name, TblAccountCodesOpsExp.name FROM TblTechs RIGHT JOIN
(TblLocationRSU RIGHT JOIN ((TblLocationDist RIGHT JOIN TblLocationUnit ON
TblLocationDist.Dist=TblLocationUnit.Dist) RIGHT JOIN (TblLocationSite RIGHT
JOIN (TblEquipType RIGHT JOIN ((TblAccountCodesOpsExp RIGHT JOIN TblEQMain ON
TblAccountCodesOpsExp.ACCT_acct_code=TblEQMain.OpsCode) LEFT JOIN
TblEqMainComments ON TblEQMain.PropertyNo=TblEqMainComments.PropertyNo) ON
TblEquipType.EquipTypeID=TblEQMain.EquipType) ON
TblLocationSite.SiteID=TblEQMain.Site) ON
TblLocationUnit.Unit=TblEQMain.Unit) ON
TblLocationRSU.RSU=TblLocationUnit.RSU) ON TblTechs.TechID=TblEQMain.TechID
WHERE (((TblEQMain.PropertyNo) Like Forms!FrmFilterEQMain!PropertyNo Or
Forms!FrmFilterEQMain!PropertyNo Is Null) And ((TblEQMain.year) Like
Forms!FrmFilterEQMain!year Or Forms!FrmFilterEQMain!year Is Null) And
((TblEQMain.Model) Like Forms!FrmFilterEQMain!Model Or
Forms!FrmFilterEQMain!Model Is Null) And ((TblEQMain.Manufacturer) Like
Forms!FrmFilterEQMain!Manufactuer Or Forms!FrmFilterEQMain!Manufactuer Is
Null) And ((TblEQMain.ReplacementStatus) Like
Forms!FrmFilterEQMain!ReplacementStatus Or
Forms!FrmFilterEQMain!ReplacementStatus Is Null) And ((TblEQMain.SerialNo)
Like Forms!FrmFilterEQMain!SerialNo Or Forms!FrmFilterEQMain!SerialNo Is
Null) And ((TblEQMain.EquipType) Like Forms!FrmFilterEQMain!EquipType Or
Forms!FrmFilterEQMain!EquipType Is Null) And ((TblEQMain.TechID) Like
Forms!FrmFilterEQMain!TechID Or Forms!FrmFilterEQMain!TechID Is Null) And
((TblEQMain.Unit) Like Forms!FrmFilterEQMain!Unit Or
Forms!FrmFilterEQMain!Unit Is Null) And ((TblEQMain.Site) Like
Forms!FrmFilterEQMain!Site Or Forms!FrmFilterEQMain!Site Is Null) And
((TblEQMain.Agency) Like Forms!FrmFilterEQMain!Agency Or
Forms!FrmFilterEQMain!Agency Is Null) And ((TblEQMain.OpsCode) Like
Forms!FrmFilterEQMain!OpsCode Or Forms!FrmFilterEQMain!OpsCode Is Null) And
((TblEQMain.ReplCode) Like Forms!FrmFilterEQMain!ReplCode Or
Forms!FrmFilterEQMain!ReplCode Is Null) And ((TblEQMain.EquipStatus) Like
Forms!FrmFilterEQMain!EquipStatus Or Forms!FrmFilterEQMain!EquipStatus Is
Null) And ((TblEQMain.AssociatedEquipID) Like
Forms!FrmFilterEQMain!AssociatedEquipID Or
Forms!FrmFilterEQMain!AssociatedEquipID Is Null));