• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 38
  • Last Modified:

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_qty]),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]-[BEFiled] 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
0
Kamlesh Jain
Asked:
Kamlesh Jain
  • 3
3 Solutions
 
Gustav BrockCIOCommented:
FC does slow down forms. Easy to check, just remove them an watch.

However, the major slowdown is probably caused by the bunch of subqueries. Again, remove these for a test, and watch.

What to do isn't easy for us to know as we don't know your application neither its purpose.
0
 
John TsioumprisSoftware & Systems EngineerCommented:
If you want to ensure that no Filter is when is loading then
Me.Filter = vbnullstring
Me.FilterOn = False

Open in new window

0
 
Kamlesh JainManagerAuthor Commented:
i am trying to change the form from Split Form to Sub Form.
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
0
 
Gustav BrockCIOCommented:
Just add the subform control and fill with data.

At the OnCurrent event of the subform, set the filter for the main form.

Conditional formating can be use for all forms, also in DatasheetView.
0
 
Gustav BrockCIOCommented:
Suggestions to solve the issue provided.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now