Persistence Between Print Jobs

Legacy Poster

• August 19, 2014 21:19

Hi, I am trying to figure out if this is possible.

 

I have a script that works off of a list in an excel file.

I wanted to know if I can make it so the script will "remember" what was printed last and keep the selection on that point in the item list in print station.

Maybe write an extra line on a secondary column and refer to that for position in the list? Just grasping at straws here.

 

Here is the current script:

 

Functions and Subs

dim objConn
dim strConn
dim rs

strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source='c:\Database\ingredients.xlsx';Extended Properties=""Excel 12.0 Xml;HDR=YES;IMEX=1;"""


Public Function GetNames()
Dim strNames

Set objConn = CreateObject("ADODB.Connection")
objConn.Open strConn
Set rs = CreateObject("ADODB.Recordset")
Set rs = objConn.Execute("SELECT * FROM [Sheet1$]")

strNames = ""
rs.MoveFirst()
do while NOT rs.EOF
strNames = strNames + rs.fields("Ingredients") + vbCrLf
rs.MoveNext()
loop

GetNames = strNames

End Function

 

ONFILLLIST

Value = GetNames()

 

Thank you!

0

• 

  Shotaro Ito

  ★ BarTender Hero ★

  • August 21, 2014 04:03

  Hi,

  In Template design View, on linked data source's Transform, There's data entry control's setting to update data source after print.

  Note this is not shown on Data Entry Form design view.

  [attachment=1140:UpdateDatasourceAfterPrint.png]

  0

Please sign in to leave a comment.