Vantage 6.1 / Command line in a custom button to open a spreadsh

Try This:



Private Sub btnOpen_Click(ByVal Sender As Object, ByVal Args
As System.EventArgs) Handles btnOpen.Click

'// ** Place Event Handling Code Here **

Process.Start("excel.exe", "File Location")

End Sub



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mark Howard
Sent: Tuesday, July 01, 2008 1:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 6.1 / Command line in a custom button to open a
spreadsheet



Hi all

Hoping someone could help, I am trying to make a button in Vantage open
a particular spreadsheet

I have added a button in the order detail screen so a salesman can press
the button and a spreadsheet will open, I have added the button but
don't know what the command line would be to open an excel spread sheet

Has anyone got any idea's??

Mark Howard

Financial Controller

Jaws Buckets & Attachments

Ph- 07-32777499

10 Willingdon st

Archerfield 4108



[Non-text portions of this message have been removed]
I am trying to display OrderDtl.Number20 on my Job Entry form and I
cannot figure out a way to get to the OrderDtl table to do so. Can
anyone offer some guidance how I can create a Foreign Key View to that
table? Or is there is another way of getting that field displayed in Job
Entry?



Thank You

Todd H.



[Non-text portions of this message have been removed]
You would first create a FKV using MakeToOrder to the OrderHed.
Then do a SubTable View using OrderDtl. On the subtable view at the
following Parent and Child View Colums.
OrderHed.Company __> OrderDtl.Company
OrderHed.OrderNum __> OrderDtl.OrderNum
OrderHed.OrderLine __>OrderDtl.OrderLine

--- In vantage@yahoogroups.com, "Todd Hofert" <todd@...> wrote:
>
> I am trying to display OrderDtl.Number20 on my Job Entry form and I
> cannot figure out a way to get to the OrderDtl table to do so. Can
> anyone offer some guidance how I can create a Foreign Key View to
that
> table? Or is there is another way of getting that field displayed
in Job
> Entry?
>
>
>
> Thank You
>
> Todd H.
>
>
>
> [Non-text portions of this message have been removed]
>
Thanks Mike, this is exactly what I needed. Perfect.



Todd



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michael McWilliams
Sent: Thursday, June 19, 2008 1:57 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Foreign Key View - V8.03.404



You would first create a FKV using MakeToOrder to the OrderHed.
Then do a SubTable View using OrderDtl. On the subtable view at the
following Parent and Child View Colums.
OrderHed.Company __> OrderDtl.Company
OrderHed.OrderNum __> OrderDtl.OrderNum
OrderHed.OrderLine __>OrderDtl.OrderLine

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Todd Hofert" <todd@...> wrote:
>
> I am trying to display OrderDtl.Number20 on my Job Entry form and I
> cannot figure out a way to get to the OrderDtl table to do so. Can
> anyone offer some guidance how I can create a Foreign Key View to
that
> table? Or is there is another way of getting that field displayed
in Job
> Entry?
>
>
>
> Thank You
>
> Todd H.
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
I was hoping someone could help me; I'm tring to write a report in
report builder and use a trim command to return a character from a part
number



Out part number look like



EX-01M-13331

BH-31MQ-18937

BH-11-18788



I need to write a function that will trim the part no from the end then
return the 6 character from there. I need to trim left because my only
constant is all our part number end with a - then 5 numbers. I can trim
from the from of the part number because they all vary in length



So in the case above my formula would look like



If (partno (Trim left 6 characters) = "Q" , "yes", "No")



Regards,



Mark Howard



[Non-text portions of this message have been removed]
Go into the assembly reference manager and determine which custom assemblies have to be added to support OrderDtl in Job Entry. (Then Add them as Custom assemblies.)
Â
You should then be able to create an FKV from JobHead to JobProd and then a SubTable from FKV JobProd to OrderDtl.
Â
Depending upon what you intend to do with OrderDtl.Number20 in your customized job entry, you may also have to bring in the adapter needed to manipulate OrderDtl records.
Â
Rob Brown.

--- On Thu, 6/19/08, Todd Hofert <todd@...> wrote:

From: Todd Hofert <todd@...>
Subject: [Vantage] Foreign Key View - V8.03.404
To: vantage@yahoogroups.com
Date: Thursday, June 19, 2008, 1:42 PM






I am trying to display OrderDtl.Number20 on my Job Entry form and I
cannot figure out a way to get to the OrderDtl table to do so. Can
anyone offer some guidance how I can create a Foreign Key View to that
table? Or is there is another way of getting that field displayed in Job
Entry?

Thank You

Todd H.

[Non-text portions of this message have been removed]
I did not test this but this should be close.



IIF(SubString(Part.PartNum,Length(Part.PartNum) - 6,1) = 'Q',"Yes","No")



Patrick J. Winter



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Howard
Sent: Thursday, June 19, 2008 7:22 PM
To: vantage@yahoogroups.com
Subject: [SPAM] [Vantage] Left trim a part no "report builder"..please
help!



I was hoping someone could help me; I'm tring to write a report in
report builder and use a trim command to return a character from a part
number

Out part number look like

EX-01M-13331

BH-31MQ-18937

BH-11-18788

I need to write a function that will trim the part no from the end then
return the 6 character from there. I need to trim left because my only
constant is all our part number end with a - then 5 numbers. I can trim
from the from of the part number because they all vary in length

So in the case above my formula would look like

If (partno (Trim left 6 characters) = "Q" , "yes", "No")

Regards,

Mark Howard

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





This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

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

I'm a little confused. Are you trying to extract the left-most 6
characters from your part number or are you looking to extract the one
character in the 6th location within your part number?

What version of Vantage are you using? You say "Report Builder" below,
I'm assuming you mean the BAQ Report Designer or BAQ Queries as the
Report Builder refers to the Financial Report Builder.

Either way, if you choose to do this within the BAQ Query, you need to
use Progress syntax. There is a Progress left trim function. It's
appropriately named LEFT-TRIM().

I have the Progress Reference Book in PDF format (8MB). Let me know if
you'd like a copy.

I personally would do all the trimming and formatting in Crystal....
again, assuming you are on 8.03.XXX which has the ability to do BAQ
Reports and pump out the XML to Crystal Reports. You have a lot more
control in Crystal with parsing out strings using Left() Right() Mid()
and others.



Vic Drecchio

ERP Administrator



TIMCO Aviation Services

Greensboro, NC

Email: vic.drecchio@...

Office: 336.668.4410 x3091

Mobile: 704.530.3092


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mark Howard
Sent: Thursday, June 19, 2008 8:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Left trim a part no "report builder"..please help!



I was hoping someone could help me; I'm tring to write a report in
report builder and use a trim command to return a character from a part
number

Out part number look like

EX-01M-13331

BH-31MQ-18937

BH-11-18788

I need to write a function that will trim the part no from the end then
return the 6 character from there. I need to trim left because my only
constant is all our part number end with a - then 5 numbers. I can trim
from the from of the part number because they all vary in length

So in the case above my formula would look like

If (partno (Trim left 6 characters) = "Q" , "yes", "No")

Regards,

Mark Howard

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






[Non-text portions of this message have been removed]
You might try this:



SUBSTRING(Part.PartNum, 1 , INDEX(Part.PartNum,"-",4) - 1)



To detail this formula:

INDEX(PART.PARTNUM,"-",4) -1

INDEX looks at the PartNum field for the "-" character starting at position
4

Your part number examples show the "-" always in position 3 of your number
so you start at position 4.
The INDEX function looks right till it finds your next "-". Then
respectively it will return the numbers:

EX-01M-13331 will return "7" With the minus 1 returning 6

BH-31MQ-18937 will return "8" With the minus 1 returning 7

BH-11-18788 will return "6" With the minus 1 returning 5


SUBSTRING ( Part.PartNum , 1 , 6 "from first pn") will give you the first 6
letters of your part number.

Part.PartNum (the string you are parsing)

,1, the starting position of the PARSE

,6) the number of characters you are "subbing"

Hope this helps.

Shirley Graver




[Non-text portions of this message have been removed]
Sorry for the vagueness of my question was getting little frustrated
when I typed it. Thanks for the reply's so far



I am trying to trim the part number from right to left



I need to start at the end of my part number and return the result of
the 7th character to the left



So for say these 3 part number the results will be

EX-01M-13331 will return "M"


BH-31MQ-18937 will return "Q"

BH-11-18788 will return "1"



I then need to incorporate the result into a If statement



SO

If( ( Unknown formula) = "Q" , "yes","no")



Vantage 6.1 using Progress Report builder



Regards,

Mark











________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Shirley Graver
Sent: Friday, 20 June 2008 11:42 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Left trim a part no "report builder"..please
help!



You might try this:



SUBSTRING(Part.PartNum, 1 , INDEX(Part.PartNum,"-",4) - 1)



To detail this formula:

INDEX(PART.PARTNUM,"-",4) -1

INDEX looks at the PartNum field for the "-" character starting at
position
4

Your part number examples show the "-" always in position 3 of your
number
so you start at position 4.
The INDEX function looks right till it finds your next "-". Then
respectively it will return the numbers:

EX-01M-13331 will return "7" With the minus 1 returning 6

BH-31MQ-18937 will return "8" With the minus 1 returning 7

BH-11-18788 will return "6" With the minus 1 returning 5


SUBSTRING ( Part.PartNum , 1 , 6 "from first pn") will give you the
first 6
letters of your part number.

Part.PartNum (the string you are parsing)

,1, the starting position of the PARSE

,6) the number of characters you are "subbing"

Hope this helps.

Shirley Graver



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





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



Thank-you So much. Has made my life a little easier



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Winter, Patrick
Sent: Friday, 20 June 2008 10:54 PM
To: vantage@yahoogroups.com
Subject: RE: [SPAM] [Vantage] Left trim a part no "report
builder"..please help!



I did not test this but this should be close.

IIF(SubString(Part.PartNum,Length(Part.PartNum) - 6,1) = 'Q',"Yes","No")

Patrick J. Winter

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Mark Howard
Sent: Thursday, June 19, 2008 7:22 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [SPAM] [Vantage] Left trim a part no "report builder"..please
help!

I was hoping someone could help me; I'm tring to write a report in
report builder and use a trim command to return a character from a part
number

Out part number look like

EX-01M-13331

BH-31MQ-18937

BH-11-18788

I need to write a function that will trim the part no from the end then
return the 6 character from there. I need to trim left because my only
constant is all our part number end with a - then 5 numbers. I can trim
from the from of the part number because they all vary in length

So in the case above my formula would look like

If (partno (Trim left 6 characters) = "Q" , "yes", "No")

Regards,

Mark Howard

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

This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

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





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





Hoping someone could help, I am trying to make a button in Vantage open
a particular spreadsheet



I have added a button in the order detail screen so a salesman can press
the button and a spreadsheet will open, I have added the button but
don't know what the command line would be to open an excel spread sheet



Has anyone got any idea's??



Mark Howard

Financial Controller

Jaws Buckets & Attachments

Ph- 07-32777499

10 Willingdon st

Archerfield 4108

.


<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007181/msg
Id=66005/stime=1214009814/nc1=3848643/nc2=5379227/nc3=4836038>




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