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
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 3,352
Thanks: 60
Thanked 772 Times in 715 Posts
ridders has a spectacular aura about ridders has a spectacular aura about ridders has a spectacular aura about
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
Attached Images
File Type: png CurrencyExchange.PNG (71.1 KB, 362 views)
Attached Files
File Type: zip CurrencyExchangeRates.zip (229.8 KB, 92 views)

__________________
Colin
Mendip Data Systems
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.
, Tapatalk


If this answer has helped, please:
Click the Thanks button and/or click the 'reputation' scales symbol on the left, tick 'I approve' and leave a comment. Cheers!

Last edited by ridders; 11-23-2017 at 04:46 PM.
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
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 3,352
Thanks: 60
Thanked 772 Times in 715 Posts
ridders has a spectacular aura about ridders has a spectacular aura about ridders has a spectacular aura about
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
Attached Files
File Type: zip CurrencyExchangeRates1.1.zip (244.7 KB, 63 views)
__________________
Colin
Mendip Data Systems
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.
, Tapatalk


If this answer has helped, please:
Click the Thanks button and/or click the 'reputation' scales symbol on the left, tick 'I approve' and leave a comment. Cheers!
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: 1,659
Thanks: 212
Thanked 233 Times in 219 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
AWF VIP
Gold Supporter
 
ridders's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 3,352
Thanks: 60
Thanked 772 Times in 715 Posts
ridders has a spectacular aura about ridders has a spectacular aura about ridders has a spectacular aura about
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, 38 views)
File Type: png CERT_Chart2.PNG (61.9 KB, 36 views)
File Type: png CERT_Chart1.PNG (62.8 KB, 34 views)

__________________
Colin
Mendip Data Systems
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.
, Tapatalk


If this answer has helped, please:
Click the Thanks button and/or click the 'reputation' scales symbol on the left, tick 'I approve' and leave a comment. Cheers!
ridders is offline   Reply With Quote
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 12:08 PM.


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