[AccessD] Hooking into APIs of supplemental vendors

Hi,

A word of warning -

I worked on an investment banking system with inbuilt currency conversion, 
and had to rewrite a module to use the equivalent of 'doubles' because some 
currencies hit 9 places to the £
that means that a simple conversion to/from £ needed 18 places of accuracy

Not useing that accuracy may not be a practical concern for the investor, 
but it sure can make it impossible to balance the accounts.
£100,000.00 invested at 200,000,000,000 to the £
and then 'sold' at - say 185,500,000,000

JimB

----- Original Message ----- 
From: "Darren" <darren at activebilling.com.au>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Tuesday, July 09, 2013 6:49 AM
Subject: Re: [AccessD] Hooking into APIs of supplemental vendors


> Hi William
> With a great deal of assistance from the very clever Stuart McLachlan, I
> built a currency converter in Access.
> It connects to a web service and returns results based on what you sent 
> it.
> The dB I wrote connects to...
> http://www.webservicex.net/CurrencyConvertor.asmx
> If you like I can send you a sample offline
>
> Darren
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Benson
> (VBACreations.Com)
> Sent: Monday, 8 July 2013 10:45 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Hooking into APIs of supplemental vendors
>
> Excellent!
>
> Not to mention that in this situation I am not really in need of anything
> very complicated.
>
> My only concern at this point is that my client decided they did not want 
> to
> pay the service fees to this vendor, and therefore it is not time/cost
> productive for me to spend time learning their tool.
>
> Well, it might be, but it is not calculable at this point how much, and it
> detracts from the project I am trying to finish.
>
> I am going to write something in a new thread that may be a little OT, but 
> I
> am fishing for ideas and caveats from fellow programmers. I look forward 
> to
> you and others chiming in on that thread.
>
> Bill
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
> Sent: Sunday, July 07, 2013 1:22 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Hooking into APIs of supplemental vendors
>
> William,
>
> In the few instances where I have used outside api's with vba I have 
> usually
> been able to find examples written in something close to vba, like VB6 in
> the old days. Now with all the internet forums there are usually examples
> that I can plagiarize and leverage for my purposes. Documentation can be
> obscure until you have something to compare it to.
>
> Doug
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Benson
> (VBACreations.Com)
> Sent: Saturday, July 06, 2013 1:27 PM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Hooking into APIs of supplemental vendors
>
> When a company offers a service - in my case, the company I am dealing 
> with
> has offered to allow me to use their API to have my application submit MMS
> and SMS messages - I get a sense that I am supposed, as a programmer, to
> know how to make the features in their application(s) a part of the
> program(s) I write. I know this happens all the time in the integrative
> development marketplace, but since I have programmed in 95% VBA, I don't
> really have the foggiest idea what they are talking about when they say 
> "Our
> API will do ______________ for you, feel free to download a free trial and
> ______________..." [get started using it??]
>
> I assume maybe all their stuff is well documented, but I feel too slow and
> stupid to understand documentation anymore and the "getting up to speed"
> factor is in line with teaching an old dog new tricks. Are they simple
> tricks? In other words, is this all supposed to be like plug and play
> programming, or am I supposed to be learning entirely new platforms in 
> order
> to get acquainted with different vendors' functionality? I suppose maybe 
> it
> is a case by case thing?
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com