Argh! I had this same problem last night, and nothing I tried then fixed it. Since there seems to be a lot of different threads on this subject, let me post what I did this morning that got it working for me. Hopefully it will help others.
Vehicle: 2007 Chevy Colororado, Z71, extended cab, 68K miles
I actually disconnected my battery on purpose - because we've got colder weather coming, and I wanted to check it's date and add any water if needed. And to even check the date on a Colly battery you've gotta disconnect it, because of how the battery cables run over the box it's in.
Anyhow, turns out my battery was fine, but when I reconnected it the driver's side window would not go up or down, and the power locks would not work. Pressing either button on the key fob would flash the headlights, and you could hear a relay under the hood clicking, but nothing on the locks. No response when pushing the door button lock inside the cab.
I've only had this car for 5K miles, but it seems to be in very good condition. Very clean, no signs the doors have ever been taken apart. It was cold out last night when I was doing this. 28 degrees. I tried disconnecting both the cables, touching them together, putting them back on, various "jiggling", checking a bunch of fuses, etc., no luck.
I left it overnight with the negative cable disconnected. This morning I took off the positive cable and touched them both together for 30 seconds, then *firmly* put the positive and negative cables on (no jiggling, just a good firm push), and voilà - the locks & window work! It was also 41 degrees this morning, which may have helped?
- not sure if it was the sequence I did things at, the fact that it was above freezing when I re-connected the cables, or just the passage of time that it "healed itself", but it seems like if the problem is strictly related to a battery being disconnected, and not the switch panel in the door, it can be resolved easily. Good luck!