Datasheet

Chapter 1
48
Summary
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.
Exercise
1. The Autokeys macro is used to associate macro actions with keyboard shortcuts. Try
using the Autokeys macro to display the property window whenever you hit F4. When
does this shortcut not work? What happens if you try to associate this action with
Alt+F4 and why?