Code Conversion from Access 2007 VBA to VB.Net

[Laredo_TX]

Hi All,

I am rewriting an Access 2007 database application in VB.Net. I need to add empty records in to a table that after the empty records will be populated with actual information that will print to the labels in the correct position on a used sheet of labels.

I have had this working for many years in VBA, but have no idea how to do it in VB.Net.

The included code is what I have in VBA right now. I just need the code equivalent to replace Variant and NZ.

Here is my VBA Code

Dim bytPosition As Variant
Dim bytCounter As Byte
' Add one empty record at the begin of the table before actually adding data after empty records.

bytPosition = Nz(Me!txtStart.Value, 0)

For bytCounter = 2 To bytPosition
' Code that went here to add one empty record at a time
Next

Thanks

Continue reading...