Access 2003 Forms-Reports

[canusehelp]

in running the analyzer - i get Remove the module behind the form or report.

I removed the Compare and Option Explicit statements - and saved the
report. Yet it still reports the same message. Can someone explain
how to do this.

Thank you

 

[tina]

if there's no code in a form or report's module (*not counting* the Compare
and Option Explicit statements), you can remove the module, and the object
will load faster.

open the form or report object in Design view. in the Properties box, click
the Other tab and scroll to the HasModule property, and change its' setting
to No. *note* that if there is code in the module, it will be wiped out and
cannot be recovered after the form is saved.

hth

 

[Albert D.Kallal]

in running the analyzer - i get Remove the module behind the form or
report.

I removed the Compare and Option Explicit statements - and saved the
report. Yet it still reports the same message. Can someone explain
how to do this.

in the forms "other" tab you can set the "has module" to no.

To be honest, that advice is really crappie advice...and, sure, the form
might load faster......perhaps saving you about .01 of a second.

In fact, even if it saves you a .1 (1 tenth of a second), is that really
going to make, or break your application in terms of performance?

I *really* would not worry about the above...

If you have a main title page that opens up..and does not have ANY code
(which is unlikely), then you certainly might notice a performance boost,
since the VBA libraries don't need to load. However, once ANY form loads the
VBA stuff...then any form that has a module will not really speed up
anyway...