Access Tip of the Day

Automatically open the VBE with the Build button (Access 97/2000/2002)

The ability to create an event procedure using the Build button associated with an event listed on an object's property sheet is convenient. However, when you click the Build button, you need to then select which tool you want to use from the Choose Builder dialog box before you can get to work -- you can choose Expression Builder, Macro Builder, or Code Builder.

If you've been coding for a while, you probably want to jump straight to the code window and forget about the Expression or Macro builders. You can streamline the process somewhat by selecting [Event Procedure] from the dropdown list associated with the event property's text box before you click the Build button. However, there's an even more efficient way to get to the module window.

You can set up Access to automatically open the Visual Basic Editor (VBE) when you click the Build button. To do so, Select Tools | Options from the menu bar. Then, click on the Forms/Reports tab, select the Always Use Event Procedures check box, and click OK. From this point on, clicking a Build button associated with an event property text box opens the code window and automatically creates an appropriate event procedure stub.

(Content provided by Element K Journals)

(Note: Your browser is set to refuse cookies. As a result, you may frequently see previously-viewed tips)
PrintPrint CloseClose

Copyright © 2001 - 2017 MJ Technologies, LLC.  All rights reserved.