Summary

If you look back over this chapter, you'll see that we have covered a quite a few topics. We have looked at:

• Using functions to determine whether a variable holds an array

• Multi-dimensional arrays and advanced single-dimension arrays

• Transferring recordsets into arrays using the GetRows() method.

• Passing arguments by reference and by value, and the advantages of each method

• Enhancing the functionality of Access through use of DLLs

• User-defined and application-defined DAO properties

We are now getting to the stage where our code is getting a little complex. In one or two of the procedures in this chapter, we came into situations where the things we were trying to do might have caused errors to occur, so we had to put in some code to handle those situations. In fact, you will find out that even seemingly innocuous lines of code can sometimes cause errors to occur.

Now is probably the time to stop for a moment and spend some time looking at how we can make our VBA code more robust. That is why the next chapter will look at how we can ensure our code and applications work in the way they were intended to, by using sound debugging and error-handling techniques.