Hey thanks Daniel. I'm not sure if I am using more resources... it seems less to me?
The situation - I have a main form which has 4 levels of nested forms within it. On about 80% of the forms are the same 4 buttons -- First/Prev/Next/Last Record.
I have one global module that now includes 4...
Thanks heaps Mark, that's excellent.
Why can't I call a subroutine from an event? (just curious)
And what happens to the return value of the function? Do I need to do something with it?
Actually, these translated subs-as-functions won't have return values... does that matter?
Thanks so...
Sensational!!
I have been watching this thread, as I've got exactly the same problem as Rick46 first mentioned. I'm also on Win2k with Office Premium and have had this problem for so long I don't even think about it any more!
So just wanted to say a huge thanks Chris!
Cheers
Nicola
Ahh... thanks Daniel. So I can't set the event directly to the procedure then - I *must* call the procedure within the event... is that correct?
Also, another question - where does Access put the code for macros? It's not in my global or form modules and there doesn't seem to be any macro...
I have a growing Access application that contains a lot of forms & subforms with repetitive code - e.g. buttons to move between records.
What I would like to do is make global subroutines for these common event procedures, and have the various buttons etc just call the global sub instead of the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.