Driver door lock sometimes works and sometimes does not work when using the remote. Always works when using the switch on the doors... Moon roof does not work. How do I get the consol down to replace the switch?

no you needs a new lock actuator on that door its about $90 installed,
all the locks are on same circuit . sorry about the bad news :(

What door lock doesn't always work ? One or all of them . This is a complex set up for these door locks ! The switch is an input to the BCM - body control module . There is logic involved in the microprocessor , there are relays built in to the BCM ! Could have a DTC - diagnostic trouble code stored in the BCM ! Could be a bad connection at the BCM or master window switch ! A bad ground !
The power door lock system consists of the following components:
?€¢
Body control module (BCM)

?€¢
DOOR LKS fuse

?€¢
Driver door lock actuator

?€¢
Driver door lock switch

?€¢
GMLAN serial data link

?€¢
Keyless entry transmitter

?€¢
Passenger door lock actuator

?€¢
Passenger door lock switch

?€¢
Remote control door lock receiver (RCDLR)

The DR LCK fuse supplies battery voltage to the body control module (BCM) for the power door lock system. The BCM supplies and monitors a reference voltage to the driver and passenger door lock switches through the door lock switch lock/unlock signal circuit. Each door lock switch receives ground at G300 which is also the ground for the door lock and unlock relays located in the BCM. When a door lock switch is placed in the lock position, the reference voltage is switched to ground and the BCM senses 0.0 volts on the door lock/unlock signal circuit. When a door lock switch is placed in the unlock position, the reference voltage is switched to ground through a 1.5k ohm resistor that is internal to each of the door lock switches and the BCM senses approximately 2.9 volts on the door lock/unlock signal circuit. The BCM interprets what position the activated door lock switch was placed in based on the voltage drop.
The BCM, upon receipt of a lock or unlock switch signal, will switch the appropriate door lock/unlock relay coil control circuit to ground causing the appropriate door lock/unlock relay to energize. With the relay energized, voltage is applied to the door lock actuator control circuit causing the door to either lock, or unlock depending on what command was received from the power door lock switch or remote control door lock receiver (RCDLR). When a power door lock/unlock relay is not energized, the switch contacts are normally grounded through the BCM which provides ground to the appropriate door lock actuator for the lock/unlock function being performed. The power door lock/unlock functions are performed by reversing the flow of voltage through the door lock actuator control circuits. The BCM has three internal drivers for the power door lock system. Driver door unlock, passenger door unlock and all door lock. This is done to isolate the driver door lock actuator so it can be unlocked separately from the passenger door. For additional information concerning keyless entry, refer to Keyless Entry System Description and Operation.
This is one you may want to take to dealer or some other ASE certified repair shop ! To do this right you need a Tech 2 scan tool !
Ignition ON, observe the scan tool Door Lock Switch parameter while using the driver and passenger door lock switches. The parameter should change from Idle to Lock and Unlock.
?‡'
If the value does not change, refer to Door Lock Switch Malfunction.

Command the doors to LOCK and UNLOCK with the scan tool, the door lock actuators should LOCK and UNLOCK when changing between the commanded states.
?‡'
If one or more doors do not LOCK or UNLOCK, refer to Door Lock Malfunction.

Are the switches located near each other? Plug may have come off or on some models with console switches things get spilled in them???

The radio not turning off when you turn off your vehicle could have something to do with your ignition switch, and the accessory position on the ignition switch itself. On older vehicles, this becomes worn out, and a little sloppy. This in turn causes the ignition switch to provide power to the accessories even when it should not. It's a far shot in the dark, but It's a possibility.

This is a wild guess, but it sounds like the switch that controls the door is constantly trying to open the door. It could be the door switch. Try locking the door with the door switch and then hold the lock slightly down to see if it is a mechanical failure in the switch. If not, the remote system may be sending the unlock. You could always pull the fuse for the automatic locks and see if the key will lock/unlock without problem. But then you'd never have remote entry.

look inside the rubber boot between the door and the body wire break inside from opening and closing the door

Replace the driver side door actuator.

Sounds like your remote reciever unit has gone bad.

Well there are more wires behind the radio which may have been unhooked while pulling out your old radio. If you cut any wires and left bare wire exposed its a possibility it could have touched and blew a fuse.

The door lock motor is most likely starting to go out, they start by sticking like yours.