Mitsules, Mark S. (Newport News)
Mark.Mitsules at ngc.com
Wed Jul 28 08:37:56 CDT 2004
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.--