In this chapter, we've worked our way through the process of creating part of an Access application with one aim in mind to deliberately hit a brick wall. That brick wall is the implementation of the intelligent navigation buttons . We just can't implement them properly using macros. Instead, we need VBA
So, in brief, we have covered:
How to go about designing an application
An introduction to the application that forms the basis of this book IceCream.mdb
Creating the main form for the application and adding custom navigation buttons
Why macros aren't sufficient for our needs
When to use VBA and when to use macros
In the next chapter, we'll look at how you can polish up the Company Details form using VBA. If this chapter has been a success, you'll hunger for the power to solve the problems we've come up against so let's get on with it.