Search results for query: *

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...