Completeness and Cocompleteness of Module Categories