[AccessD] Merge Process Doesn't See All the Queries - Why? - SOLVED

Tina Norris Fields tinanfields at torchlake.com
Sun Jun 22 12:02:29 CDT 2008


My thanks to Rocky and William for their suggestions.  Here is how it 
all came down:  the query was not updateable, and Word's 
merge-find-my-data-source list did not and would not display that 
query's name. 

I decided to copy the query and craft a make-table query from it.  
Instantly, it complained that there could not be more than one 
autonumber field in a make-table query.  Well, of course, I hadn't 
checked all the fields that had been selected for this rather complex 
query.  This query was based on six tables and one query.  So, I went 
through to find where all the autonumber fields were.  There were four 
of them, only one of which was really of any use in the query.  The 
others were there for reasons that are not apparent to me, for they were 
followed by the description values in their respective tables.  The 
included query did not do anything at all, it was just a dataset of all 
the records in one of the six tables.  So, I stripped out the redundant 
select query and the unwanted autonumber fields, and made my make-table 
query.  Then, I pointed the merge form document at the new table, and, 
hallelujah, it works as it should.

There will be quite a bit of editing and remodeling to make this little 
database do what its users really want it to do.  The sooner I can get 
that done, the sooner my friends will be up and running and happy again, 
and the sooner I get paid.  I used to donate my time to them, because I 
really value their mission and all they ever needed was a new query now 
and then for a report they suddenly realized they would like to have, or 
they moved onto a new system and broke the links for their merge 
documents.  But for this, I told them I could not afford to just donate 
the time, and they completely agreed.  Wow!

Well, the letter works.  Now on to crafting a process form, where they 
can select the date from a calendar control, click the button to run the 
query, click the button to launch the Word merge document, print their 
letters and close Word, then click the button to close the form.  They 
will love that.

I'll be back here with the next puzzle.  Thanks again.

Tina


Tina Norris Fields wrote:
> Hi,
>
> This database has a query specifically for generating the records to be 
> captured in a merge document.  The query is 
> qryPrintListForContributionTypeOfMember (I didn't make up this name - I 
> have inherited it).  The Donation letter is supposed to be linked to 
> that query.  When the Donation letter got moved into another folder, of 
> course it could no longer find its supporting query.  Hey, no problem, 
> just point it back at the database, right, and select the appropriate 
> query - but, when I do that, the query does not appear in the list.  Not 
> possible, say I to myself, I must have goofed up and pointed to the 
> wrong copy of this silly database - do it again, and be careful this 
> time.  So, I did it again and again, and always the same result.  
> Naturally, I'm thinking somehow I have lost this query - don't know how, 
> but it must be gone.  No, open the database normally, and there is the 
> query.  Open  a fresh Word document to start the process over and 
> reconstruct the letter, which must have something wrong with it, right, 
> since it can't see the perfectly good query - oh no! - the same result.  
> Looking for the data source, the query does not show up in the list of 
> queries available in this database.  Open the database itself, there is 
> the query, just fine.  What the . . . . ????
>
> I've never seen this before and I don't know what the problem is.  Any 
> ideas?
>
> Thanks,
> Tina
>   



More information about the AccessD mailing list