Report use to work, but doesn't work anymore

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.
 
B

BabyATX13 via AccessMonster.com

NYDIA
Is there any chance the query got renamed somehow?
this could cause the report to stop working.
KB
 
N

Nydia

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
 
D

Dennis

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
 
N

Nydia

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 :(
 
I

Immanuel Sibero

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
 
M

Mark Keith

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