So my wife started a bakery and she was occasionally screwing up on multiplying recipes and tracking costs in orders. I opened my big mouth and said I could write a database to do all that, no problem. Then I realized cooks like to work in fractions and Access has no way to deal with fractions like Excel.:banghead:
So I wrote some code to convert fractions as strings back and forth and store as doubles, as I need to do calculations on the values. Where I ran into a roadblock is how to handle them on the recipe entry form so the user isn't entering in one text box and seeing the data in another or doing a pop-up. Not a good user experience if you cannot enter data and hit tab. Any suggestions?
So I wrote some code to convert fractions as strings back and forth and store as doubles, as I need to do calculations on the values. Where I ran into a roadblock is how to handle them on the recipe entry form so the user isn't entering in one text box and seeing the data in another or doing a pop-up. Not a good user experience if you cannot enter data and hit tab. Any suggestions?
Improve user experience with fractions
