[AccessD] Hooking into APIs of supplemental vendors

Hi Jim

I've found that in the cases where you need a "Double of a Double", the
subdatatype of Variant, Decimal, would do.

To create a Decimal, you need CDec:

  Dim varDecimal As Variant
  varDecimal = CDec(<SomeDecimalNumber>)

/gustav

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] På vegne af James Button
Sendt: 9. juli 2013 09:24
Til: Access Developers discussion and problem solving
Emne: Re: [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