Report use to work, but doesn't work anymore

  • Thread starter Thread starter NYDIA
  • Start date Start date
N

NYDIA

The purpose of my database is to keep track of meetings
for clients in our program. I created a billing sheet that
runs from a qry, I type in date parameters and clients
that had services between those dates will come up. it
worked fine. NOW, when i try to run the report it looks
like its running but nothing happens, then I get a "Not
responding" If i run the query it works fast.

What can i do to make this report start working again? any
suggestions are greatly appreciated.
 
NYDIA
Is there any chance the query got renamed somehow?
this could cause the report to stop working.
KB
 
no, the name is correct, it looks like its trying to open,
it has "formatting page, ctrl break to stop" at the
bottom, but then after awhile, it has [rptbyclient] (not
responding) at the top
 
Something worth trying
go to the tools / database utilities / repair database
sometime this works and sometimes it doesn't
but it may be worth a try if you haven't changed anything.
otherwise you may want to recreate the quere.
good luck
 
I did try that and it didn't help. When I run the query,
it works fine, its the report that is freezing up. I
didn't want to recreate the report, because it is long, so
any other suggestions? If not back to the drawing board :(
 
Nydia,

Have you tried decompiling the .mdb?
Or, create a blank, brandnew mdb and import all objects from your existing
mdb. See if this fixes the problematic report.


Make sure you have backup.

Immanuel Sibero
 
NYDIA said:
The purpose of my database is to keep track of meetings
for clients in our program. I created a billing sheet that
runs from a qry, I type in date parameters and clients
that had services between those dates will come up. it
worked fine. NOW, when i try to run the report it looks
like its running but nothing happens, then I get a "Not
responding" If i run the query it works fast.

What can i do to make this report start working again? any
suggestions are greatly appreciated.
Click to expand...
..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

keeps asking for parameters 1
Parameter Query In Report Title 3
Query works but report has no data 2
Query works but report fails 2
Access Access Report Works on One Machine but not Another 3
Using DCount in report with parameter qry 1
Parameter Queries in Reports 6
Date parameters won't work on crosstab report 1

Back
Top