Hi,
I'm writing a macro to read customer database info. I don't know how to loop through the database and list or print all the fields IDCUST, IDGRP, NAMECUST for IDGRP="ADM". Can someone please help?
Thanks.
Dim Session As ACCPACXAPILib.xapiSession
Dim ARCUSTOMER As ACCPACXAPILib.xapiView
Dim ARCUSTOMERFields As ACCPACXAPILib.xapiFields
Set Session = CreateObject("ACCPAC.xapisession"
Session.Open "ADMIN", "HOLLAND", "SAMINC", Date, 0
Set ARCUSTOMER = Session.OpenView("AR0024", "AR"
Set ARCUSTOMERFields = ARCUSTOMER.Fields
ARCUSTOMER.Init
ARCUSTOMER.Order = 0
???
ARCUSTOMER.Cancel
I'm writing a macro to read customer database info. I don't know how to loop through the database and list or print all the fields IDCUST, IDGRP, NAMECUST for IDGRP="ADM". Can someone please help?
Thanks.
Dim Session As ACCPACXAPILib.xapiSession
Dim ARCUSTOMER As ACCPACXAPILib.xapiView
Dim ARCUSTOMERFields As ACCPACXAPILib.xapiFields
Set Session = CreateObject("ACCPAC.xapisession"
Session.Open "ADMIN", "HOLLAND", "SAMINC", Date, 0
Set ARCUSTOMER = Session.OpenView("AR0024", "AR"
Set ARCUSTOMERFields = ARCUSTOMER.Fields
ARCUSTOMER.Init
ARCUSTOMER.Order = 0
???
ARCUSTOMER.Cancel