Mike Haldas has written an excellent tutorial in which he builds a simple circuit with a push button and a couple of LEDs to trigger the camera module to take a photograph. The photograph is then auto-uploaded to Twitter. Read more here.