Gary Kjos
garykjos at hotmail.com
Wed Jul 28 09:20:35 CDT 2004
I would say ignore it. This person meadlaa at energyexhausts.co.uk is having e-mail problems is all that means. Agree other Moderators? Gary Kjos garykjos at hotmail.com >From: "Mitsules, Mark S. (Newport News)" <Mark.Mitsules at ngc.com> >Reply-To: Discussion of Hardware and Software >issues<dba-tech at databaseadvisors.com> >To: dba-tech at databaseadvisors.com >Subject: [dba-Tech] Attn: List Moderators >Date: Wed, 28 Jul 2004 09:37:56 -0400 > >When posting to AccessD, I've received about 6 notifications from the >following address (postmaster at energyexhausts.co.uk) with the subject >"Delivery Status Notification (Delay)". I've included the content below. > >Since it is a postmaster address and not a personal address, I have >refrained from inquiring as to a possible problem on their end. Any >suggestions as to whether or not I should pursue this? > > >Mark > > >*************************** > >Received: from xcgva081 (xcgva081.nns.com [172.30.10.115]) by >npeimc02.nns.com with SMTP (Microsoft Exchange Internet Mail Service >Version >5.5.2657.72) > id P41MKBWG; Tue, 27 Jul 2004 20:47:43 -0400 >Received: from xcgtx802.northgrum.com ([132.228.189.166]) by xcgva081 with >InterScan Messaging Security Suite; Tue, 27 Jul 2004 20:47:43 -0400 >Received: from xcgtx812.ngxcgtxr1.com ([208.20.220.60]) by >xcgtx802.northgrum.com with Microsoft SMTPSVC(6.0.3790.0); > Tue, 27 Jul 2004 19:47:56 -0500 >Received: from northgrum.com ([208.20.220.54]) by xcgtx812 with InterScan >Messaging Security Suite; Tue, 27 Jul 2004 17:47:37 -0700 >Received: from ([217.35.101.5]) > by xcgtx813.northgrum.com with ESMTP ; > Tue, 27 Jul 2004 17:42:19 -0700 >From: postmaster at energyexhausts.co.uk >To: Mark.Mitsules at ngc.com >Date: Wed, 28 Jul 2004 01:44:18 +0100 >MIME-Version: 1.0 >Content-Type: multipart/report; report-type=delivery-status; > boundary="9B095B5ADSN=_01C45B6D78732E16000007B1energys1.Energy." >X-DSNContext: 7ce717b1 - 1407 - 00000004 - C00402D1 >Message-ID: <ukyCKDkb900000102 at energys1.Energy.local> >Subject: Delivery Status Notification (Delay) >Return-Path: <> >X-OriginalArrivalTime: 28 Jul 2004 00:47:56.0844 (UTC) >FILETIME=[86034EC0:01C4743C] > >This is a MIME-formatted message. >Portions of this message may be unreadable without a MIME-capable mail >program. > >--9B095B5ADSN=_01C45B6D78732E16000007B1energys1.Energy. >Content-Type: text/plain; charset= > >This is an automatically generated Delivery Status Notification. > >THIS IS A WARNING MESSAGE ONLY. > >YOU DO NOT NEED TO RESEND YOUR MESSAGE. > >Delivery to the following recipients has been delayed. > > meadlaa at energyexhausts.co.uk > > > > >--9B095B5ADSN=_01C45B6D78732E16000007B1energys1.Energy. >Content-Type: message/delivery-status > >Reporting-MTA: dns;energys1.Energy.local >Received-From-MTA: dns;energys1.Energy.local >Arrival-Date: Tue, 27 Jul 2004 13:30:25 +0100 > >Final-Recipient: rfc822;meadlaa at energyexhausts.co.uk >Action: delayed >Status: 4.4.7 >Will-Retry-Until: Thu, 29 Jul 2004 13:30:25 +0100 > >--9B095B5ADSN=_01C45B6D78732E16000007B1energys1.Energy. >Content-Type: message/rfc822 > >Received: from energys1.Energy.local ([192.168.0.254]) by >energys1.Energy.local with Microsoft SMTPSVC(5.0.2195.6713); > Tue, 27 Jul 2004 13:30:25 +0100 >Received: by energys1.Energy.local (Microsoft Connector for POP3 Mailboxes >5.00.2195) with SMTP (Global POP3 Download) > id MSG07272004-133012-3587.MMD at energyexhausts.co.uk; Tue, 27 Jul >2004 13:30:12 +0100 >Received: from pmta12.mta.everyone.net (bigiplb-dsnat [172.16.0.19]) > by imta20.mta.everyone.net (Postfix) with ESMTP id 0C12450803 > for <meadlaa at energyexhausts.co.uk>; Tue, 27 Jul 2004 05:22:03 -0700 >(PDT) >Received: from databaseadvisors.com (209.135.140.44 [209.135.140.44]) > by pmta12.mta.everyone.net (EON-PMTA) with ESMTP > id E183A471; Tue, 27 Jul 2004 05:22:03 -0700 >Received: from databaseadvisors.com (databaseadvisors.com [209.135.140.44]) > by databaseadvisors.com (8.11.6/8.11.6) with ESMTP id i6RCJeQ14879; > Tue, 27 Jul 2004 07:19:40 -0500 >Received: from xcgmd812.northgrum.com (xcgmd812.northgrum.com > [155.104.240.108]) > by databaseadvisors.com (8.11.6/8.11.6) with ESMTP id i6RCIQQ13444 > for <accessd at databaseadvisors.com>; Tue, 27 Jul 2004 07:18:26 -0500 >Received: by xcgmd812 with Internet Mail Service (5.5.2656.59) > id <PBGSX8B4>; Tue, 27 Jul 2004 05:18:22 -0700 >Received: from xcgmd805.northgrum.com ([155.104.117.53]) by > xcgmd805.northgrum.com with SMTP (Microsoft Exchange Internet > Mail Service Version 5.5.2653.13) > id PJV5RK32; Tue, 27 Jul 2004 05:17:00 -0700 >Received: from xcgva080 ([172.30.18.153]) by 155.104.117.53 with InterScan > Messaging Security Suite; Tue, 27 Jul 2004 05:17:00 -0700 >Received: from npeimc01.nns.com ([172.30.18.166]) by xcgva080 with >InterScan > Messaging Security Suite; Tue, 27 Jul 2004 08:18:13 -0400 >Received: by npeimc01.nns.com with Internet Mail Service (5.5.2657.72) > id <P41L9FJZ>; Tue, 27 Jul 2004 08:18:13 -0400 >From: "Mitsules, Mark S. (Newport News)" <Mark.Mitsules at ngc.com> >To: "'Access Developers discussion and problem solving'" ><accessd at databaseadvisors.com> >Message-ID: <E84A2AB789109340ADD89DB27040CB23015FAE4F at nnse14.nns.com> >Subject: RE: [AccessD] Multiple Table Search Was => RE: [AccessD] Query > giving different results each time >Date: Tue, 27 Jul 2004 08:18:12 -0400 >MIME-Version: 1.0 >X-Mailer: Internet Mail Service (5.5.2657.72) >Content-Type: text/plain >X-BeenThere: accessd at databaseadvisors.com >X-Mailman-Version: 2.1.4 >Precedence: list >Reply-To: Access Developers discussion and problem solving ><accessd at databaseadvisors.com> >List-Id: Access Developers discussion and problem solving > <accessd.databaseadvisors.com> >List-Help: <mailto:accessd-request at databaseadvisors.com?subject=help> >List-Post: <mailto:accessd at databaseadvisors.com> >List-Subscribe: <http://databaseadvisors.com/mailman/listinfo/accessd>, > <mailto:accessd-request at databaseadvisors.com?subject=subscribe> >List-Archive: <http://databaseadvisors.com/pipermail/accessd> >List-Unsubscribe: <http://databaseadvisors.com/mailman/listinfo/accessd>, > <mailto:accessd-request at databaseadvisors.com?subject=unsubscribe> >Sender: accessd-bounces at databaseadvisors.com >Errors-To: accessd-bounces at databaseadvisors.com >Return-Path: Mark.Mitsules at ngc.com >X-OriginalArrivalTime: 27 Jul 2004 12:30:25.0359 (UTC) >FILETIME=[7E128DF0:01C473D5] > >Thanks Drew. Meetings seem to be taking over my day so I will get back to >you ASAP with any feedback. > >Mark > > > >-----Original Message----- >From: DWUTKA at marlow.com [mailto:DWUTKA at marlow.com] >Sent: Monday, July 26, 2004 6:05 PM >To: accessd at databaseadvisors.com >Subject: RE: [AccessD] Query giving different results each time > > >Okay, here ya go. I built this into a form, because it uses a lot of >'techniques' to get things done. (Class modules, collections, callback >functions (for the list box)), along with all of the associated properties >that need to be set to get things done. So instead of trying to explain >how >to build the form, I'm just posting a link to download it. Right now, my >DSL is down (in case anyone wondered why the archives on my site weren't >there.....), it will be back up Thursday...so within a few days of that, I >will try to remember to put this file on my website. >(http://www.wolfwares.com) > >Until then, I put it on my company's website, for download. > >http://www.marlow.com/FindAllData.zip > >The zipped database has a form, query, and class module. Just import all >three into whatever database you want. Open the form, enter the search >criteria, and click the button. All applicable hits will be displayed in >the listbox. You can then double click the listbox to display either the >particular record (if a primary key for that table exists), or for all of >the results off of that table. > >Boy, that was actually fun to build! > >Drew > >FYI: This code only searches for text, in text and memo fields. It also >automatically puts astericks around the search criteria, so if you want to >put astericks inside the criteria, go ahead, but they're not necessary on >the outside. If you want to search number fields, the code could be >modified to do that. Actually, if there is enough of a request for it, I >could modify the search form to have different search boxes (text, >currency, >date/time, etc). Finally, and this is IMPORTANT, the code uses ADO. The >sample I built is in 97, which has DAO set by default, but if you use A2k, >make sure you have DAO selected. > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Mark A Matte >Sent: Monday, July 26, 2004 2:35 PM >To: accessd at databaseadvisors.com >Subject: [AccessD] Query giving different results each time > > >Hello All, > >In A97 I am running a local query...I couldn't get the results I >wanted...so > >I kept treaking my criteria...but then I realized...that if I didn'tchange >anything...I would get slightly different results...each time I ran it. It >would omit 1-5 rows...but not the same ones. > >Desperately confused...any insight? > >Thanks, > >Mark A. Matte > >SQL: > >SELECT tblPRS_Pending_PHONE.case_id, tblPRS_Pending_PHONE.profile_cm_seq, >tblPRS_Pending_PHONE.effdt, tblPRS_Pending_PHONE.bo_id, >tblPRS_Pending_PHONE.primary_ind, tblPRS_Pending_PHONE.phone >FROM tblPRS_Pending_PHONE >WHERE (((tblPRS_Pending_PHONE.effdt)=(SELECT Max(A.effdt) AS MaxOfeffdt >FROM tblPRS_Pending_PHONE A >WHERE tblPRS_Pending_PHONE.bo_id = A.bo_id;)) AND >((tblPRS_Pending_PHONE.primary_ind)="y")); > >_________________________________________________________________ >Express yourself instantly with MSN Messenger! Download today - it's FREE! >http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ > >-- >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com >-- >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com >-- >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com > > >--9B095B5ADSN=_01C45B6D78732E16000007B1energys1.Energy.-- >_______________________________________________ >dba-Tech mailing list >dba-Tech at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/dba-tech >Website: http://www.databaseadvisors.com