IsConnected("Select count(ID) from transaction", False)
If myDR.Read = True Then
Me.TextBox1.Text = myDR.GetValue(0) + 1
Else
Me.TextBox1.Text = 1
End If
TextBox1.Focus()
End If
im going to ask how can i make my autonumber like these "10001" instead of "1"
can anyone help me to fix my code??