Huh?
Tanya Jernigan, V.P.
tjernigan@... <mailto:tjernigan@...>
www.waterjetparts.com <http://www.waterjetparts.com/>
H2O Jet, Inc.
1043-D Kaiser Rd. SW
Olympia, WA 98512
360-866-7161 Phone
360-866-7610 Fax
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Podlin, Michael
Sent: Thursday, June 08, 2006 2:09 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Alert Program? (Version 6.1)
The only thing the BAM is giving vs my Automated report is that the BAM
can occur the instance a change takes place, with my Automated Report, a
.P procedure is executed at 3am each day compiling all the "past due"
information into a htm file which is then pushed to the Autoreports
e-mail engine and sent to the responsible people. Not real time, but
within 24 hrs.... (and it allows me to create a list of items vs one
e-mail for each item)
If you really wanted something to actually trigger off a BAM, you could
use a VBForm field which the BAM fires off of. You'll then need to
create a .W application with a pstimer.ocx which will trigger every x
seconds running a query against your date values. Items that become past
due, the .W application would then update the VBForm field value that
should trigger the BAM. Down side is that you'll have to execute this
inside an open session of Vantage which will use up one of your
licenses.
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On
Behalf Of Kennedy, Jim
Sent: Thursday, June 08, 2006 3:56 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Alert Program? (Version 6.1)
I do already have all of those reports created using Excel & MS Query
(linked via ODBC), and they're setup to "Refresh on file open," but of
course my GM requested that I give my lazy co-managers more of a nudge.
Thus the thought of finding a way to trigger the BAM...
_____________________________
Jim Kennedy
Manager, Information Technologies
Firstmark Aerospace Corporation
1176 Telecom Drive
Creedmoor, North Carolina 27752
Office: (919) 956-4264
FAX: (919) 682-3786
Cell: (919) 697-9410
jkennedy@firstmarka <mailto:jkennedy%40firstmarkaerospace.com>
erospace.com <mailto: jkennedy@firstmarka
<mailto:jkennedy%40firstmarkaerospace.com> erospace.com>
www.firstmarkaerospace.com < http://www.firstmar
<http://www.firstmarkaerospace.com/ <http://www.firstmarkaerospace.com/>
<http://www.firstmarkcorp.com/ <http://www.firstmarkcorp.com/> >
kcorp.com/>
________________________________
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Podlin, Michael
Sent: Thursday, June 08, 2006 4:25 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Alert Program? (Version 6.1)
What I do is execute automated reports with time/date filters on a daily
basis which are e-mailed to the people responsible or need to be aware
of late/past due items.
-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ]On
Behalf Of Aaron Hoyt
Sent: Thursday, June 08, 2006 2:10 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Alert Program? (Version 6.1)
Jim,
Unless I am mistaken, this is one of the limitations of the BAM (alert
program). The BAM must see a change is a field, but can't be triggered
just
by time going by.
Please let me know if someone has found another method around this.
Thanks,
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com]On
Behalf Of
Kennedy, Jim
Sent: Thursday, June 08, 2006 11:35 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Alert Program? (Version 6.1)
Hello,
Has anyone got a quick example of an alert program (progress file) you
may
have developed to trigger based on the calculated age of a value in a
date
field?
Just looking for a quick shortcut...
Thanks in advance,
_____________________________
Jim Kennedy
Manager, Information Technologies
Firstmark Aerospace Corporation
1176 Telecom Drive
Creedmoor, North Carolina 27752
Office: (919) 956-4264
FAX: (919) 682-3786
Cell: (919) 697-9410
jkennedy@firstmarka <mailto:jkennedy%40firstmarkaerospace.com>
erospace.com
www.firstmarkaerospace.com < http://www.firstmar
< http://www.firstmar <http://www.firstmarkaerospace.com/
<http://www.firstmarkaerospace.com/> > kaerospace.com/ <
http://www.firstmar <http://www.firstmarkaerospace.com/
<http://www.firstmarkaerospace.com/> > kaerospace.com/>
< http://www.firstmar <http://www.firstmarkcorp.com/
<http://www.firstmarkcorp.com/> > kcorp.com/ < http://www.firstmar
<http://www.firstmarkcorp.com/ <http://www.firstmarkcorp.com/> >
kcorp.com/> >
kcorp.com/>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Tanya Jernigan, V.P.
tjernigan@... <mailto:tjernigan@...>
www.waterjetparts.com <http://www.waterjetparts.com/>
H2O Jet, Inc.
1043-D Kaiser Rd. SW
Olympia, WA 98512
360-866-7161 Phone
360-866-7610 Fax
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Podlin, Michael
Sent: Thursday, June 08, 2006 2:09 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Alert Program? (Version 6.1)
The only thing the BAM is giving vs my Automated report is that the BAM
can occur the instance a change takes place, with my Automated Report, a
.P procedure is executed at 3am each day compiling all the "past due"
information into a htm file which is then pushed to the Autoreports
e-mail engine and sent to the responsible people. Not real time, but
within 24 hrs.... (and it allows me to create a list of items vs one
e-mail for each item)
If you really wanted something to actually trigger off a BAM, you could
use a VBForm field which the BAM fires off of. You'll then need to
create a .W application with a pstimer.ocx which will trigger every x
seconds running a query against your date values. Items that become past
due, the .W application would then update the VBForm field value that
should trigger the BAM. Down side is that you'll have to execute this
inside an open session of Vantage which will use up one of your
licenses.
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On
Behalf Of Kennedy, Jim
Sent: Thursday, June 08, 2006 3:56 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Alert Program? (Version 6.1)
I do already have all of those reports created using Excel & MS Query
(linked via ODBC), and they're setup to "Refresh on file open," but of
course my GM requested that I give my lazy co-managers more of a nudge.
Thus the thought of finding a way to trigger the BAM...
_____________________________
Jim Kennedy
Manager, Information Technologies
Firstmark Aerospace Corporation
1176 Telecom Drive
Creedmoor, North Carolina 27752
Office: (919) 956-4264
FAX: (919) 682-3786
Cell: (919) 697-9410
jkennedy@firstmarka <mailto:jkennedy%40firstmarkaerospace.com>
erospace.com <mailto: jkennedy@firstmarka
<mailto:jkennedy%40firstmarkaerospace.com> erospace.com>
www.firstmarkaerospace.com < http://www.firstmar
<http://www.firstmarkaerospace.com/ <http://www.firstmarkaerospace.com/>
> kaerospace.com/>www.firstmarkcorp.com < http://www.firstmar
<http://www.firstmarkcorp.com/ <http://www.firstmarkcorp.com/> >
kcorp.com/>
________________________________
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Podlin, Michael
Sent: Thursday, June 08, 2006 4:25 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] Alert Program? (Version 6.1)
What I do is execute automated reports with time/date filters on a daily
basis which are e-mailed to the people responsible or need to be aware
of late/past due items.
-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ]On
Behalf Of Aaron Hoyt
Sent: Thursday, June 08, 2006 2:10 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Alert Program? (Version 6.1)
Jim,
Unless I am mistaken, this is one of the limitations of the BAM (alert
program). The BAM must see a change is a field, but can't be triggered
just
by time going by.
Please let me know if someone has found another method around this.
Thanks,
Aaron Hoyt
Vantage Plastics
-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com]On
Behalf Of
Kennedy, Jim
Sent: Thursday, June 08, 2006 11:35 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Alert Program? (Version 6.1)
Hello,
Has anyone got a quick example of an alert program (progress file) you
may
have developed to trigger based on the calculated age of a value in a
date
field?
Just looking for a quick shortcut...
Thanks in advance,
_____________________________
Jim Kennedy
Manager, Information Technologies
Firstmark Aerospace Corporation
1176 Telecom Drive
Creedmoor, North Carolina 27752
Office: (919) 956-4264
FAX: (919) 682-3786
Cell: (919) 697-9410
jkennedy@firstmarka <mailto:jkennedy%40firstmarkaerospace.com>
erospace.com
www.firstmarkaerospace.com < http://www.firstmar
< http://www.firstmar <http://www.firstmarkaerospace.com/
<http://www.firstmarkaerospace.com/> > kaerospace.com/ <
http://www.firstmar <http://www.firstmarkaerospace.com/
<http://www.firstmarkaerospace.com/> > kaerospace.com/>
> kaerospace.com/>www.firstmarkcorp.com < http://www.firstmar
< http://www.firstmar <http://www.firstmarkcorp.com/
<http://www.firstmarkcorp.com/> > kcorp.com/ < http://www.firstmar
<http://www.firstmarkcorp.com/ <http://www.firstmarkcorp.com/> >
kcorp.com/> >
kcorp.com/>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]