Very clearly explained mam .. Thank you soo much 🙏
@navaneethreddyntr46372 жыл бұрын
Mam fan your teaching..... Hatsoff mam......
@rewardlabel Жыл бұрын
"hi madam, how to reset invoice number every year april 1st finacial year," Function NewID() 'On Error Resume Next SalesDB.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + App.Path + "\Data\Transactions.mdb;Jet OLEDB:Database Password=z;" SalesDB.RecordSource = "select * from SalesDB" SalesDB.Refresh If Not SalesDB.Recordset.BOF = True Then 'Do nothing End If SalesIDText.Text = Val(SalesDB.Recordset.RecordCount) + 1 SalesDB.Recordset.Close End Function