Capture1.JPGCapture2.JPG
I want to make a program where I can convert any type of measurements to any other type.
I have created a table with the values with factor to meter (see picture).
I would like to have to combo boxes to select which measurement to convert to and from, one field to put in the value and a last bok to show the result. (next picture)
The problem is that I dont know where to start, and where to go from here. Any tips?
Have you created a Form yet?
Or the combos, Command Button or text box?
The VBA code for the calculation would be on the Button's "On Click" Event Procedure.
Originally Posted by OBP
Yes, I have created a form. I have also used a table design to tell what to multiply with to convert any form (miles, KM, yard, centimeter, foot, meter, milimeter, mil and nautical mile) to meter.
In the form I have one field to enter the value which I want to convert, two combo boxes to choose what form I want to convert from and to, and in the end, one field where new value should appear.
I have re-created your database and created the VBA code.
See attached database.
However your conversion factors are not accurate enough when converting Metric to Imperial and back again.
Reply With Quote
