[AccessD] 2007 Word merge

John,
I've little experience with Word docs other than populating data from a VB or C# app.  However, I looked around a little bit and found this, this may get you going...
http://www.dummies.com/how-to/content/how-to-create-a-word-2007-macro.html


-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W Colby
Sent: Friday, March 08, 2013 11:49 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] 2007 Word merge

Thanks Randall,

Hmm.... as the document opens it tells me it is going to "Select * from 'Qry_Export Final$'.  There is a qry_Export Final in my application and when I run that it returns a set of 178 records. The document opens and displays real data, 4 records worth.  The query data is not what is displayed in the word document however.

If I say yes, the document opens and it looks like the document contains whatever was last merged in which is a major security breach since this is a loan document and I am not supposed to see the actual names and stuff (I get jumbled up names and such).  I see (can step through) 4 records, all neatly merged into the three pages of the document.

If I say no... it opens this "select data source" dialog which expects me to find the data source, which I haven't a clue where this data is coming from.

My understanding is that my program is exporting spreadsheets to the same location as the app, which it does, which are supposed to be used for the merge, which they are not.  The data is coming from somewhere else, said place unknown.

Word's suckage rating is approaching 99% on this one.  I just need to find out where the 4 records that the document is actually displaying are coming from.

I am not finding a way, whether I say yes or no to that initial question, to see a property sheet for a field, nor anything else which says "I am getting my data from here...".

John W. Colby

Reality is what refuses to go away
when you do not believe in it

On 3/8/2013 11:20 AM, RANDALL R ANTHONY wrote:
> John,
> You should be able to open the document and right click a field(?) and click on properties.  When the properties form is displayed the Bookmark should identify where your program is getting the data.
>

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-------------Disclaimer---------------

This electronic message and its contents and attachments contain information from Sentara Healthcare and is confidential or otherwise protected from disclosure. The information is intended to be for the addressee only.

If you are not the addressee, any disclosure, copy, distribution or use of the contents of this message is prohibited. If you have received this electronic message in error, please notify us immediately and destroy the original message and all copies.