Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Sat Jun 21 17:21:37 CDT 2008
No idea but I'd recreate the query with another name and see if you could link it to the new query. Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris Fields Sent: Saturday, June 21, 2008 3:02 PM To: 'Access Developers discussion and problem solving' 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