Help with fpga clock?

Defining a constraint only tells the program to route the gates in order to meet this timing but won't actually change the clock frequency. You have to instantiate a DCM to convert your 50Mhz clock to a 40Mhz clock. The Spartan 3 users guide describes the DCM in detail. You'll have to come up with a suitable multiply/divide ratio to get the proper frequency.