Celeste-
In VBA, open the QueryDef of the query and grab the SQL property. You can probably access directly like this:
Dim strSQL As String
strSQL = CurrentDb.QueryDefs("MyQuery").SQL
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
(Paris, France)
On Dec 16, 2015, at 9:24 PM, celestecpa <no_reply@yahoogroups.com> wrote:
Hello -
Is there a way to send a query (not the results, the query itself) in an email to someone? That person will paste the query in their list of queries.
Thank you,
Celeste
__._,_.___
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 (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar