Anyone here any good with MS access?

[Al M]

I'm currently trying to create a database in MS access. I have all the tables and forms working correctly but simply. My problem is one field on the form I have created requires a number of kilometres, but the data collected is in miles (there's no way around this that's just how it is). I want to be able to input the miles on to this form and access to do the conversion automatically. However, I have no idea how to achieve this. Anyone got any ideas?

Cheers

Al

[Spagbol]

I never use Access directly... whenever I need to use .mdb databases I write my own front-end (in good ol' VB6 hehe). That way, it's easy to code conversions and simple to write to the db with SQL statements, but those who like using Access can still get to all the data.
If that's a possibility I could PM you some code but will have to wait until after the weekend as I'm ultra busy.

Alternatively, the way I'd do it within Access is to have both Miles and Kilometers fields on the form and have Access convert whatever you put into the Miles field into Kilometers and auto enter it into the correct field when you press enter:
1) Open the form
2) Click the View button to open the Property Sheet
3) Click on the Kilometers field
4) Under the Data tab choose the Control Source box and hit the ... button
5) In the code box enter [Miles]*1.60934
N.B. replace [Miles] for the name of your Miles field (with the square brackets).

Now when you enter a value in the Miles field and hit enter, the correct Kilometers value will show in the Kilometers field.

Hope that helps.