Bypassing the Choose Builder dialog box

[Grumbledook]

Picked up this tip while doing a search for another particular problem, thought it might be worth posting.

From the MSDN website:

Go Straight to the Code
Most Microsoft® Access developers who have made the leap from writing macros to using Visual Basic® for Applications code rarely go back to using the Expression Builder or the Macro Builder. Perhaps this is the case with you. And yet, every time you click the build button (…) on a property sheet, the Choose Builder dialog box pops up asking you which builder you want to use.

The Choose Builder dialog box

If, for the most part, you want to control events by writing Visual Basic for Applications code (using the Code Builder) rather than Access macros and would prefer to bypass this dialog box, stepping through the following procedure will accomplish this.

Suppress the Choose Builder dialog box

Use this procedure to set the interface so that the Choose Builder dialog box doesn’t automatically appear every time you click the build button on a property sheet.

In Access, open any existing database.
In the Database window, click a table, form, or report on the appropriate tab, and then click Design.

The database object you selected should now be open in Design view.
On the Tools menu, click Options.
On the Forms/Reports tab, make sure that the Always Use Event Procedures check box is selected.


Dave

 

[chrissie1]

wow you really now how to make my day "What a wonderfull world" - Louis armstrong