VB Forms linking to Part Drawings, etc

Yahoo Archive
1
That will definitely be a nice option, as long as it is not manditory.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Winter, Patrick
To: 'vantage@yahoogroups.com'
Sent: Monday, December 02, 2002 9:50 AM
Subject: RE: [Vantage] VB Forms linking to Part Drawings, etc.


This will be pretty cool in version 6.0 when you can move the VBFORM button
to the front screen where it's needed and even change the TAB order of the
screen to include it.

Patrick

-----Original Message-----
From: Podlin, Michael [mailto:michael.podlin@...]
Sent: Wednesday, November 27, 2002 4:20 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] VB Forms linking to Part Drawings, etc.


Yes it can be done. I currently link our SPC charts/graphs/data to a button
on the Job Tracker - Operation level VB-Form so that you can view the most
recent SPC graphs/data for that specific operation.

Set the button on the VB-Form with the RUNPROG vdp/program.p

In the program.p, do a FIND vantage-table WHERE ROWID(vantage-table) =
GetCurrentRowID() no-lock.

This will set you program so that it has the current record from which the
VB-Form is from.

Then just do a DOS SILENT command to launch your external program.

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Wednesday, November 27, 2002 3:51 PM
To: Vantage
Subject: [Vantage] VB Forms linking to Part Drawings, etc.


Has anyone successfully linked a VB Form to a procedure which can identify a
specific filename... based on a current field referenced by the current
table in the VB Form? I'd love to discuss details with you if possible.

We would like to have a VB Form which does the following:

1. From the Inspection Receipt screen, with PartNum "ABC" selected,
2. Click the VB Forms button.
3. Click a XLS button on the VB Form, which activates a progress program,
which retrieves the "ABC.xls" file from the server and opens it in Excel.
4. There would also be a DWG button on the VB Form, which when activate,
would retrieve the "ABC.dwg" CAD file in either autocad or an autocad
viewer.

Does anyone know what progress procedure would do such a thing?

Troy


[Non-text portions of this message have been removed]



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 http://docs.yahoo.com/info/terms/



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 http://docs.yahoo.com/info/terms/


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]
2
Has anyone successfully linked a VB Form to a procedure which can identify a specific filename... based on a current field referenced by the current table in the VB Form? I'd love to discuss details with you if possible.

We would like to have a VB Form which does the following:

1. From the Inspection Receipt screen, with PartNum "ABC" selected,
2. Click the VB Forms button.
3. Click a XLS button on the VB Form, which activates a progress program, which retrieves the "ABC.xls" file from the server and opens it in Excel.
4. There would also be a DWG button on the VB Form, which when activate, would retrieve the "ABC.dwg" CAD file in either autocad or an autocad viewer.

Does anyone know what progress procedure would do such a thing?

Troy


[Non-text portions of this message have been removed]
3
Yes it can be done. I currently link our SPC charts/graphs/data to a button
on the Job Tracker - Operation level VB-Form so that you can view the most
recent SPC graphs/data for that specific operation.

Set the button on the VB-Form with the RUNPROG vdp/program.p

In the program.p, do a FIND vantage-table WHERE ROWID(vantage-table) =
GetCurrentRowID() no-lock.

This will set you program so that it has the current record from which the
VB-Form is from.

Then just do a DOS SILENT command to launch your external program.

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Wednesday, November 27, 2002 3:51 PM
To: Vantage
Subject: [Vantage] VB Forms linking to Part Drawings, etc.


Has anyone successfully linked a VB Form to a procedure which can identify a
specific filename... based on a current field referenced by the current
table in the VB Form? I'd love to discuss details with you if possible.

We would like to have a VB Form which does the following:

1. From the Inspection Receipt screen, with PartNum "ABC" selected,
2. Click the VB Forms button.
3. Click a XLS button on the VB Form, which activates a progress program,
which retrieves the "ABC.xls" file from the server and opens it in Excel.
4. There would also be a DWG button on the VB Form, which when activate,
would retrieve the "ABC.dwg" CAD file in either autocad or an autocad
viewer.

Does anyone know what progress procedure would do such a thing?

Troy


[Non-text portions of this message have been removed]



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 http://docs.yahoo.com/info/terms/
4
I now have a VB Form that has a button labelled "XLS" on the NonConformance Entry window. Pressing the XLS button launches a program-xls.p that opens the "partnumber.xls" document that matches the part number in the NonConformance window.

A couple questions:
1. Opening Excel from the VBForm causes Vantage to 'lock up' while the Excel File is opened. I can't use Vantage until I close Excel. Is there a way to release Vantage after the Excel is launched without having to close Excel?

2. After pressing the XLS button on the VBForm, it takes a good 20 seconds to open up Excel. When I do the same procedure using PDF, it comes up instantly. Any ideas why the long delay in Excel?

Thanks for the help.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Podlin, Michael
To: 'vantage@yahoogroups.com'
Sent: Wednesday, November 27, 2002 5:20 PM
Subject: RE: [Vantage] VB Forms linking to Part Drawings, etc.


Yes it can be done. I currently link our SPC charts/graphs/data to a button
on the Job Tracker - Operation level VB-Form so that you can view the most
recent SPC graphs/data for that specific operation.

Set the button on the VB-Form with the RUNPROG vdp/program.p

In the program.p, do a FIND vantage-table WHERE ROWID(vantage-table) =
GetCurrentRowID() no-lock.

This will set you program so that it has the current record from which the
VB-Form is from.

Then just do a DOS SILENT command to launch your external program.

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Wednesday, November 27, 2002 3:51 PM
To: Vantage
Subject: [Vantage] VB Forms linking to Part Drawings, etc.


Has anyone successfully linked a VB Form to a procedure which can identify a
specific filename... based on a current field referenced by the current
table in the VB Form? I'd love to discuss details with you if possible.

We would like to have a VB Form which does the following:

1. From the Inspection Receipt screen, with PartNum "ABC" selected,
2. Click the VB Forms button.
3. Click a XLS button on the VB Form, which activates a progress program,
which retrieves the "ABC.xls" file from the server and opens it in Excel.
4. There would also be a DWG button on the VB Form, which when activate,
would retrieve the "ABC.dwg" CAD file in either autocad or an autocad
viewer.

Does anyone know what progress procedure would do such a thing?

Troy



[Non-text portions of this message have been removed]
5
Troy, we link Excel spreadsheets several places using VB Forms without any
problems. No lock-ups and the spreadsheets open fast (depending on the
workstation). For example, I have a simple VB Program called "vendorxls"
that opens a spreadsheet from the vendor tracker or vendor master file
maint. Each vendor has their own sheet saved as (vendor ID).xls. The button
command is "runvbp k:\vantage\vbp\vendorxls". The VB Program is "shellexec
h:\common\vendornotes\{vendor.CHAR-FIELD_1.scrvalue}.xls". Because vendor
ID is not an available field in vendor tracker we input the ID in
CAR-FIELD_1 on the VB Form when set up a new vendor. Not real sophisticated
but works well.

Jerry Boyle
Sipco Molding Technologies
Meadville, PA. 16335
p 814.724.2243 x53
f 814.724.2244
vantage 5.00.339

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Wednesday, November 27, 2002 4:51 PM
To: Vantage
Subject: [Vantage] VB Forms linking to Part Drawings, etc.

Has anyone successfully linked a VB Form to a procedure which can identify a
specific filename... based on a current field referenced by the current
table in the VB Form? I'd love to discuss details with you if possible.
We would like to have a VB Form which does the following:
1. From the Inspection Receipt screen, with PartNum "ABC" selected,
2. Click the VB Forms button.
3. Click a XLS button on the VB Form, which activates a progress program,
which retrieves the "ABC.xls" file from the server and opens it in Excel.
4. There would also be a DWG button on the VB Form, which when activate,
would retrieve the "ABC.dwg" CAD file in either autocad or an autocad
viewer.
Does anyone know what progress procedure would do such a thing?
6
Jerry,
Thanks for your comments. I used the VB command "shellexec" instead of the Progress command "DOS SILENT", but it still took 15 seconds for Excel to open, and then it locked me out of Vantage until I closed the Excel Sheet. I'm on a test machine (using TCP). Maybe this would work better on a client/server setup instead.

Troy

----- Original Message -----
From: Jerry Boyle
To: vantage@yahoogroups.com
Sent: Friday, November 29, 2002 8:52 AM
Subject: RE: [Vantage] VB Forms linking to Part Drawings, etc.


Troy, we link Excel spreadsheets several places using VB Forms without any
problems. No lock-ups and the spreadsheets open fast (depending on the
workstation). For example, I have a simple VB Program called "vendorxls"
that opens a spreadsheet from the vendor tracker or vendor master file
maint. Each vendor has their own sheet saved as (vendor ID).xls. The button
command is "runvbp k:\vantage\vbp\vendorxls". The VB Program is "shellexec
h:\common\vendornotes\{vendor.CHAR-FIELD_1.scrvalue}.xls". Because vendor
ID is not an available field in vendor tracker we input the ID in
CAR-FIELD_1 on the VB Form when set up a new vendor. Not real sophisticated
but works well.

Jerry Boyle
Sipco Molding Technologies
Meadville, PA. 16335
p 814.724.2243 x53
f 814.724.2244
vantage 5.00.339

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Wednesday, November 27, 2002 4:51 PM
To: Vantage
Subject: [Vantage] VB Forms linking to Part Drawings, etc.

Has anyone successfully linked a VB Form to a procedure which can identify a
specific filename... based on a current field referenced by the current
table in the VB Form? I'd love to discuss details with you if possible.
We would like to have a VB Form which does the following:
1. From the Inspection Receipt screen, with PartNum "ABC" selected,
2. Click the VB Forms button.
3. Click a XLS button on the VB Form, which activates a progress program,
which retrieves the "ABC.xls" file from the server and opens it in Excel.
4. There would also be a DWG button on the VB Form, which when activate,
would retrieve the "ABC.dwg" CAD file in either autocad or an autocad
viewer.
Does anyone know what progress procedure would do such a thing?


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]
7
Update: I just tried the process on a Vendor VBForm instead of the Non-Conf VBForm. The Vendor VBForm does not tie up Vantage and starts up immediately. I wonder why the Non-Conf table acts so differently?

Troy Funte
Liberty Electronics

----- Original Message -----
From: Troy Funte
To: vantage@yahoogroups.com
Sent: Friday, November 29, 2002 3:12 PM
Subject: Re: [Vantage] VB Forms linking to Part Drawings, etc.


Jerry,
Thanks for your comments. I used the VB command "shellexec" instead of the Progress command "DOS SILENT", but it still took 15 seconds for Excel to open, and then it locked me out of Vantage until I closed the Excel Sheet. I'm on a test machine (using TCP). Maybe this would work better on a client/server setup instead.

Troy

----- Original Message -----
From: Jerry Boyle
To: vantage@yahoogroups.com
Sent: Friday, November 29, 2002 8:52 AM
Subject: RE: [Vantage] VB Forms linking to Part Drawings, etc.


Troy, we link Excel spreadsheets several places using VB Forms without any
problems. No lock-ups and the spreadsheets open fast (depending on the
workstation). For example, I have a simple VB Program called "vendorxls"
that opens a spreadsheet from the vendor tracker or vendor master file
maint. Each vendor has their own sheet saved as (vendor ID).xls. The button
command is "runvbp k:\vantage\vbp\vendorxls". The VB Program is "shellexec
h:\common\vendornotes\{vendor.CHAR-FIELD_1.scrvalue}.xls". Because vendor
ID is not an available field in vendor tracker we input the ID in
CAR-FIELD_1 on the VB Form when set up a new vendor. Not real sophisticated
but works well.

Jerry Boyle
Sipco Molding Technologies
Meadville, PA. 16335
p 814.724.2243 x53
f 814.724.2244
vantage 5.00.339

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Wednesday, November 27, 2002 4:51 PM
To: Vantage
Subject: [Vantage] VB Forms linking to Part Drawings, etc.

Has anyone successfully linked a VB Form to a procedure which can identify a
specific filename... based on a current field referenced by the current
table in the VB Form? I'd love to discuss details with you if possible.
We would like to have a VB Form which does the following:
1. From the Inspection Receipt screen, with PartNum "ABC" selected,
2. Click the VB Forms button.
3. Click a XLS button on the VB Form, which activates a progress program,
which retrieves the "ABC.xls" file from the server and opens it in Excel.
4. There would also be a DWG button on the VB Form, which when activate,
would retrieve the "ABC.dwg" CAD file in either autocad or an autocad
viewer.
Does anyone know what progress procedure would do such a thing?


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]


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]
8
This will be pretty cool in version 6.0 when you can move the VBFORM button
to the front screen where it's needed and even change the TAB order of the
screen to include it.

Patrick

-----Original Message-----
From: Podlin, Michael [mailto:michael.podlin@...]
Sent: Wednesday, November 27, 2002 4:20 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] VB Forms linking to Part Drawings, etc.


Yes it can be done. I currently link our SPC charts/graphs/data to a button
on the Job Tracker - Operation level VB-Form so that you can view the most
recent SPC graphs/data for that specific operation.

Set the button on the VB-Form with the RUNPROG vdp/program.p

In the program.p, do a FIND vantage-table WHERE ROWID(vantage-table) =
GetCurrentRowID() no-lock.

This will set you program so that it has the current record from which the
VB-Form is from.

Then just do a DOS SILENT command to launch your external program.

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Wednesday, November 27, 2002 3:51 PM
To: Vantage
Subject: [Vantage] VB Forms linking to Part Drawings, etc.


Has anyone successfully linked a VB Form to a procedure which can identify a
specific filename... based on a current field referenced by the current
table in the VB Form? I'd love to discuss details with you if possible.

We would like to have a VB Form which does the following:

1. From the Inspection Receipt screen, with PartNum "ABC" selected,
2. Click the VB Forms button.
3. Click a XLS button on the VB Form, which activates a progress program,
which retrieves the "ABC.xls" file from the server and opens it in Excel.
4. There would also be a DWG button on the VB Form, which when activate,
would retrieve the "ABC.dwg" CAD file in either autocad or an autocad
viewer.

Does anyone know what progress procedure would do such a thing?

Troy


[Non-text portions of this message have been removed]



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 http://docs.yahoo.com/info/terms/



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 http://docs.yahoo.com/info/terms/