Currency Conversion

[abdullahsikandar]

Does anyone have currency conversation here? in Access?

[June7]

What do you mean by 'currency conversion' - international monetary exchange rates?

[abdullahsikandar]

Yes June7, I want to make a form where i can give the amount manually for every currency and then change it accordingly to the other currency.

For example :

I have USD and want to change it to EUR, so user can say 1 dollar= 500 EUR manually and give the total amount and get the result. Its sort of Currency calculator.

[June7]

Maybe a form with 3 controls. Enter USD amount in textbox, select a country in a combobox, expression in another textbox calculates the foreign currency.

The combobox could have a RowSource from a table of countries and their exchange rate as related to USD. The RowSource would have two columns. The calculation in textbox could be like:

=[tbxUSD] * [cbxCountry].Column(1)

[abdullahsikandar]

Thanks can you provide me the whole code? I didn`t write anything... yet?

[June7]

What code? Nothing I described requires any VBA or macro code.

It's a simple unbound form with 3 unbound controls.

[abdullahsikandar]

Well I didn`t get it then can you explain me how to do it?

[June7]

1. build table of countries with exchange rate

2. build form with 2 textboxes and 1 combobox

3. set combobox RowSource to pull data from the table

4. put described expression in ControlSource of 1 textbox

This is very basic Access functionality.