Eric,
I did the following in the OrderRel VBForm table. It calls a progress program, then returns a value to one of the Vantage fields, including a custom date field. Maybe it will help...
The goal was to use a VBForm to:
A. Enter a Date labeled "Planned Ship Date" (Date01) on the OrderRel VB
Form. Then,
B. "On OK" (Exit) of the VBForm, change the Orderrel.NeedByDate to be 42
days prior to the Entered Date01.
The result was that in the "On OK" area of the VB Form I called a progress
program (runprog Date.p) which looks like the following:
/**************************************************************************
_Name: Date.p
_Description: This program is designed to back off the OrderRel.Date01date by 42 days and copy that new date to the
OrderRel.NeedByDate.
_Created By: Troy Funte
*/
/* include vbp/vb.i so VantageBasic functions are accessible. */
{vbp/vb.i}
/* Here define your own variables */
DEFINE VARIABLE Date-Val AS DATE.
/* do the calculation (Date01 - 42 days) */
Date-Val = getDateValue("DATE-FIELD_1") - 42.
/* Set the screen value of OrderRel.NeedbyDate to be the Date-Val variable. */
setDateValue("orderrel.needbydate.scrvalue":U,Date-Val).
RETURN.
/* end of Date.p routine */
-------------------------------------------------
I hope this helps someone get some new ideas.
Troy Funte
Liberty Electronics
I did the following in the OrderRel VBForm table. It calls a progress program, then returns a value to one of the Vantage fields, including a custom date field. Maybe it will help...
The goal was to use a VBForm to:
A. Enter a Date labeled "Planned Ship Date" (Date01) on the OrderRel VB
Form. Then,
B. "On OK" (Exit) of the VBForm, change the Orderrel.NeedByDate to be 42
days prior to the Entered Date01.
The result was that in the "On OK" area of the VB Form I called a progress
program (runprog Date.p) which looks like the following:
/**************************************************************************
_Name: Date.p
_Description: This program is designed to back off the OrderRel.Date01date by 42 days and copy that new date to the
OrderRel.NeedByDate.
_Created By: Troy Funte
*/
/* include vbp/vb.i so VantageBasic functions are accessible. */
{vbp/vb.i}
/* Here define your own variables */
DEFINE VARIABLE Date-Val AS DATE.
/* do the calculation (Date01 - 42 days) */
Date-Val = getDateValue("DATE-FIELD_1") - 42.
/* Set the screen value of OrderRel.NeedbyDate to be the Date-Val variable. */
setDateValue("orderrel.needbydate.scrvalue":U,Date-Val).
RETURN.
/* end of Date.p routine */
-------------------------------------------------
I hope this helps someone get some new ideas.
Troy Funte
Liberty Electronics
----- Original Message -----
From: Oleg Tumarkin
To: 'vantage@yahoogroups.com'
Sent: Tuesday, May 07, 2002 11:31 AM
Subject: RE: [Vantage] Quotedtl VB Form
Eric,
You will need a Progress program. You'll have to have a button to call it
from your VB form.
Oleg Tumarkin
Intelligent Systems Integration
(330) 335-5291
olegt@...
"Making Intelligent Use of Technology"
-----Original Message-----
From: othyghost [mailto:Eric@...]
Sent: Tuesday, May 07, 2002 9:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Quotedtl VB Form
I am trying to make a VB form on the Quotedtl that pulls the
quantity breaks into 5 character fields. Character01, Character02,
etc... Does anybody know how to do this? Can it be done through a
progress program that runs on the forms load? Any help would be
appreciated. Thanks.
Eric
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=226014.2032696.3508022.1829184/D=egroupweb/S=17050071
83:HM/A=1000239/R=0/*http://ads.x10.com/?bHlhaG9vaG0xLmRhd=1020779379%3eM=22
6014.2032696.3508022.1829184/D=egroupweb/S=1705007183:HM/A=1000239/R=1>
<http://us.adserver.yahoo.com/l?M=226014.2032696.3508022.1829184/D=egroupmai
l/S=1705007183:HM/A=1000239/rand=683391548>
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]