No desire on sex. He stops medication.

Hello, my husband is not interested in sex,everyday he says reasons to avoid the intercourse, he wants to make it once  for 15days and so...if I force him...he gives all silly reasons...sometimes he accepts and finishes it mechanically(no kisses no foreplay,  says "want to intercourse directly").His reasons are like...sleepy,fatigue due to day work, headache, digestion problem, had a long journey, drowsy due to alcohol, sometimes he says situation should come to have sex..eventhough we have privacy ,I had word with my inlaws they are not taking it seriously, on weekends he drinks alot.He has no desire on sex and gives statements like weekly once is enough, dont expect life like movies..etc. How can I change him...will he be changed by medication?..will he be same if he stops medication .