Search results

I just posted a video on my YouTube channel explaining how an Access files, containing subs, functions, code modules or even classes, can be distributed as if it was a code library. This file can be referenced by any other Access file (using the Tools.References window), so that it can use all...

Thanks! Since I just joined this forum, i can confirm that AUG Italia is up and running. We had our ninth meeting just yesterday. We're taking a summer break, and resume activities in September. If you know any Italian-speaking VBA developer, please spread the word!

OK... what's SWAG? :cautious:

Thanks. I never heard this expression... what does "That's quite a long left" mean?

I still don't see your point. Releasing pinters takes seconds. Trying to avoid/looking for circular references, implicit circular references etc. can take A LOT of time and experience. What's the added value in it? What's SO wrong in setting a pointer to nothing?

Thanks for contributing to the discussion. I perfectly know I don't "destroy" anything, and it's just a pointer release. "Destroy" is just a word I often use in place of "releasing a pointer" because I find it more satisfying, and I'm sorry if you felt offended by that. Are you a member of some...

Well, isn't it a form of garbage collection?

I thought so. But I usually iterate and destroy all the items before destroying the container object. After all, if we really trusted the garbage collector, we wouldn't even consider destroying the container object... :)

John, I have a question you can probably answer. Suppose I have an object, say a collection. Each item in the collection is another object (e.g. a reference to a form or a control, or another collection). In terms of "cleaning up", is it enough to set the collection to nothing, or is it...

Glad to know I'm not the only one preaching this concept... :)

Hi all. My name is Alessandro Grimaldi. I have been a computer programmer since 1985, and VBA developer since 1998, specialized in MS Access. I have a solid international experience, having worked several years for the United Nations in Afghanistan, Ethiopia, North Korea, Austria, Italy, and for...