unneeded code

[Dinger_80]

I am working on enhancing the database I designed. I am trying to improve speed on the code I do have by switching multiple dlookups for recordsets and building better queries and reducing the number of them that overlap. So I was wondering about exporting reports to pdf. I do this a bit with my system. The reports are opened the pdf is created and output to the location of my choice just fine and then the report closes. In the example I will provide everything works, I am just curious if all of it is needed. The database is accessed on the server and can be slow, that is why I am trying to trim down and remove anything that isn't needed. If there isn't anything I can do to speed this along, that is an acceptable answer also.

DoCmd.OpenReport "TestRequestReport", acViewPreview, , "[TRNumber]= Forms!TestRequestForm!TRNumber"
DoCmd.OutputTo acOutputReport, "TestRequestReport", acFormatPDF, ToPath & "\" & MyFileName, False
DoCmd.Close acReport, "TestRequestReport"

 

[pbaldy]

With that method it's all needed. The first line filters the report for the second, the third closes it. An alternative to the first and third lines is this, which would let the report filter itself:

http://www.granite.ab.ca/access/email/reporttomultiplerecipients.htm

 

[CJ_London]

not much you can do although you can just use the outputto command by putting your filter assignment in the report open event - ah - been beaten to it.

here's my link anyway

http://bytes.com/topic/access/answers/720974-use-outputto-report-where-condition

 

[Dinger_80]

Thank you for the help. I thought there wasn't much I could do but, wanted to ask anyways. One step at a time and eventually I will get things reduced and hopefully increase the speed at which things occur. Thanks again for the help.

 

[pbaldy]

No problem.

 

[CJ_London]

The database is accessed on the server and can be slow

that is almost certainly your main issue. Depends if you have the budget, but improving network performance will be the most effective. Have you considered using terminal server - almost (99%) the same speed as having the backend on your own machine.