Re: [MS_AccessPros] Open query based on SQL withing VB

 

Oh, then create and save a new query using a QueryDef object.  You can then open the query in the UI (OpenQuery) or reference the query by name in Excel.  A query has to be stored to be open in the UI.  You can also modify the SQL of an existing query.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

P.S. Please keep the thread intact.  If replying on the web, be sure to click the Show Message History button.

On Feb 18, 2015, at 5:45 PM, runuphillracing@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Open to view it. Also to manually copy and paste the data into a spreadsheet (no OutputTo or TransferSpreadsheet for now). 

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___