I need your help with a code.
I need to increase by 1 the last number in my accdb access, column Invoice from my VB6 tool.
So if the highest number in column Invoice is1012, when i click on a button, then Text2 will have 1013 as the new invoice number.
oConnect.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source= C:\Base.accdb;"
Thanks for your help