Is there a Refresh in a report ?

[PFMcCracken]

Someone brought up the point that when a VBA change is made and then re-run
in the MS Access report that the change in the code may not be seen and thus
you believe all your efforts are for naught. (nothing).

Is this true? And if so, how do I overcome this??

Philip

 

['69 Camaro]

Hi, Phillip.

the change in the code may not be seen
Is this true?

Yes. It's true for VBA code as a whole, not just for the VBA code in report
modules. But it's not that common if the code is in the current database.
If the code is in an Access Add-in, then none of your changes to the
Add-in's code in the VB Editor for the _current_ database will be saved in
the Add-in.

how do I overcome this??

Turn off the "Compile On Demand" option in the VB Editor Options dialog
window. If you need to make changes to an Add-in's code, then you'll need
to open the Add-in as the current database in order to edit and save the
code.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)