Setting up a constant value through VBA? please help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am struggling with this idea of mine. I am doing an accounting database,
where the client wants to exchange their dollar into another currency. I need
to set the security for the exchange rate, so I am the only one who can
change them. And then, when the transaction form is opened, the 'rate' column
can refer automatically to the constant i set up earlier (Total: [$]*RATE).
I'm thinking of making it just like a message box, where i can access it in
the switchboard. Can someone help me doing this? I'm not really profound in
programming so if you can help me a bit it would be very great. Thanks
 
My suggestion is to create a table, say, "tblCurrencies" as follows:

Currency_ID (Key)
Currency Name (string)
ExRate (Double) -> this is your constant
........
etc (ISO Code, subdivision, decimal place ....)

Create a form base on "tblCurrencies" to edit/the details of currencies that
are in use. Hide it from everybody except the admin, if you wish or block
modification to others.

Comment:
Depends how many forex transactions you may have, it makes no sense blocking
the ExRate from modification. If users are blocked and the actual exrate is
not the same as in table, the whole system grinds to a halt until the
authorised person changes the rate

Hope this help

Regards/JK





|I am struggling with this idea of mine. I am doing an accounting database,
| where the client wants to exchange their dollar into another currency. I
need
| to set the security for the exchange rate, so I am the only one who can
| change them. And then, when the transaction form is opened, the 'rate'
column
| can refer automatically to the constant i set up earlier (Total:
[$]*RATE).
| I'm thinking of making it just like a message box, where i can access it
in
| the switchboard. Can someone help me doing this? I'm not really profound
in
| programming so if you can help me a bit it would be very great. Thanks
 
Back
Top