If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Toolbars, Drop-Down Menus | Rick | New Users | 1 | September 21st, 2005 11:17 AM |
Help again from Ken Snell (Query) | Randy | Running & Setting Up Queries | 22 | August 29th, 2005 08:15 PM |
Access combo box-show name, not ID, in table? | write on | New Users | 30 | April 30th, 2005 09:11 PM |
Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |
Too Few Parameters error Mail Merge Access Parameter Query | Tony_VBACoder | Mailmerge | 3 | September 14th, 2004 12:15 PM |