Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. xenzat

    Getting different totals when exporting and cycling through a table

    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...
  2. xenzat

    COMAPI for Accpac 4.2

    A simple question really... Will I be able to use the ComApi object in my VB development for Accpac 4.2? Thanks (Zemp) :) Xenzat
  3. xenzat

    ACCPAC Macro/VBA

    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...
  4. xenzat

    ACCPAC Macro/VBA

    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 =...
  5. xenzat

    ACCPAC Macro/VBA

    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 =...
  6. xenzat

    ACCPAC Macro/VBA

    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...
  7. xenzat

    ACCPAC Macro/VBA

    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...

Part and Inventory Search

Back
Top