Passing data from a temp field to a user defined field

Yahoo Archive
1
We do something like this in MES, except we create a Unique UD01
record each time the click OK. A tag just prints out and the user
really does nothing but click OK in report quantity. I have a
printer defined for each USER as their user ID then Pass the number
to bartender using script. They click OK and I pass the parameter to
Bartender. Here is the code I use. I am guessing this might work
for your situation also.

Private Sub btnOk_Click(ByVal Sender As Object, ByVal Args As
System.EventArgs) Handles btnOk.Click
Dim Printer As String = UDTagsForm.Session.UserID
Dim UDTags As EpiDataView = Ctype(oTrans.EPiDataViews
("UDTags"),EpiDataView)
Dim TagNumber As String = txtEpiCustom1.Text
Dim strPath As String = "C:\Progra~1\Seagull\BarTender\8.0
\bartend.exe"
Dim strParam As String = "/F=C:\Tags.btw /PRN= /P /X /?
TagNumber="&TagNumber
Dim strParam2 As String = strParam.Insert(20,Printer)

' msgbox(strParam2)


Process.Start(strPath, strParam2)
End Sub

--- In vantage@yahoogroups.com, "greg.deterding"
<greg.deterding@...> wrote:
>
> I need some VB help.
>
> short version:
> I need to program a button that will take data from a temp number
> field called RQ.CurrentQTY and put it into a user defined field
like
> JobHead.Number01. Is this possible? Can anyone help me with the
code?
>
> Long version:
> We are trying to print material tags when quantity is reported in
MES.
> We need to have the end item part #, the material part #, and the
> current quantity reported on the label.
>
> There's a crystal report that uses an XML file with everything we
need
> including the temp field with the current quantity but we are
having
> problems with it printing to out label printer. So I am now trying
it
> with Bartender and an auto print BAM.
>
> Since Bartender can't use XML like crystal I'm setting up the data
> source through ODBC. Doing this means that I dont have access to
the
> temp field I need with the quantity. I am hoping that I can
accomplish
> 2 things with a custom button: A. passing the data from the
> RQ.CurrentQTY field to JobHead.Number01 so I can get it in
Bartender
> and B. checking a checkbox on
> jobhead that will trigger the autoprint BAM.
>
> If anyone's even still with me I really appreciate it. Some coding
> help on this would also be greatly appreciated. Im open to any
other
> ideas that maybe wouldn't be so complicated.
>
> thanks,
>
> Greg
>
2
I need some VB help.

short version:
I need to program a button that will take data from a temp number
field called RQ.CurrentQTY and put it into a user defined field like
JobHead.Number01. Is this possible? Can anyone help me with the code?

Long version:
We are trying to print material tags when quantity is reported in MES.
We need to have the end item part #, the material part #, and the
current quantity reported on the label.

There's a crystal report that uses an XML file with everything we need
including the temp field with the current quantity but we are having
problems with it printing to out label printer. So I am now trying it
with Bartender and an auto print BAM.

Since Bartender can't use XML like crystal I'm setting up the data
source through ODBC. Doing this means that I dont have access to the
temp field I need with the quantity. I am hoping that I can accomplish
2 things with a custom button: A. passing the data from the
RQ.CurrentQTY field to JobHead.Number01 so I can get it in Bartender
and B. checking a checkbox on
jobhead that will trigger the autoprint BAM.

If anyone's even still with me I really appreciate it. Some coding
help on this would also be greatly appreciated. Im open to any other
ideas that maybe wouldn't be so complicated.

thanks,

Greg