Making a report open faster

[tsp120]

I have recently created a report and it typically takes 20-30 seconds to open. The report has a lot of code with a lot of loops and runs a number of sql statements. Other than changing my code (which there is no way I am going to do) are there any standard things that can be done to help speed up the report?

Thanks

 

[jrbarnett]

Well, I would see if you can optimise any code. Such as:
* using DLookup instead of the RecordSet object for retrieval of data from the Db.
* Using a QueryDef object when updating many items at once rather than DoCmd.RunSQL INSERT/UPDATE/DELETE, as these can be all incorporated in a Workspace and treated as a single transaction.

John