Exchange Rate/ currency conversion (1 Viewer)

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 14:33
Joined
May 7, 2009
Messages
19,169
this is a simple program that will convert 1 US dollar to any currency.
it gets the data from http://www.floatrates.com/daily/usd.xml.

the old method (Internet Explorer application) will not work on Win 10/11.
therefore this db is modified to use XMLDocument to get the data.

there are two subs (GetRates and GetNewRates), that does exactly the
same thing.
the only difference is that GetNewRates uses XML parsing rather than
manual scraping (GetRates).

modify to suit your need for other Base currency of your choice.
 

Attachments

  • ExchangeRate2.accdb
    772 KB · Views: 565

Gasman

Enthusiastic Amateur
Local time
Today, 06:33
Joined
Sep 21, 2011
Messages
14,048
this is a simple program that will convert 1 US dollar to any currency.
it gets the data from http://www.floatrates.com/daily/usd.xml.

the old method (Internet Explorer application) will not work on Win 10/11.
therefore this db is modified to use XMLDocument to get the data.

there are two subs (GetRates and GetNewRates), that does exactly the
same thing.
the only difference is that GetNewRates uses XML parsing rather than
manual scraping (GetRates).

modify to suit your need for other Base currency of your choice.
Anyone able to convert down to 2007 please?, I'd like to look at this.?
TIA
 

Solo712

Registered User.
Local time
Today, 02:33
Joined
Oct 19, 2012
Messages
828
Good work, arnel. I made two small adds: 1) a form to get the exchange on any two currencies using USD as reference. 2) a column in the table that converts the date string for updates for sorting on dates.
 

Attachments

  • ExchangeRate2x.accdb
    1.5 MB · Views: 354

Gasman

Enthusiastic Amateur
Local time
Today, 06:33
Joined
Sep 21, 2011
Messages
14,048
Any chance on a 2007 version please?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 14:33
Joined
May 7, 2009
Messages
19,169
i have not modified it yet in A2007.
for those with newer than A2007, here is another updated db.
you can now Select the Base Currency to use (other than USD).
 

Attachments

  • ExchangeRate3.accdb
    2 MB · Views: 180

Gasman

Enthusiastic Amateur
Local time
Today, 06:33
Joined
Sep 21, 2011
Messages
14,048
@arnelgp
Just a version that 2007 can open please arnel.
I have just downloaded your continuous form colour control example and that opens fine?
 

mounty76

Registered User.
Local time
Yesterday, 23:33
Joined
Sep 14, 2017
Messages
341
i have not modified it yet in A2007.
for those with newer than A2007, here is another updated db.
you can now Select the Base Currency to use (other than USD).
Hi Arnelgp,

This is great however I'm struggling to understand the code, any advise greatly appreciated. I'm using a very simple table (attached) that I'd like the exchange rates updating every 10 min using a hidden form as you mentioned in an earlier post.

If I add more exchange rates then I'd want these updating too, even better would be if the exchange rate could be references to the home currency selected in the table?

I'm completely lost on this so any help is greatly appreciated!

Thank you
 

Attachments

  • Sample.accdb
    572 KB · Views: 67

Users who are viewing this thread

Top Bottom