Craig has attended:
Excel VBA Advanced course
Training Support Pack & OOP
Hi, just a couple of quick questions...
1) It was mentioned that our Training Support Packs were incomplete and we could download a full version - is this ready yet and could a link to it be posted please?
2) Can a Class be set up with optional properties, allowing you to create an object with these optional properties unassigned? If so do these properties then return some sort of null value?
Many thanks
Craig
RE: Training Support Pack & OOP
Slight rewording of my second question...
I would like to create a class and populate a collection of objects as instances of this class from a database as we did on the course.
However some of the fields returned by the query I am using contain NULLS so I was wondering how this would be dealt with by VBA? Can I still assign these fields to a property of the class? When I access them will these properties then contain NULL or the empty string "" or does this cause an error? Or as I was thinking in my first post, can I set a property as optional and it could return EMTPY when I try to access them?
Hope this is a clearer explanation of what I would like to do.
Many thanks
Craig
