[AccessD] Hooking into APIs of supplemental vendors

Stuart McLachlan stuart at lexacorp.com.pg
Tue Jul 9 05:52:28 CDT 2013


Just to be pedantic, if you need 18 digits of precision a double won't cut it either.

You need  an 8 byte Quad integer or a 10 byte extended precision float for that.



-- 
Stuart 

On 9 Jul 2013 at 8:23, James Button wrote:

> 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 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 





More information about the AccessD mailing list