Who's Harry Crumb? (1989)

Nerves of steel. Body of iron. Brain of stone.

Harry Crumb is a bumbling and inept private investigator who is hired to solve the kidnapping of a young heiress which he's not expected to solve because his employer is the mastermind behind the kidnapping.