Reports not Populating?

D

Dennis

Access 2003

Database has 200 records. Have compacted and repaired file multiple times.

The Query "XX" works!
The report based on "XX" appears to lock up or crash.
"Formatting Page ....." the blue dots are full right
The report used to work fine
Must use Ctrl+Break to get out

Any thoughts?

Dennis
 
O

Ofer

I had this few times with forms, I decided that its better to build it again
then try to figure out what is wrong with it, and it take less time.

If you can open the report in design view, just copy and paste all the
fields for the format.

If you decide to try and figure out what is wrong with report, then check if
you have code in it, on the open event, if you do, remove all the code to see
if that is the cause of the problem.
 
J

Jeff Boyce

Dennis

Create a new report based on the query. Does it work?

If so, throw out the old one... <g>
 
D

Dennis

Ofer,

I really appreciate your thoughts.

Being the "Why" person that I still attempting to determine what happened.

That said a new report works.

Can you be a bit more specific about the the smartest way or point-of-copy
to start and then end the copy/paste procedure to transfer the greates abount
of data and attributes?
Meaning, I can get the fields and lables but not the
Headers/Footers etc

Thanks Dennis
 
O

Ofer

The idea is to eliminate parts of the report until you find the cause of the
problem, can be one or more of four parts
1. The record source of the report, which you checked by running the query
seperatly
2. The code under the form
3. One or more of the fields, it could be that one of them call a function
outside the report that cause the problem
4. The report is curropted, in that case it better to build it again.
To save time on building a new report. you can do the following
4.1 Create a new report, empty
4.2 Bound the report to the query
4.3 Open the first report, select all the fields, copy and paste in the new
report
4.4 Run the new query, to see if you get an error, if you do, check the
fields, if you don't move to the next stage
4.5 copy each sub of the code, seperatly and insert into the new report.

If all the above doesnt work, then use the wizard and build a new report
based on the query.
One more thing, check if the ldb still exist when you close the mdb, if it
does delete it and try and run compact and repair again
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck
 
D

Dennis

Excellent Oger!!

Thanks

Ofer said:
The idea is to eliminate parts of the report until you find the cause of the
problem, can be one or more of four parts
1. The record source of the report, which you checked by running the query
seperatly
2. The code under the form
3. One or more of the fields, it could be that one of them call a function
outside the report that cause the problem
4. The report is curropted, in that case it better to build it again.
To save time on building a new report. you can do the following
4.1 Create a new report, empty
4.2 Bound the report to the query
4.3 Open the first report, select all the fields, copy and paste in the new
report
4.4 Run the new query, to see if you get an error, if you do, check the
fields, if you don't move to the next stage
4.5 copy each sub of the code, seperatly and insert into the new report.

If all the above doesnt work, then use the wizard and build a new report
based on the query.
One more thing, check if the ldb still exist when you close the mdb, if it
does delete it and try and run compact and repair again
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck
Click to expand...
 
Top