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
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,581
Thanks: 88
Thanked 1,618 Times in 1,507 Posts
isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice
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, 1177 views)
Attached Files
File Type: zip CurrencyExchangeRates.zip (229.8 KB, 302 views)

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

Web links:
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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : 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.

Last edited by isladogs; 05-29-2018 at 09:24 AM.
isladogs is offline   Reply With Quote
The Following 4 Users Say Thank You to isladogs 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
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,581
Thanks: 88
Thanked 1,618 Times in 1,507 Posts
isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice
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, 203 views)
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Web links:
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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : 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.

Last edited by isladogs; 05-29-2018 at 09:23 AM.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs 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,413
Thanks: 291
Thanked 375 Times in 360 Posts
Gasman has a spectacular aura about Gasman has a spectacular aura about
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
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,581
Thanks: 88
Thanked 1,618 Times in 1,507 Posts
isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice
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, 198 views)
File Type: png CERT_Chart2.PNG (61.9 KB, 129 views)
File Type: png CERT_Chart1.PNG (62.8 KB, 118 views)
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Web links:
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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : 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.
isladogs is offline   Reply With Quote
Old 05-29-2018, 09:19 AM   #5
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 6,581
Thanks: 88
Thanked 1,618 Times in 1,507 Posts
isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice isladogs is just really nice
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.

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

Web links:
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.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Previously known as ridders : 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.

Last edited by isladogs; 06-01-2018 at 04:22 AM.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs 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 10:22 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