Database development and training for Birmingham and the midlands
Specialists in Microsoft Access and Visual Foxpro database training and development
I am happy to hear from existing clients but I am taking no new calls.
VBA Code for Events
When you right-click on a form object and select 'Build Event' Access usually gives you a choice of three options:
- the Expression Builder
- the Macro Builder
- the Code Builder
Most developers will always want to use the 'Code Builder' - the VBA editor - so that that can edit Visual Basic code and there is a simple way to bypass the options and get this automatically every time.
- Open a database.
- Select from the menu
- Pick the tab
- Click the tick box labelled
- Use the button to close the Options dialog.
The next time that you try to create code for an event Access will bypass the choices of Expression Builder and Macro Builder and will take you straight to the VBA code editor.
This works in all versions of Microsoft Access from 97 to 2002. Other startup options are described here.
The startup options were moved to a different place with the new interface introduced in Access 2007. If you are using Access 2007 or 2010 you start by clicking the big 'Office' button in the top-left of the screen as the first move. This will bring up a screen of 'Access Options' with a list of components down the left-hand side of the window.
Follow these steps when you have opened the 'Options' window:
- Select Object Designers from the list.
- Scroll down to the Forms/Reports section.
- Click on the box.
- Click on to close the window.