Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 245181 - Last Review: June 24, 2004 - Revision: 2.0
ACC2000: Expression Builder Is Not Available in Visual Basic Environment
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).
The Microsoft Access Expression Builder is not available in the Visual Basic Environment.
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.
To use the Expression Builder in Access 2000, follow these steps:
- 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.
- In the query design grid, right-click in any Field cell, and then click Build on the shortcut menu.
- Build your expression, and then click OK.
- Select the entire expression, and then click Copy on the Edit menu.
- In your code module, click Paste on the Edit menu to paste the expression into the code.
- Close the query without saving it.
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.
APPLIES TO
- Microsoft Access 2000 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate