Re: Function vs Sub /Public vs Private
- From: "David W. Fenton" <dXXXfenton@xxxxxxxxxxxxxxxx>
- Date: Fri, 22 Jul 2005 20:55:03 GMT
"lauren quantrell" <laurenquantrell@xxxxxxxxxxx> wrote in
news:1122055391.763589.165110@xxxxxxxxxxxxxxxxxxxxxxxxxxxx:
> Maybe I formed that opinion back in Access 97 and have it stuck in
> my mind. I can remember loading forms with a couple of subforms
> and when I removed all the OnLoad, OnOpen, populating and control
> formatting code into a module named after the form (to keep it all
> in one place) I could count the difference with the second hand on
> my watch. Maybe it got changed but I kept the notion it makes a
> difference and have stuck with that contruction since those dark
> days.
Sounds like your forms weren't properly compiled and were
recompiling each time they were loaded.
That's a completely different set of problems that can be solved
without moving all the code out of the forms.
And it may be due to hidden corruption -- decompile (judiciously
used) is your friend.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
.
- Follow-Ups:
- Re: Function vs Sub /Public vs Private
- From: downwitch
- Re: Function vs Sub /Public vs Private
- References:
- Re: Function vs Sub /Public vs Private
- From: james.igoe@xxxxxxxxx
- Re: Function vs Sub /Public vs Private
- From: lauren quantrell
- Re: Function vs Sub /Public vs Private
- From: rkc
- Re: Function vs Sub /Public vs Private
- From: lauren quantrell
- Re: Function vs Sub /Public vs Private
- From: Larry Linson
- Re: Function vs Sub /Public vs Private
- From: lauren quantrell
- Re: Function vs Sub /Public vs Private
- Prev by Date: Re: Parsing out SQL statement
- Next by Date: Re: Parsing out SQL statement
- Previous by thread: Re: Function vs Sub /Public vs Private
- Next by thread: Re: Function vs Sub /Public vs Private
- Index(es):
Relevant Pages
|
