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 >