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

Thank you, William, that does seem to be the problem.

What I'm muddling about with, here, is that Habitat database I spoke of 
last March.  By now, we have upgraded the equipment and the software - 
nice WinXP boxen and Office 2003 (that reminds me, I need to check 
whether any SPs are in place).  The database has been converted from A97 
to A2K format.  I'm tweaking things so they can go on using this thing 
as we remodel it.  It's rather like living in a house as you gut it and 
reconstruct it, trying to keep the living room presentable while all the 
sawdust and plaster are flying freely through the air, and still 
insisting on a fully dressed table for dinner time.

Of course, this means that some things that used to work fine in A97 do 
not work now, and won't work until they are refashioned to meet the new 
standards.  Part of my job is to keep the pain level as low as possible 
for my good friends at Habitat.  Ultimately, I will give them a truly 
functional application that will serve them well.

Thanks for helping me think about this,
Tina

William Hindman wrote:
> Tina
>
> ...can't recall the particular reason at the moment but you can only merge 
> Word to certain query structures ...either updateable ones or non-mm 
> ...that's most likely your problem ...in some cases I've had to create temp 
> tables and merge from them instead of the query itself.
>
> William
> "Sen. McCain will bring a lifetime of experience to the campaign...  Sen. 
> Obama will bring a speech that he gave." Hillary Clinton
>
> --------------------------------------------------
> From: "Tina Norris Fields" <tinanfields at torchlake.com>
> Sent: Saturday, June 21, 2008 6:02 PM
> To: "'Access Developers discussion and problem solving'" 
> <accessd at databaseadvisors.com>
> Subject: [AccessD] Merge Process Doesn't See All the Queries - Why?
>
>   
>> 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
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com 
>>     
>
>
>