Persistence Between Print Jobs 追蹤

0
Avatar
Legacy Poster

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!

1 意見

0
Avatar
Shotaro Ito
評論操作 永久連結

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]

登入寫評論。