Hi there,
I am trying to back up a table in Advantage 4.2 by using the xAPI code I developped (posted under ACCPAC Macro/VBA (http://www.tek-tips.com/gviewthread.cfm/lev2/78/lev3/80/pid/631/qid/616765)
I changed the views to correspond with the tables for this version of accpac. By using the...
Hi Zemp,
Seems I got it working with a little perseverance... But I'd like to post the code nevertheless to get your opinion on it (I think there can be adjustments made to it...)
Here it goes:
Set ICVENDOR = Session.OpenView("IC0340", "IC")
myRS.MoveFirst...
Hi Zemp, thanks for the quick response. I am taking updated values from my file and trying to update the existing records in Accpac... I reading out of an access DB and set the records up in the same order as the accpac table. Here's what I have so far...
Set ICVENDOR =...
Hello Zemp,
Thanks for that awesome reply... I can now grab data and store it in my file. Now I'm trying to return the values into the table and update the values from my file. I was wondering if I should use the BulkPut or Update function. The sub is almost the same:
Set Session =...
Thanks for the reply... I got my project started in VB and referenced that xAPI... What I'd like to do is cycle through the records of my vendor table to pull out all the info and save that to my file. So far I have:
Private Sub Form_Load()
Dim Session As ACCPACXAPILib.xapiSession
Set...
Hi there, I am trying to get a macro going in 5.1 where I export an IC table before the day end processing and then importing the IC table back afterwards. I used the macro recorder and got the process day end automated, but the macro recorder won't record the import and export process of my IC...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.