Form Difficulty

G

Golfinray

I have beat my head against a wall for two weeks on this problem. I have 8
queries that I need to pull onto a form. The problem: 800,000 items in those
8 queries. I have tried building a "super" query with all 8 queries pulled
into one but that is too slow and takes to long to run (like all weekend to
get results.) I then tried with subforms and I got it built that way but I
can't format the form like I want it because each subform takes up a lot of
room and I can't align the data in the way it has to be. I then tried
tab-pages and tab-pages with subforms and I can't get the form to work
properly. It won't coordinate each tab, in other words I'm on New York on one
tab and I flip over to the next tab and it's on Omaha. Is there any solution?
Thanks so much!!!!!
 
M

Maurice

Couldn't you make 'chunks' of recordsets with what you can do some action. I
don't know the build of the recordset but let's say you'd make a batch
consisting of the records 1 - 100000, 100001 - 200000 etc. In my opion it is
impossible to look at 800000 records at one time at all so why not split it.

In your form you could create an tab with unbound subforms where you could
'get' the data when a button is clicked to 'load' the data as requested...

Just my 2 cents...
 
Top