Report Printing

[Zorro1265]

I have made a command button to print a report from one of my forms. It is a rather complex form with lots of data which my users require. On our network it takes over a minute for this to print (well at least for the print box to leave the screen). I think when the button is pushed it goes to the tables to collect all the info my query calls for, is this correct? Why or how can I make it use the info thats already loaded in the form and skip the pulling all the data from the backend tables on the network? Wouldn't this be faster? Zorro

 

[JoeMiller]

Why are you printing a form instead of composing a true report? Your taking a performance hit because you're printing a graphical representation of your data (the form).

Joe Miller
joe.miller@flotech.net

 

[Zorro1265]

I'm sorry I wans't clear let me try again. I am printing an Access report. The data for that report is in the currently loaded form. My problem is when I try to load that data from our network to the local front end and print it can take as much as 2 minutes. Since the front end containing the command button to print this report already has all the data the report needs can I pull the data from these forms to feed into the report? Zorro

 

[JoeMiller]

Well, if your form is simple, you could make the report refer to the fields on your form that have been called up. You would do that by taking each control name and using it in the control source of the corresponding text box on the report.

=[Forms]![MyFormName]![ControlNameToShow]

This is not a good solution, but it works for what you want. Why is your network so slow to respond? 2 Minutes is a very long time for a DB server to return 1 record. Does it take 2 minutes for the form to load? If not then the query you created to make the report differs from the query feeding the form. There is some investigation that needs to happen on your end because something doesn't sound right from where I'm sitting.

HTH

Joe Miller
joe.miller@flotech.net

 

[Zorro1265]

I have been trying to get our IS folks to come look at things but they are too busy. The report takes about 20 seconds to print locally. Zorro