Kamlesh Jain
asked on
Slow loading of form (Split form)
Hello Experts,
I am using a Split Form. (Screen Shot attached). The form uses 8 to 10 conditional formatting of the data, like changing colour , depending upon the value.
DOES it slows down the loading of the form ?
To add: The header of the form also contains some little bit of calculations, on current event.
The record set comprises of around 1100 records only. Whereas i have another similar form with more than 5500 records, but that doesnt slow down.
for more clarity, i am attaching herewith the screen shots :
in Design Mode
in Form Mode
in Form Properties setting mode
Below is the query used in the form :
SELECT ([tblpurchase].[pur_qty]-( select NZ(sum(tblsale.[sale_qty]) ,0) from tblsale where tblsale.[po_no] = tblpurchase.[PO_No])) AS Salable, Val((select NZ(sum(tblsale.[sale_qty]) ,0) from tblsale where tblsale.[po_no] = tblpurchase.[PO_No])) AS Sale, Val((select NZ(sum(tbllifting.[Lift_qt y]),0) from tbllifting where tbllifting.[po_no] = tblpurchase.[PO_No])) AS Lifted, Val((select NZ(sum([tblBillEntryFiled] .[BE_QTY]) ,0) from tblBillEntryFiled where tblBillEntryFiled.[po_no] = tblpurchase.[PO_No])) AS BEFiled, ([tblpurchase].[pur_qty]-( select NZ(sum([tblLifting].[Lift_ Qty]),0) from tbllifting where tbllifting.[po_no] = tblpurchase.[PO_No])) AS Net_Unlifted, Val((select NZ(sum([tblBillEntryFiled] .[BE_QTY]) ,0) from tblBillEntryFiled where tblBillEntryFiled.[po_no] = tblpurchase.[PO_No]))-Val( (select NZ(sum(tblsale.[sale_qty]) ,0) from tblsale where [tblSale].[BT_Tax] = 'Tax' and tblsale.[po_no] = tblpurchase.[PO_No])) AS Tax_Stock, Val((select NZ(sum(tblsale.[sale_qty]) ,0) from tblsale where [tblSale].[BT_Tax] <> 'tax' and tblsale.[po_no] = tblpurchase.[PO_No])) AS BT_Sale, [pur_Qty]-[BT_Sale]-[BEFil ed] AS BT_Stock, *
FROM tblpurchase
ORDER BY tblpurchase.PO_Date DESC;
Also, i want the form to load as fresh and all filters used in previous session shall be cleared. Sometimes, filters used in lst 3/4 sessions get loaded and i have to run the query "Show All" to re cofnirm that records are loaded a fresh. How can i ensure that the form loads all the data, when the form is opened ?
Your kind guidance will be helpful.
Thanking you,
Kamlesh Jain
I am using a Split Form. (Screen Shot attached). The form uses 8 to 10 conditional formatting of the data, like changing colour , depending upon the value.
DOES it slows down the loading of the form ?
To add: The header of the form also contains some little bit of calculations, on current event.
The record set comprises of around 1100 records only. Whereas i have another similar form with more than 5500 records, but that doesnt slow down.
for more clarity, i am attaching herewith the screen shots :
in Design Mode
in Form Mode
in Form Properties setting mode
Below is the query used in the form :
SELECT ([tblpurchase].[pur_qty]-(
FROM tblpurchase
ORDER BY tblpurchase.PO_Date DESC;
Also, i want the form to load as fresh and all filters used in previous session shall be cleared. Sometimes, filters used in lst 3/4 sessions get loaded and i have to run the query "Show All" to re cofnirm that records are loaded a fresh. How can i ensure that the form loads all the data, when the form is opened ?
Your kind guidance will be helpful.
Thanking you,
Kamlesh Jain
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Suggestions to solve the issue provided.
ASKER
Can some one please guide me any good resource / example for using Sub form.
My subform will not be for data entry but purely to call / filter / search records based on multiple criteras (text box / List box / combo box) in the parent form.
Can Conditional formating be used in Sub Form filtered data ?
Best Regards,
Kamlesh Jain