Access

Resolved · Low Priority · Version 2003

Wed 18 Jun 2008, 16:41 Delegate Tp said...

Tp has attended:
Access Introduction course

Access

What is the best way of handling multi-currency transactions in Access?

Sat 5 Jul 2008, 23:40 Delegate Mark said...

RE: Access

Hello TP,

It sounds like you will need a field which designates the currency type against each currency entry. I would suggest having a look-up table to store the currency types by name and symbol, ie a field for each of these two within the look-up table. Then a third field in this table could be for conversion rates. If you need to keep the conversion rate that applied at a particular date and time (eg for a transaction or sale etc) then you will need for the conversion rate to store against each such record--by having a field in the table that stores details of such transactions). If you do enter conversion rates in to a form you set up for the purpose then you can have date and time against your entry to go in automatically by having and additional time field with a default value of Now()

If you need a reminder on how set up a look-up just reply so and I (or someone) will reply again.

Regards, Mark

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.

View all Access hints and tips