Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
linked table parameter query
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
linked table parameter query
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 "cal" wrote: 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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
linked table parameter query
JohnB,
I totally spaced out the 'Confirm Conversion at Open'. That did it. Thanks!!! Cal "JohnB" wrote: 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 "cal" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mailmerge from Access parameter query only merges odd records | Mailmerge | |||
Linked table header | Tables | |||
Getting a Parameter to work in Microsoft Query | Mailmerge | |||
Table headers/footers and layout | Page Layout | |||
Table AutoFormats vs. Table Styles confusion | Tables |