Printing problem in MS access 2000 i.e. office XP MS Access

[kspyathi]

I have a access report with report footer, page footer etc. wherein calculated values are printed. My problem is when i open the report in acviewprview mode and print the report by using the print button or print menu command on the prview window all the values are recalculated and printed again, i.e. what i am viewing on the screen gets doubled when printed with clicking on the print button of the preview window which i do not want how to avoid this? Can anyone help me?

[NeoPa]

That depends on how you have calculated the values.

If you post what you have then we can give it some consideration for you. Make sure you are clear about which values show up incorrectly and which sections of the report they're in.

[kspyathi]

Dear NeoPa I have attached the entire mdb file in zip format, pls see the program click on reports click on preview and try to print through it, it prints the values doubled of what is being shown on screen. Let me know what mistake i have made and what can be the solution for it.

[NeoPa]

The name of the report might help.

Is it "Annexure_3A_rep" by any chance (Just the one that's currently selected in the DB window)?

[kspyathi]

Dear NeoPa,
use the login name user and password user to login to the program click on report formats 1-7 slect budget year 2008-09 , head of account 2235-02-102-0-55 (P) type some xyxz characters in name of ofice field then click on the annexure-2 preview or any preview button, after the preview window opens try printing form there itself it prints double values. kindly let me konw the mistakes i have done. waiting for reply with regards

[NeoPa]

Thank you. This seems to be what I need to start looking at this.

I will do so and report any findings.

[NeoPa]

There seems to be some special font you are using that isn't available on my PC (at least not installed & I don't plan to install any more). I don't think this should cause a problem though, except that I thought the value you wanted me to look at would be obvious, yet either the problem doesn't occur for me, or I am looking in the wrong place. Hard to be sure when most of what you see I don't (loads and loads of very strange characters).

I do see a title clearly enough, below where it says Head of Account, 1, 2, 2a, 2b, 2c, 3a, etc, etc.
Where should I be looking for this value?

[NeoPa]

Furthermore, I see when I look more closely at the design that it is expecting some much wider paper than my printer supports. I may be missing a lot of the detail of course, but that I can get around if you tell me which control on the report I should be focusing on.

[kspyathi]

Dear neopa,
the report has been set to fanfold 15 x 12 on dot matrix printer you can set it to legal page in landscape mode with left and righ margin set to 0.3 , the titles are not important , the total column i.e. the ninth column vertically and horizontally total row in annexure report 2 , if i click on the print button on the preview window the code is executed once again and the values get doubled for printing on lcicking the print button. let me know what mistake i have made

[NeoPa]

For the benefit of anyone else trying to follow the thread and not wanting to dig this up for themselves, what Kspyathi meant to say was :
The control is a TextBox called Total_amt, and with a Control Source of Total_amt.

[NeoPa]

Scratch that! What a waste of time. Why can you not take a minute of your time to help me help you, rather than leave me wasting tens of minutes just trying to work out what you want. I asked you where the field is and what it's called and you spent two seconds giving me something so useless I had to spend 1/4 of an hour working out what you meant. You saved yourself less than 1 minute - but wasted 15 of mine. Nice.

I'm still lost. The control I thought you were talking about is not going wrong. I look in the Page & Report footers (From your first post) and see only label controls.

If the next response I get is anything like any previous ones and gives me just a piece of the jigsaw puzzle again I will not respond further in this thread.

[NeoPa]

I couldn't get it to do as you have said it does. It printed a value of 104,992 on the first line first time & every time.

However, I suspect that is because you have been giving me wrong information (quite irritating really) about what the problem is and where it can be found. I did notice what I think is your problem, but I couldn't find proof or test it properly because your information so far has just been a waste of my time frankly.

Anyway, you have code associated with the report which is keeping totals. Your problem is that you never reset the totals, but just keep adding the same set of values in over and over again. BTW redoing it in any form would give the same results. Going to Design mode then back into Preview mode would have the same effect.

[kspyathi]

Deae Neopa,
i am sorry my reply was out of bounds for you, and it wasted your time, i will be more specific while explaining, the problem is with the totals in the group footer 1, group footer 0 and report footer. As you have pointed out i am not resetting the values here because if i reset the totals they do not the reflect the actual value, if i do not reset the values the preview window shows the correct values , but if you use the print button on the preview window itself for printing the values in the footers change while being printed on the paper. for that i have circumvented by putting the print button along with the preveiw button in my program so the preview button is for pre viewing the data and the print button is for printing. but i do not want this to happen , as is the case with any program where we can print from the preview window itself what we are seeing without any changes, i would like to have the same feature in my program but unfortunately that is not possible because of my coding error or logic problem whatever. If you have any solution for this kindly let me know. I do hope this explanation is good enough for you otherwise what more explanation i need to give please let me know. may be this explanation might suffice you.

[NeoPa]

You know, when I think about it, forget about the explanations. Just do the best you can and I'll try and work with it. I've had to learn how to express things more clearly, but I forget that not everyone has been as lucky as I in that respect. Just explain it the best way you can.

As for the problem :
I'm still struggling to understand as the copy of the database I have has no TextBoxes in those three sections, except one for the village name. Everything else is a Label control (or lines, or other irrelevant stuff). I see nothing in this copy that could have totals in it.

As for your question, I would look at resetting the values in a Report_Load() event procedure. It may also work from your Report_Open() event procedure, but you'd need to try this out to make sure.

[kspyathi]

Dear NeoPa,
i am using label controls to print the values i calculate in the code in the detail print event in the report code i execute, just to make sure they are not changed. Hence the label controls. the totals are calculated in the report code itself, because i could not do it in the sql statement i.e. annexure2 query which i use to fetch the records from the tables.
thats why i want to know how best it could be done. if you can find any solution pls let me know so tha my problem is solved

[NeoPa]

You are using label controls to display your values. That is quite a clever concept, but not telling us about them while explaining the situation is not quite so clever. I had to ask myself "Would anyone be clever enough to use this concept, and also be unclever enough not to tell us about it?" I decided no. Clearly I was mistaken.

As for a solution, you may find one if you read through my previous post (#14). Look in the third paragraph.

[kspyathi]

dear NeoPa,
i am not able to properly format the query and also did not know what details to give, i.e. what is required or what is not required. Hence it has offended you. anyhow thank you for your time i have taken and for the solution, i am not able to try out your solution, once i have tried i will try to update on this forum. Thanks a lot.
with warm regards

[NeoPa]

@kspyathi
That would be appreciated :)

I do hope it does work. To be honest I expected something similar to this (as the problem) from the outset, but I needed to check that I was thinking along the right lines. This proved difficult as communication was not smooth, but if it is the problem then that should certainly give you a workable solution. if not, then let us know and we can look again.