linked table parameter query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cal - 18 Nov 2005 16:16 GMT

Hi All (Doug??....) ;^)

background: I'm using- Word 2002 SP3 and Access 2002 SP3

Historically, I've put together a parameter query in Access to be used as a
data source for various mailmerge documents.
I swear, EVERY version change of either Access OR Word has broken my queries
and I've had to fix them.
Until now, I've been able to fix them.....this time I can't figure it out.

The Access query is of/on a set of linked tables which are (ancient...)
Foxpro .dbf's. I can "see"/open the tables just fine in Access. I can
construct and run the query just fine; in Access. What I can't do is figure
out how to make this query my data source for the mailmerge document(s).
Nothing I've tried in the past works. I've tried ODBC, DDE, and most of the
rest of the alphabet.....

Any help or pointers in the right direction will be much appreciated!!!

Blessings,

Cal Peters
Grand Rapids, MI

Reply to this Message

JohnB - 20 Nov 2005 12:26 GMT

I'm no expert but for what it's worth...

My experience of using parameter queries to supply a Mailmerge is that the
window asking for the paramater opens behind the Word window - you have to
minimise word to be able to input the parameter. Sorry if this is a bit
obvious but you don't actually say what is 'not' happening. Perhaps if you
expand a little. E.g. if you link using DDE, can you 'see' the query in the
list? If not, have you set 'Confirm Conversion at Open' in
Word/Tools//Options/General?

Good luck. JohnB

> Hi All (Doug??....) ;^)
>
[quoted text clipped - 19 lines]
> Cal Peters
> Grand Rapids, MI

Reply to this Message

cal - 21 Nov 2005 18:13 GMT

JohnB,
I totally spaced out the 'Confirm Conversion at Open'. That did it.
Thanks!!!
Cal

> I'm no expert but for what it's worth...
>
[quoted text clipped - 31 lines]
> > Cal Peters
> > Grand Rapids, MI

Reply to this Message