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 :(

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 relay is integral to the bcm.

This is because your master switch on the drivers door may have corroded oxidation on the contacts inside the switch and that master switch is the feed for all inside door lock switches your remote and keypad work because those electrical signals go through the driver door module you must clean all contacts on the master switch get them shiny you can use 4/0 steel wool and alcohol and also take the lock switch apart and clean the button contacts inside the switch for this use alcohol and 1000 grit sandpaper glued to a pencil and lightly spin in your fingers to shine the contacts sometimes just an eraser works but it depends on the quality of it so go with the sandpaper glued to the pencil or any circular object that will fit inside after this blow out the switch and use the alcohol to clean out and let dry

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.

Does the switch inside for that door work ? Does the power window work for that door ? Check fuse DDM - 15 amp I/P fuse panel . Do you know where the insturment panel fuse box is located ?
Fuse Block - I/P
Left of the I/P behind the side trim panel
# 4
DDM Fuse
15A
Driver Door Module (DDM)

Do you know anything about automotive electronic's , control module's ? Serial data communication networks ?
Circuit/System Description
The driver and passenger door lock and side window switches are integrated control module switch assemblies. The DDS and PDS door lock switches are normally open, 2 position rocker type switches, with detents for lock and unlock. The DDS and PDS are directly connected to the respective door lock actuator through the door lock actuator control circuits. When a door lock or unlock function is activated from the DDS or PDS, a serial data message lock or unlock command is sent to the other door switch and body control module.

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.