Jim Lawrence
accessd at shaw.ca
Tue Jul 9 14:59:12 CDT 2013
Or you add 30 zeros to a string, position the real value minus a decimal point, save decimal point position in a separate small integer field and then the calculations are performed in double integers. You then do your own rounding scheme and the calculated decimal point position is apply for presentation. (Did that a few years ago for fairly comprehensive Access to AccPac to MS SQL project.) It is supposed to be a more accurate way to handle these large values but I have no conformation one way or the other. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Tuesday, July 09, 2013 3:52 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Hooking into APIs of supplemental vendors 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 > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com