I know exactly what you mean. I get awful migranes sometimes, when all you can do is cry. It's terrible. I recently found something called "Head On Migrane" ... it's a stick that looks like a gluestick, and you actually rub it on your head/temples, etc. It doesn't make it go away when it's that bad, but it is the only thing that will ease it up a bit for me. I also try to have something sweet to pop in my mouth - like a hard candy, and sometimes that helps too.
Buy HeadOn - Apply Directly to Forehead Migraine Relief Online at drugstore.com