Report Error Message -Print Preview (1 Viewer)

[Kesh]

Access 2007
A few days ago I requested help on this problem and after some time I stated that the problem was resolved. It was resolved but it has come up again

When I do a report view everything is fine but when I try to print preview and print an error message is discplayed.

I have attahed a screen print of the error.

Anyone, please help me. I need to get this going asap

Thank you in advance

Kesh

 

[pbaldy]

What's the code? The format event does not run in Report view, just Preview and Print views.

 

[Kesh]

Thank you pbaldy.

In fact I tried doing print preview and I am still getting the same message. I also tried publishing as pdf and sending as attachment in an e-mail.

The data on the report is sourced from a query using several joined tables. I tried removing all tables and joingin 1 by 1 and still the same. The weird thing is it worked on Friday and I was able to print. I don't know what caused the problem to recur.

I have some computations included in the query and I am guessing it might have to do with the values used - example I might have missed a value which may be a text or something.

Please tell me what are your views

Kesh

 

[pbaldy]

Is there code in the format event? If so, what is it?

 

[Kesh]

I am not sure what you mean by format event - but what I can say is that some of the fields that are selected from the query were expressions. Could it be that there is one field on the report where I have set an expression?

Kesh

 

[pbaldy]

Can you post the db here? The error implies a problem with code in the format event. The behavior you describe is consistent with that, since the format event does not fire in Report view but does fire in Preview.

 

[Kesh]

Thank you Paul
Yes I will try to upload the DB. But I cannot see any way to upload it. I did upload a screen print in a previous post though

I will look into this again

 

[pbaldy]

The screen shot is just of the error. Here's how to upload:

http://www.access-programmers.co.uk/forums/showthread.php?t=140587

 

[Kesh]

Hi Paul,

I have uploaded the db as split zip files, with name "CS Performance Scorecard"

It should be ok

Thank you again for your precious help

 

[pbaldy]

I get errors when I try to extract the file. Can you try it again?

 

[Kesh]

I have uploaded the files again - there are 10 files in all

 

[pbaldy]

Sorry, I still get an error trying to extract the file (Win 7 Pro built-in process). What did you use to zip the file? I wonder if the methods aren't compatible.

 

[Kesh]

Never mind Paul. Now the report is working. It's uncanny. Thank you very much for your help

 

[pbaldy]

Glad you have it working.