RE: [MS_AccessPros] Copying query runs it first

 

What happens if you select  the query, then go to the file tab and select Save Object As. If that works you could at the Save Object As to the QAT.

 

Glenn

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, September 29, 2014 5:22 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Copying query runs it first

 

 

Thanks, Glenn. The query is not open, and I'm trying to copy in the Navigation area which shows all Access objects. I either select the desired query and Ctrl-C or else right-click the query and select Copy. Since neither of these approaches no longer works, I'm copying the SQL and pasting into a new query. 

 

On Mon, Sep 29, 2014 at 3:57 PM, 'Glenn Lloyd' argeedblu@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

 

James,

 

Are you copying on the navigation bar? Or do you have the query open when you try to copy it?

 

Glenn

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, September 29, 2014 3:21 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Copying query runs it first

 

 

I'm having a new problem with Access 2010 on Windows 7 Professional, and I don't know what I might have done to cause it.

 

Whenever I try to copy and paste a query in order to duplicate it, Access pauses for a while and is non-responsive. What it  is doing is actually running the query and copying the results to the clipboard. When Access becomes responsive again, the query results, if they are small enough, are on the clipboard instead of the query object that I'm trying to duplicate. 

 

I can copy/paste tables just fine; it's just queries that are troublesome. It makes no difference whether I use Ctrl-C or Copy from the context menu. The results are the same.

 

I am running Access in a virtual machine (the newParallels Desktop 10) on my Mac. I'm pretty sure that the issue lies there, but I have use previous implementations of Parallels for years with no problem. But before I contact Parallels support, I'd like to confirm that I'm not just doing something stupid in Access!

 

Thanks for any ideas.

 

James

 

 

__._,_.___

---

Posted by: "Glenn Lloyd" <argeedblu@gmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___