Microsoft KB Archive/245181

= ACC2000: Expression Builder Is Not Available in Visual Basic Environment =

Article ID: 245181

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q245181



Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



SYMPTOMS
The Microsoft Access Expression Builder is not available in the Visual Basic Environment.



CAUSE
The Microsoft Access Expression Builder only works within Microsoft Access. Because Microsoft Access 2000 now uses the shared Visual Basic Environment that is used by the other Microsoft Office 2000 programs, the Microsoft Access Expression Builder is no longer available in the Visual Basic Environment.



RESOLUTION
To use the Expression Builder in Access 2000, follow these steps:
 * 1) In the Database window, click Queries, click New, click Design View, and then click OK. If the Show Table dialog box is visible, close it.
 * 2) In the query design grid, right-click in any Field cell, and then click Build on the shortcut menu.
 * 3) Build your expression, and then click OK.
 * 4) Select the entire expression, and then click Copy on the Edit menu.
 * 5) In your code module, click Paste on the Edit menu to paste the expression into the code.
 * 6) Close the query without saving it.



MORE INFORMATION
Earlier versions of Microsoft Access used a native Visual Basic editor rather than the shared Visual Basic Environment used by other Microsoft Office programs. Because the native Visual Basic editor was built into Microsoft Access directly, it was possible to use the Expression Builder within it.

Microsoft Access 2000 now uses the shared Visual Basic Environment that is used by the other Microsoft Office 2000 programs. Because the Visual Basic Environment is shared technology, the Microsoft Access Expression Builder is no longer available in the Visual Basic Environment.

Additional query words: prb

Keywords: kbprb KB245181

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.