?
Solved

Expression Builder in Access Does Not Have Paste Option

Posted on 2010-11-09
3
Medium Priority
?
554 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 2000 total points
ID: 34098039
have you tried double click on categories and expression values
0
 
LVL 85
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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

592 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