Help in Accpac VBA

[Guest_imported]

Hi everybody,
I'm a new user in Accpac system.
I already try out the VBA coding to retrieve data from Accpac. In order to retrieve data, we use Openview statement.
syntax: Openview("ViewID", "ProgID&quot

My question is, where to get the ViewID and ProgID????
by the way, do you have the complete guide/sample to customize Accpac using VBA? and any sample of updating data to Accpac and pervasive sql server.
Thank you.

songlip

 

[UC27]

Hi Songlip

Your Question :

Songlip (Visitor) May 31, 2002
Hi everybody,
I'm a new user in Accpac system.
I already try out the VBA coding to retrieve data from Accpac. In order to retrieve data, we use Openview statement.
syntax: Openview("ViewID", "ProgID&quot

My question is, where to get the ViewID and ProgID????
by the way, do you have the complete guide/sample to customize Accpac using VBA? and any sample of updating data to Accpac and pervasive sql server.
Thank you.

songlip

My answer :

As far as I know (I might be wrong) , you have to have the SDK for AccPac Development. It is a lot like the MSDN libraries for Microsoft Development programs like Visual Basic ect and it is something that you must subscribe to. In that SDK you get fantastic material with things like ROTO-Views where you will get the information for that VIEWID and PROGID. Yes, you can develop without the SDK, but the SDK surely makes it a lot easier and more possible.

JayCee

 

[TrungMC]

Hey, I come here to get help but I found that I'm still better than someone else? If you wanna get the viewid, just open the .ini files like Gl.ini in the GL42A folder, AR.ini in AR42A folder etc...

 

[Guest_imported]

Why don't you just use the VBA Macro recorder and reuse the code generated. dealing with accpac views is not easy and not documented anywhere! the problem is not only with view id ( you get it if you have the customization kit ) there is a sequence of calling that should be followed which cannot be anticipated.