?
Solved

Word Merge Document can't seem to "see" my Access Query

Posted on 2007-10-17
6
Medium Priority
?
209 Views
Last Modified: 2008-01-09
I created a query in MS Access that contains the data i want to use as the data source for a MS Word Mail Merge document.
The Problem:  I open the merge document, select "Open Data Source", navigate to the Access DB, but the query i'm looking for doesn't show up on the list of available queries and tables (although all the other queries in that DB do show up).

What gives?
0
Comment
Question by:med39
  • 4
  • 2
6 Comments
 
LVL 10

Expert Comment

by:NeoTeq
ID: 20096191
The only thing that comes to mind is that the query is not a SELECT query, but an UPDATE/DELETE/INSERT query. Those would not show up.

Apologies if that's not it though.
0
 
LVL 2

Author Comment

by:med39
ID: 20096280
It's definitely a SELECT query.  No apology necessary.
0
 
LVL 2

Author Comment

by:med39
ID: 20101756
Here's a clue:
The query that MS Word doesn't see has calls to a custom function.  When i take out (of the query) all the fields that call a custom function, Word can see the query.  
Word can also see the query if it has a built-in function (i tested it using the InStr function)
Would it be a correct inference to conclude  that Word cannot use any Access query that includes a call to a custom function?
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
LVL 10

Accepted Solution

by:
NeoTeq earned 2000 total points
ID: 20102205
I'm getting the same thing. After a google search here is the reason why:

http://www.microsoft.com/technet/security/Bulletin/MS00-071.mspx
See 'Technical details'

Currently, there is no way to disable that 'feature', save uninstalling the patch. If what you are doing in the custom function is not too complicated its behavior may be replicated with a set of built in functions. If you can post that here, maybe I can help.
0
 
LVL 2

Author Comment

by:med39
ID: 20111605
My work-around is to convert the query to a Make Table query, then use the created table for MS Word's data source.  That adds a few wrinkles, but it works.
0
 
LVL 2

Author Comment

by:med39
ID: 20111612
NeoTeq,

Thanks for showing me why i can't do what i wanted to do.  
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Office 365 is currently available in five editions. Three of them are for business use: Office 365 Business Essentials, Office 365 Business, and Office 365 Business Premium. Two of them are for home/personal use: Office 365 Home and Office 365 Perso…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question