Re: Anyone here any good with MS access?
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.
Last edited by Spagbol; 07-20-2007 at 01:07 PM.