load time

[Dan]

I was just looking to improve my db preformace and right
now I have it so that when I open a form that it runs a
filter filter. I was just wondering if it loads the info
from the imported table to memory and then runs the
filter or if it loads only the filter info. I also have a
linked picture on the form and the page seems to load the
first half of the form with its info and then it pauses a
sec before loading the second half. I was wonding if
there was any better way to do this and if I wrote a
query that just had the info that would be displayed in
the filtered information. the backend info is well under
3 mb and the front end is 5.9 mb

 

[Albert D. Kallal]

If the forms loads...and THEN you run some code to filter..likely this is
some part of the puzzle.

If you can, try opening the form using the where clause.

(and, make sure the fields you use for the conditions are indexed).

That should at least address the issue of dragging data down...

So, generally, if you have a file with 100,000 records, the following code
will load the invoice form with JUST one recode...and should be really fast:


dim strINvoice as string

strInvoice = inputbox("What Invoice to view?")

docmd.OpenForm "frmInvoice",,,"InvoiceID = '" & strInvoice & "'"