Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Donate Today!

Do you enjoy these
technical forums?
Donate Today! Click Here

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Hillary (Programmer) (OP)
19 Aug 04 16:13
I have a report with a subreport that was running fine as I was building it.  I made a few changes to the report...drew some lines and a box and added a couple text boxes, all on the main report and saved it.

The next time I tried to run it the ODBC failed before it finished...it was running about 10 minutes before it failed (timed out?)

The report used to take about 30 seconds to open.  Now for the 1st 30 seconds the status bar shows, "Running Query" and shows a staus bar (it does this twice) then the status bar goes to "Formatiing Page, oress cntl + break to stop"  If I delete the subreport the main report runs fine.  There is no formatting (that I'm aware of) on the subreport.

Is there anyway to resolve this?  Are there just too many records?  There are approx 59,000 records on the main form and the system is filtering through 20,000 sub records usually only returning 1 or 2 sub records for each main record.

The database resides on SQL Server but I don't know what version.

Access 2003 SP1

Thanks for your help!

Hillary

Hillary (Programmer) (OP)
19 Aug 04 16:13
I forgot to mention that I am using an ODBC connection.

Hillary

Helpful Member!(3)  dhookom (Programmer)
19 Aug 04 17:10
Do you add a text box with Page of Pages?

Duane
MS Access MVP
Find out how to get great answers FAQ219-2884.

Hillary (Programmer) (OP)
20 Aug 04 8:41
Yes I did.  Is that the culprit???

Hillary

Hillary (Programmer) (OP)
20 Aug 04 8:46
That was it!  Here's a star.  I'd give you more if I could

Why does it do that?  I know I've used it before.  Is it the combination of the subreport and Page of Page?

Thank you VERY much!

Hillary

dhookom (Programmer)
20 Aug 04 9:19
Your complete report must format prior to printing the first page in order to get the "Pages". This takes quite a while with lots of records and one or more subreports.

Duane
MS Access MVP
Find out how to get great answers FAQ219-2884.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close