Go Back   Access World Forums > Microsoft Access Reference > Sample Databases

 
Reply
 
Thread Tools Rating: Thread Rating: 2 votes, 3.00 average. Display Modes
Old 11-23-2017, 04:28 PM   #1
ridders
Newbee moderator
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 5,533
Thanks: 79
Thanked 1,372 Times in 1,281 Posts
ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough
Currency Exchange Rates

The attached database has been created as a practical example using downloaded JSON data from an online source.

The database gets the latest exchange rates from a free online data source at: http://fixer.io
Exchange rates are updated daily for a selection of common currencies
By default, the base rate has been set as British Pounds Sterling (GBP) but can be modified to any other supported currency



NOTE:
1. Other data sources are available if you need LIVE exchange rate data for a larger number of currencies. You may have to pay for live exchange data.

2. For more information about parsing JSON data in Access, please see this thread
https://www.access-programmers.co.uk...d.php?t=295789

3. Another application which uses imported JSON data is the UK Address Finder database
https://www.access-programmers.co.uk...d.php?t=295378

Any questions, please send me a PM or email me using the link below

UPDATE 29/05/2018:
This version will no longer work after 1 June 2018 - see post 5 for an explanation
Please download the latest version (still free) from my website
http://www.mendipdatasystems.co.uk/free-apps/4592091376
Attached Images
File Type: png CurrencyExchange.PNG (71.1 KB, 980 views)
Attached Files
File Type: zip CurrencyExchangeRates.zip (229.8 KB, 252 views)

__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left and leave a comment.

New example databases:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


-------------------------
nil illegitimi carborundum est

Last edited by ridders; 05-29-2018 at 09:24 AM.
ridders is offline   Reply With Quote
The Following 4 Users Say Thank You to ridders For This Useful Post:
Minty (11-24-2017), MrHans (11-23-2017), Peter Reid (11-28-2017), ypma (11-24-2017)
Old 11-28-2017, 05:12 AM   #2
ridders
Newbee moderator
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 5,533
Thanks: 79
Thanked 1,372 Times in 1,281 Posts
ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough
Re: Currency Exchange Rates

Minor update to v1.1 following user feedback: (Thanks Paul)

Two changes made:
a) selected currency is now retained after changing base currency
b) fixed issue where selected currency becomes new base currency

Any other feedback, please email me

UPDATE 29/05/2018:
This version will no longer work after 1 June 2018 - see post 5 for an explanation
Please download the latest version (still free) from my website
http://www.mendipdatasystems.co.uk/free-apps/4592091376
Attached Files
File Type: zip CurrencyExchangeRates1.1.zip (244.7 KB, 172 views)
__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left and leave a comment.

New example databases:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


-------------------------
nil illegitimi carborundum est

Last edited by ridders; 05-29-2018 at 09:23 AM.
ridders is offline   Reply With Quote
The Following User Says Thank You to ridders For This Useful Post:
Gasman (11-28-2017)
Old 11-28-2017, 07:19 AM   #3
Gasman
Access newbie
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 2,046
Thanks: 259
Thanked 307 Times in 292 Posts
Gasman will become famous soon enough Gasman will become famous soon enough
Re: Currency Exchange Rates

Works a treat.

Thank you.

__________________
Access novice. Sometimes trying to give something back.
Access 2007
Gasman is offline   Reply With Quote
Old 12-24-2017, 08:55 AM   #4
ridders
Newbee moderator
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 5,533
Thanks: 79
Thanked 1,372 Times in 1,281 Posts
ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough
Currency Exchange Rates TRACKER

I've added an enhanced version of this application to my website.
The new version allows you to:
a) track changes in exchange rates over a period of time
b) plot the data as a chart

See attached screenshots

The updated version is available here:
http://www.mendipdatasystems.co.uk/free-apps/4592091376

Its still free but supplied as an ACCDE file (both 32-bit and 64-bit available).
An ACCDB version with full code can optionally be purchased from the website at a low price
Attached Images
File Type: png CERT_Tracker.PNG (83.7 KB, 172 views)
File Type: png CERT_Chart2.PNG (61.9 KB, 119 views)
File Type: png CERT_Chart1.PNG (62.8 KB, 116 views)
__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left and leave a comment.

New example databases:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


-------------------------
nil illegitimi carborundum est
ridders is offline   Reply With Quote
Old 05-29-2018, 09:19 AM   #5
ridders
Newbee moderator
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 5,533
Thanks: 79
Thanked 1,372 Times in 1,281 Posts
ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough ridders is a jewel in the rough
Re: Currency Exchange Rates

The currency exchange rate tracker has been updated to version 1.42

The main reason for the update is that the data provider fixer.io has updated their service to provide significant additional functionality including support for 168 currencies (previously 32).

The provider has also changed the download site and account settings. This means that the previous version of this app will no longer work after 1 June 2018

From that date, NEW users will have to pay $10 per month.
However because I am an existing customer, I have been transferred to a free legacy account with all the new features.
As the provider put it, I have been 'grandfathered into the legacy account'
That's a phrase I'd never heard before and took as a polite way of saying I'm an old customer !

Anyway, the upshot is if you update to the new version, the app & online data is still available FREE.

Its too big to upload to the forum but is now available FREE from my website: http://www.mendipdatasystems.co.uk/free-apps/4592091376
I hope its useful to others.

__________________
Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left and leave a comment.

New example databases:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


-------------------------
nil illegitimi carborundum est

Last edited by ridders; 06-01-2018 at 04:22 AM.
ridders is offline   Reply With Quote
The Following User Says Thank You to ridders For This Useful Post:
Peter Reid (06-04-2018)
Reply

Tags
currency exchange , json parser

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Currency Exchange Rate update mveijndh Modules & VBA 3 01-03-2016 01:51 AM
Update hourly rates with exceptions that use a different list of rates. ParachuteTechnology Modules & VBA 4 04-04-2014 03:40 PM
Convert Currency to another currency amount AlaaB Modules & VBA 9 08-18-2010 11:35 PM
Exchange rates From the Web?? ian_w Modules & VBA 1 12-16-2008 10:38 AM
Display currency value in a string but retain the currency format s_m_chamberlain Reports 1 08-22-2006 02:20 AM




All times are GMT -8. The time now is 01:18 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World