Cramps

I get serve cramps and it gets to the point where I can't really walk(because of the pain) and I eventually throw up. It prevents me from going to school and being active. Midol and all the other over the counter cramp medicine doesn't usually  work. Does anyone have advice or help?