I have no direct experience, but I understand that Al-Anon is very helpful for people who are impacted by the alcoholic. Perhaps this could be a good resource for you, in terms of finding strategies to deal with the impact of Frank's behaviour on your household.
Sending warm thoughts your way ..
Rose