Recent content by ClaytonM

I tried the combo boxes on my wife and got a reply: "Why can't we just enter a fraction like Excel" I didn't thing to pull in the excel library JHB. I already had written my code for fraction conversion. Probably would have saved me some time. Live and learn. I just figured it out. I know...

Not bad. I looked at this before Galaxiom;). Its a little complicated for the users as they enter one value in two places instead of just typing a fraction, like an excel cell. I will try it out on them.

Ok JHB, it is attached. The rough version of the form is attached. Under ingredients subform, the first column is how it is stored, which I would prefer not to display. The second is a textbox displaying it converted into fraction via this in its control: =FractionIt([Amount]) FractionIt...

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...

Hello from Hunan, China! I am an American small business owner working my way through my 4th access project. I have been snooping around for help on this site for a long time. It has been a lot of help. Thank you! Clay