Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Training Support Pack & OOP
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Training Support Pack & OOP
Resolved · Medium Priority · Version 2003
Reply Thu 13 Nov 2008, 15:24Delegate Craig said...
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
For upcoming training course dates see: Pricing & availability
Reply Fri 14 Nov 2008, 10:27Delegate Craig said...
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
|