"Object-Oriented Programming"

[JP Goodrich]

I've had 2 interviews for a position with a company, and now they want to see
samples of Object-Oriented Programming, if I have any. This company has a
rather extensive application developed in Microsoft Access, and they want
somebody to continue using Access. Can anyone give me an example of what
they might be looking for?

 

[Douglas J Steele]

Take a look at
http://msdn.microsoft.com/library/en-us/vbcon98/html/vbconprogrammingwithobjects.asp

While it's aimed at VB6, most of the concepts are transferrable to VBA.

 

[Chris Marlow]

Hi,

Good luck.

The OO in VBA is quite limited (no inheritance, no interfaces, ok you can
implement but you can't build). However you can instantiate your own objects
from class modules that you have built (Insert - Class Module). You can also
define events on these classes & have your calling code (usually a form say)
subscribe to those events.

I'd go to Google to try to find a tutorial ... it is conceptually a little
different from 'standard' procedural code.

Regards,

Chris.

 

[blgilbert]

Access does not support true object-oriented. They are using class
modules. Learn what you can about class modules, especially custom
properties and Class Initialize and Terminate events.

They probably also make use of extensive modularization (code re-use)
through modules and add-ins.