Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Preview Loses Mouse Pointer on 2 Sub-report Report

Status
Not open for further replies.
May 7, 1999
130
US
I have a lengthy, but seemingly not complicated report that consists of name, address, phone number(s), e-mail address(es), the latter two of which are handled each with a sub-report. The report does work, but performance is very poor. In fact, it's so poor that I experienced a real oddity: the report ran for hours and then returned me to the main Access database screen (all items just as before I ran the report). No report, no nothing.

Since I had each phone number and address subreport being controlled by a query (I wanted not to see "inactive" entries), I created two temporary tables with the appropriately pre-selected records (i.e., only active records), then pointed the sub-reports to their respective temporary tables and then ran the main report. All was well, if not, at least it was better, except that the report previewed satisfactorily with a missing mouse pointer whenever I moved the mouse over the Access 2000 database window. The mouse was active in that I was able to estimate where the mouse was positioned and click on an item successfully (talk about dancing in the dark!). When I moved the mouse over the toolbar, I could see the appropriate items highlighted.

I'd like to solve the performance problem for sure. That is, I want not to have to create temporary tables and I'd be delighted to improve the speed of creating the report at the same time. Performance does seem to be a function of how many items are in the phone number table compared to the number in the e-mail address table (a ratio of some 25 to 1). And, of course, I'd like to get back my cursor which doesn't return until I exit from Access and restart Access.

I've searched the web, checked the knowledgebase, run the report on a smaller RAM-configured machine (48MB instead of 128MB), but no joy.

Any good ideas? In fact, any ideas?

Thanks,
John Harkins
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top