ACCPAC + VBA

[246809]

Hello
Is there a possibility that someone can show me how VBA can be linked with ACCPAC....is there a video, tutorial, PDF or step by step instructions as to show how to write code with VBA for ACCPAC??

 

[Jay Converse]

From the Accpac desktop:
Macro
Record
Do something
Stop recording
Look at the results

 

[246809]

ok thanks tuba2007....but can u give or show me an example

 

[Jay Converse]

Have you done what I said yet?
If you have, what exactly don't you understand?
Do you have any programming skills?

 

[246809]

Yes i do have programming skills in C and C++........so basically i just write code using VBA and import it with the "Macro" option in ACCPAC?

 

[Jay Converse]

No, you don't import macros, you record, edit, and run them. Do what I said the first time.

 

[246809]

ok cool buddy....thanks alot man....been a great help.....

 

[Bluejay07]

Are you talking about actually connecting to an Accpac SQL database using VBA? If this is the case, here is a good start:

http://www.connectionstrings.com

If at first you don't succeed, then sky diving wasn't meant for you!