hi. how to insert a record in cust table from vb form thanks shabeer
Set up a configuration file with business connector enabled and a login and password. Set Security to allow this user to write to CustTable. Dim Axapta As AxaptaCOMConnector.Axapta Dim AxaptaRecord As AxaptaCOMConnector.IAxaptaRecord Set Axapta = New AxaptaCOMConnector.Axapta ’ use path to configuration file Axapta.Logon “”, “”, “”, “F:\PROGRAMS\TensileLabUpload\auto.axc” Set AxaptaRecord = Axapta.CreateRecord(“CustTable”) AxaptaRecord.field(“AccountNum”) = “12345” AxaptaRecord.field(“Name”) = “This Company” … AxaptaRecord.Insert