Pinhole Camera help!?

Will the distance between the film and the pinhole affect the capturing of pictures? My pinhole camera does not work and I am wondering what the problem is. How much exposure time should I try? I'm using the 24 shots film. Is 1mm hole too big?