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...
..
 
Back
Top