Database /Access/Visual Basic help

[newsman]

I need a big help in doing database for work. I need some buttons on the forms. One should be a currency converter button, so when an input is done on curreny exchange rate field, the result currency is automatically calculated and displayed in another field. I am using Access and I know Access uses VBA (visual basic for access) to add custom tools on vba. To calculate result currency is simple, but what is their to retrieve information entered in one field, and manipulate it, and give output on another Access database field????

[Leper_Messiah]

Salam Alekom

First are using ADO for calling the data from the database? if so you just calculate the vlaue you want and hold it into a variable, and make a DB connection and command, and within the command use the UPDATE statment with the value in the variable and then fire the command, that is all

If you need more help let me know

Salam Alekom

[Leper_Messiah]

P.S.
use the same teqniqe to call the data from the database, claculate then update, i guess you dont know what is ADO right?

[newsman]

nope,, but today, its ok,, having taken my contact to the cleaners (the professionals) who won't get started until one month and take another month to completion as well as charging three times, more,, my contact is happy to give a realistic time to learn and implement a solution for him. (like a more then a month)

I was hoping there to be a simpler expression builder command...

but never mind, i will look into ADO

[WiseOne]

If you require any further assistance, please feel free to start a new topic.

Thanks for choosing MPADC.