How do I add a Contact to Goldmine with MS Access 1

[Hap007]

Please Help, I am in over my head regarding Goldmine API:

I need to add a contact record from MS access to Goldmine 6.0 I have been given the Goldmine program, the API Specifications Manual, (For GM5S32.DLL) and told to go.

Turns out that:
1) Goldmine 6.0 uses GM6s32.dll (probably very similiar)
2) I can not seem to get VBA to create the "GMcomAPI.Application" object.

I must not have something set correctly, but if you have any pointers or know where I could find some simple code sample, it would be much appreciated.

Thanks,
Hap
Access Add-on developer

http://www.fcs-software.com

-

 

[richardy]

Hi,

Thanks for the vote

>I need to add a contact record from MS access to Goldmine 6.0 I have been given the Goldmine program, the API Specifications Manual, (For GM5S32.DLL) and told to go.

Turns out that:
1) Goldmine 6.0 uses GM6s32.dll (probably very similiar)
2) I can not seem to get VBA to create the "GMcomAPI.Application" object.

I must not have something set correctly, but if you have any pointers or know where I could find some simple code sample, it would be much appreciated.<

The com object is crap dont use it. Is GoldMine running in the background? If so then its real easy, just use DDE.

I'm not really familiar with Access VBA but heres some psuedo code:

hgM = dderequest(&quot;[OPEN(CONTACT1)]&quot

dderequest(&quot;[APPEND(&quot;+hgm+&quot]&quot

ddereplace(&quot;[REPLACE(&quot;+hgm+&quot;,COMPANY,&quot;+chr(34)+&quot;MYVALUE2=chr(34)+&quot]&quot

.....and so on replacing COMPANY with the field name

ddereplace(&quot;[UNLOCK(&quot;+hGM+&quot]&quot
ddereplace(&quot;[CLOSE(&quot;+hGM+&quot]&quot

if you then need to go on to update contact2 fields you'd then OPEN CONTACT2 similiar to above.

HTH.

Regards,

Richard Young.
PRIOR Analytics UK
The Number 1 UK Solutions Partner

 

[Hap007]

Thanks,
Hap
Access Add-on developer

http://www.fcs-software.com

-