Saving Serial Data to MS Access after printing

Andrew

• August 31, 2018 18:29

I have an Access 2016 database linked to my file print. Example Table is called MASTER and this is what table looks like

PartNum       BoxNum

1234                            1

5678                            1

I have everything linked to access but it won't remember last box number i left off on for the next print. I have no idea how to use VB but want to write the next box number back to access so it always picks up right where it left off at.

 

Can anyone help?

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • September 07, 2018 08:41

  Hi Andrew,

  Not sure how to write out to an Access Database but I know you can use the Write commands in VB to add data into a text/CSV file. 

  Pete

  0
• 

  Andrew

  ★ BarTender Hero ★

  • September 07, 2018 13:08

  Pete,

  I do not know how to write VB code to accomplish this. I was hoping someone could write a sample code that I could use to accomplish this task.

  Andrew

  0

Please sign in to leave a comment.