Solved

Expression Builder in Access Does Not Have Paste Option

Posted on 2010-11-09
3
504 Views
Last Modified: 2012-05-10
I have just upgraded Access from 2000 to 2010. When I use the Expression Builder and choose among the Elements, Categories, and Values  there is not the option to paste the data into the upper pane. I can type the expression out, but that defeats the purpose of the tool. Is there a solution here?
0
Comment
Question by:gbm33
3 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 34098039
have you tried double click on categories and expression values
0
 
LVL 84
ID: 34098100
You might Try Ctrl+C and Ctrl+V. As I recall, the Expression Editor in 2010 made some drastic changes, and part of that may have included removal of some of those options.
0
 

Author Comment

by:gbm33
ID: 34098351
capricorn1: Double Clicking on the Expression Value places the entire path in the upper pane. That is the solution. What would be wrong with having kept the Paste button?

LSMConsulting: Copy and Paste only put the Expression Value in the pane.  

0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question