Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / January 2006

Tip: Looking for answers? Try searching our database.

Unpredictable user promts

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Margaret Bartley - 19 Jan 2006 22:56 GMT
I have an Access application that is opening a Word document for mailmerge.
The users are unsophisticated.  They push a button, see the result on their
screen, and then print it out.

Occassionally - and I've not been able to figure out what makes this
happen - the user will see a dialog box with the Alert symbol (Yellow,
exclamation point) that says:

Microsoft Office Word

 Opening the document will run the following SQL command:
 SELECT * FROM [qryMailList_PR_Fam]
 Data from your database will be place in the document.  Do you want to
continue?
            Yes          No [-the default]

If the user actually reads the message (unlikely) they would probably click
Yes, which is wrong.  If they click Yes, the wrong data comes up.  If they
click "No" then things proceed correctly.

What's going on?  How can I stop this behavior?  Like I said, most of the
time, this does not happen.

TIA
Margaret
Peter Jamieson - 19 Jan 2006 23:37 GMT
The following article describes the main reason why you get the prompts:

"Opening This Will Run the Following SQL Command" Message When You Open a
Word Document"
at
http://support.microsoft.com?kbid=825765

Users with Word 2003 and later SPs of Word 2002 will probably see this
behaviour.

However, that doesn't explain why Word is trying to open the wrong query or
is returning the wrong data as you describe. Is your Access application
opening a Word document that already has a data source attached? or are you
using OpenDataSource to attach to the datasource? If it's "both" (or maybe
you are actually opening a Word template?) then that may (partially) explain
why the users are seeing the wrong data - I'd probably try starting with a
document and/or template that is not connected to a datasource.

Peter Jamieson

>I have an Access application that is opening a Word document for mailmerge.
> The users are unsophisticated.  They push a button, see the result on
[quoted text clipped - 23 lines]
> TIA
> Margaret
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.