Home |
Search |
Today's Posts |
#1
|
|||
|
|||
missing query bug?
tired to connect a document to an access database and the window only a
shows the tables and one query (the 2 other database queries are not shown) so i can't connect the doc to the query it needs - is this a bug? |
#2
|
|||
|
|||
missing query bug?
Have investigated the bug - Microsoft Word won't merge with some Access
queries ????????????? Assumed it was a software suite - You should be alright if you dont use any criteria - stick to the simple criteria in Word only Only been using the tool about 10 seconds and it is already falling apart at the seems - obviously not for professional use "JethroUK" wrote in message ... tired to connect a document to an access database and the window only a shows the tables and one query (the 2 other database queries are not shown) so i can't connect the doc to the query it needs - is this a bug? |
#3
|
|||
|
|||
missing query bug?
What sort of criteria are you talking about, I have used select queries
with criteria that controls which records from the table are returned by the query as the datasource for mailmerges hundreds of the times. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "JethroUK" wrote in message ... Have investigated the bug - Microsoft Word won't merge with some Access queries ????????????? Assumed it was a software suite - You should be alright if you dont use any criteria - stick to the simple criteria in Word only Only been using the tool about 10 seconds and it is already falling apart at the seems - obviously not for professional use "JethroUK" wrote in message ... tired to connect a document to an access database and the window only a shows the tables and one query (the 2 other database queries are not shown) so i can't connect the doc to the query it needs - is this a bug? |
#4
|
|||
|
|||
missing query bug?
The query criteria is from a form e.g.
[Forms]![Form1]![Control] query on it's own works fine - just M.S. Word mailmerge won't see it as a datasource (doesn't even appear in the database tables/queries window as a datasource) unless i remove the criteria - i assume the sql statement is too complex for it i tried removing the criteria - attaching it as a datasource - replacing the criteria - but mailmerge doc just loses it as a datasource & of course you can't re-attach it i did a google and discovered that others have already noticed that word cant/wont see some Access queries is it possible to pass just the 'where' part of the sql statement direct to the mailmerge doc (hence bypassing the need for a form.control to store it)? "Doug Robbins - Word MVP" wrote in message ... What sort of criteria are you talking about, I have used select queries with criteria that controls which records from the table are returned by the query as the datasource for mailmerges hundreds of the times. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "JethroUK" wrote in message ... Have investigated the bug - Microsoft Word won't merge with some Access queries ????????????? Assumed it was a software suite - You should be alright if you dont use any criteria - stick to the simple criteria in Word only Only been using the tool about 10 seconds and it is already falling apart at the seems - obviously not for professional use "JethroUK" wrote in message ... tired to connect a document to an access database and the window only a shows the tables and one query (the 2 other database queries are not shown) so i can't connect the doc to the query it needs - is this a bug? |
#5
|
|||
|
|||
missing query bug?
I would guess that you are running up against the same "issue" that occurs
in Access when you open such a query when the Form is not open. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "JethroUK©" wrote in message ... The query criteria is from a form e.g. [Forms]![Form1]![Control] query on it's own works fine - just M.S. Word mailmerge won't see it as a datasource (doesn't even appear in the database tables/queries window as a datasource) unless i remove the criteria - i assume the sql statement is too complex for it i tried removing the criteria - attaching it as a datasource - replacing the criteria - but mailmerge doc just loses it as a datasource & of course you can't re-attach it i did a google and discovered that others have already noticed that word cant/wont see some Access queries is it possible to pass just the 'where' part of the sql statement direct to the mailmerge doc (hence bypassing the need for a form.control to store it)? "Doug Robbins - Word MVP" wrote in message ... What sort of criteria are you talking about, I have used select queries with criteria that controls which records from the table are returned by the query as the datasource for mailmerges hundreds of the times. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "JethroUK" wrote in message ... Have investigated the bug - Microsoft Word won't merge with some Access queries ????????????? Assumed it was a software suite - You should be alright if you dont use any criteria - stick to the simple criteria in Word only Only been using the tool about 10 seconds and it is already falling apart at the seems - obviously not for professional use "JethroUK" wrote in message ... tired to connect a document to an access database and the window only a shows the tables and one query (the 2 other database queries are not shown) so i can't connect the doc to the query it needs - is this a bug? |
#6
|
|||
|
|||
missing query bug?
i've already tried it both with the form open and closed - either way the
query does not appear as a possible mailmerge datasource the database isn't populated yet (handful records) & i seemed to remember an option not to show empty records/recordset - that might be the problem - would you know of such an option? "Doug Robbins - Word MVP" wrote in message ... I would guess that you are running up against the same "issue" that occurs in Access when you open such a query when the Form is not open. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "JethroUK©" wrote in message ... The query criteria is from a form e.g. [Forms]![Form1]![Control] query on it's own works fine - just M.S. Word mailmerge won't see it as a datasource (doesn't even appear in the database tables/queries window as a datasource) unless i remove the criteria - i assume the sql statement is too complex for it i tried removing the criteria - attaching it as a datasource - replacing the criteria - but mailmerge doc just loses it as a datasource & of course you can't re-attach it i did a google and discovered that others have already noticed that word cant/wont see some Access queries is it possible to pass just the 'where' part of the sql statement direct to the mailmerge doc (hence bypassing the need for a form.control to store it)? "Doug Robbins - Word MVP" wrote in message ... What sort of criteria are you talking about, I have used select queries with criteria that controls which records from the table are returned by the query as the datasource for mailmerges hundreds of the times. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "JethroUK" wrote in message ... Have investigated the bug - Microsoft Word won't merge with some Access queries ????????????? Assumed it was a software suite - You should be alright if you dont use any criteria - stick to the simple criteria in Word only Only been using the tool about 10 seconds and it is already falling apart at the seems - obviously not for professional use "JethroUK" wrote in message ... tired to connect a document to an access database and the window only a shows the tables and one query (the 2 other database queries are not shown) so i can't connect the doc to the query it needs - is this a bug? |
#7
|
|||
|
|||
missing query bug?
From the Tools menu, select Options and then on the General tab, check the
box for "Confirm conversions at open" and then try the different connection methods that will be offered when you attach the data source to the main document. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "JethroUK" wrote in message ... i've already tried it both with the form open and closed - either way the query does not appear as a possible mailmerge datasource the database isn't populated yet (handful records) & i seemed to remember an option not to show empty records/recordset - that might be the problem - would you know of such an option? "Doug Robbins - Word MVP" wrote in message ... I would guess that you are running up against the same "issue" that occurs in Access when you open such a query when the Form is not open. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "JethroUK©" wrote in message ... The query criteria is from a form e.g. [Forms]![Form1]![Control] query on it's own works fine - just M.S. Word mailmerge won't see it as a datasource (doesn't even appear in the database tables/queries window as a datasource) unless i remove the criteria - i assume the sql statement is too complex for it i tried removing the criteria - attaching it as a datasource - replacing the criteria - but mailmerge doc just loses it as a datasource & of course you can't re-attach it i did a google and discovered that others have already noticed that word cant/wont see some Access queries is it possible to pass just the 'where' part of the sql statement direct to the mailmerge doc (hence bypassing the need for a form.control to store it)? "Doug Robbins - Word MVP" wrote in message ... What sort of criteria are you talking about, I have used select queries with criteria that controls which records from the table are returned by the query as the datasource for mailmerges hundreds of the times. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "JethroUK" wrote in message ... Have investigated the bug - Microsoft Word won't merge with some Access queries ????????????? Assumed it was a software suite - You should be alright if you dont use any criteria - stick to the simple criteria in Word only Only been using the tool about 10 seconds and it is already falling apart at the seems - obviously not for professional use "JethroUK" wrote in message ... tired to connect a document to an access database and the window only a shows the tables and one query (the 2 other database queries are not shown) so i can't connect the doc to the query it needs - is this a bug? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mailmerge Query - Works in Access; fails in Word | Mailmerge | |||
New problem - merge Word 2002 and Access 2002 par query | Mailmerge | |||
Getting a Parameter to work in Microsoft Query | Mailmerge | |||
Mail Merge Access to Word using a Query | Mailmerge | |||
Can't Open Data Source (Query) where criteria is defined by functi | Mailmerge |