The overhead light on the driver's side has stopped working. Also, the rear light only works when a door is open; it can't be turned on manually. This is not really a bother; the front light is more important, but I thought the two problems might be related. I haven't tried to fix it. Any info would be much appreciated.

F5 5 Rear window motor. Roof opening panel module. Auto-dimming interior mirror unit. Door lock switch, driver side. Door lock switch passenger side. Power window motor, driver side front. Overhead console switch assembly
Not sure if this is what you're looking for. Let me know if it works.

The first thing that comes to mind is that the dash lights scroll dimmer is scrolled all the way in one direction which manually shuts off all the interior lights, even if a door is opened. At night turn on the parking lamps and then scroll the dash lights dimmer until the dash, radio face, overhead console, etc is brighter. Turn off the headlamp switch. Shut off the engine and exit the vehicle. Interior lights on? Hope this helps.

Page 116 and 117 of the manual explain that there's a two-position slide switch on the map light, DOOR and OFF. The back light has three positions, ON, Door Activated, and OFF.

Pages 116 and 117:
http://techinfo.honda.com/rjanisis/pubs/om/ACC080/ACC0808OM.pdf

take it to a body shop

Instrument Panel Fuse Block
The instrument panel fuse block access door is
located on the driver side edge of the instrument panel.

Pull off the cover to access the fuse block.

The vehicle may not use all of the fuses shown.

Fuses Usage
1 Rear Seats
2 Rear Accessory Power Outlet
3 Steering Wheel Controls Back light
4 Driver Door Module
5 Dome Lamps, Driver Side Turn Signal
6 Driver Side Turn Signal, Stop lamp
7 Instrument Panel Back Lighting
8 Passenger Side Turn Signal, Stop lamp
9 Passenger Door Module, Driver Unlock
10 Power Door Lock 2 (Unlock Feature)
11 Power Door Lock 2 (Lock Feature)
12 Stop lamps, Centre High Mounted Stop lamp
13 Rear Climate Controls
14 Power Mirror
15 Body Control Module (BCM)
16 Accessory Power Outlets
17 Interior Lamps
18 Power Door Lock 1 (Unlock Feature)
19 Rear Seat Entertainment
20 Ultrasonic Rear Parking Assist, Power Liftgate
21 Power Door Lock 1 (Lock Feature)
22 Driver Information Centre (DIC)
23 Rear Wiper
24 Cooled Seats
25 Driver Seat Module, Remote Key less Entry System
26 Driver Power Door Lock (Unlock Feature)

The proper way would be to look at a wiring diagram an test the electrical circuit's with a DVOM - digital volt ohm meter . Do you know how to test automotive electrical circuit's ?
Electric Testing Techniques You Need to Know
The Trainer 32 How To Read An Automotive Block Wiring Diagram
Free wiring diagrams here http://www.bbbind.com/free_tsb.html
Enter the vehicle info. year , make model and engine size . Under system click on body & accessories ,then under subsystem click on power sliding door . Click the search button then the blue link. Looking at the diagram you will see a control module is used .
Also reading factory service info. on how it works would be a good idea.

Rear Side Door Actuator Control Module
The rear side door actuator control module is capable of on-board diagnostic functions described in On-Board Diagnostic Features . The rear side door actuator control module monitors the door position at all times including during manual operation. After activating the on-board diagnostic modes, loosing battery voltage, or ground to the rear side door actuator control module the Power Sliding Door (PSD) Re-Initialization procedure must be performed in order for the rear side door actuator control module to correctly determine the door position.
Power Sliding Door System Description
The power sliding door system(s) can operate correctly only if the power sliding door is in proper mechanical condition. Any mechanical problems will affect the power sliding door operation and must be repaired before attempting to diagnose the power sliding door system. Manually open and close the power sliding door to determine if the door moves smoothly and without excessive resistance or binding. The power sliding door must also latch and unlatch without the use of excessive force. At any time during power sliding door open or close operation, excessive resistance to the door movement will cause the power sliding door to stop and reverse the direction of travel.
The power sliding door will operate only when the power sliding door on/off switch in the overhead console is in the on position. At anytime during power sliding door operation the on/off switch may be turned to the off position and the system will quit any function in process. The power sliding door will not open unless the transmission shift lever is in the park position and the door is unlocked. When the sliding door security lock is in the locked position the power sliding door will not open from the inside. The power sliding door close function will operate when the vehicle is in gear. The power sliding door module uses the VSS signal to determine if the vehicle is moving during a power sliding door close function. The momentum of the vehicle moving forward adds resistance to the door closing operation. When the rear side door actuator control module determines the vehicle is moving forward while closing the door, current flow through the actuator motor is increased instead of being reversed. The VSS signal circuit is supplied battery positive voltage through a resistor then monitored within the rear side door actuator control module. The VSS signal circuit is then pulsed to ground, or pulled low by the powertrain control module in relation to vehicle speed. The sliding door alarm will sound repeated short tones whenever the power sliding door system is turned on and the door is open while the transmission is out of park.
When the power sliding door system is on and manual operation of the power sliding door is detected the rear side door actuator control module activates the power assist feature. When the power assist is activated the power sliding door will continue to open or close without any further manual effort.
The power sliding doors may be operated using the Remote Keyless Entry System. The keyless entry transmitter will have one OPEN/CLOSE button with a van symbol on it for each power sliding door. The power sliding door ON/OFF switches in the overhead console must be in the ON position in order to operate the power sliding doors using the keyless entry transmitter. When a right hand power sliding door OPEN/CLOSE function is activated using a keyless entry transmitter the exterior lights will flash once indicating the RKE module has received the OPEN/CLOSE command. When activating a left hand power sliding door OPEN/CLOSE function with the keyless entry transmitter the exterior lights will not flash.

On-Board Diagnostic Features
The left and right power sliding door systems operate as independent systems. The on-board diagnostic modes are entered and operate the same in both systems.
The power sliding door systems are capable of the following on-board diagnostic functions:
• Diagnostic Mode 1: An audible signal indicates the diagnostic trouble codes stored by the rear side door actuator control module.
• Diagnostic Mode 2: An audible signal indicates when inputs to the rear side door actuator control module are active.
• Diagnostic Mode 3: Performs an output test of the sliding door unlatch actuator.
Entering On-Board Diagnostics
The on-board diagnostic modes can only be entered in a sequential order from modes 1-3.
• Enter the right power sliding door system on-board diagnostics using the right B-pillar open/close switch and the right on/off switch in the overhead console.
• Enter the left power sliding door system on-board diagnostics using the left B-pillar open/close switch and the left on/off switch in the overhead console.
1. Both power sliding doors must be closed and in the latched position.
2. Place the ignition switch in the OFF position.
3. Place the on/off switch in the overhead console to the OFF position.
4. Press and hold the B-pillar power sliding door open/close switch.
5. While holding the open/close switch, operate the on/off switch through 10 ON and OFF cycles within 10 seconds stopping in the on position.
6. The sliding door alarm will sound 1 long tone indicating diagnostic mode 1 is active.
Diagnostic Mode 1
Upon activating diagnostic mode 1, DTCs will begin to be signaled by the sliding door alarm. The DTCs are 2 digit codes and the codes are represented by the number of buzzes for each digit of the code number. For example a DTC 12 is represented with the following sequence: buzz, pause, buzz, buzz, long pause. Each DTC will be signaled 3 times before proceeding to the next DTC. Refer to Diagnostic Trouble Code (DTC) List . The DTCs will continue to be repeated in this manner until the on-board diagnostics are exited or mode 2 is entered. When exiting the on-board diagnostics all stored DTCs will be erased from the rear side door actuator control module memory.

try removing panel and check for loose or worn contacts, or replace the panel cluster with a new unit or one from a junked unit in good condition if cost is a factor

There is a electric contact in the door to turn on the dome light when open and off when closed. It sounds like that switch is bad or the wire attached to it has fallen off behind the doorsill. It may be another door though, since all work the dome light. Try opening the other doors one by one to see if they light up the dome. Theres no guarantee because the seat or seatbelt may come into effect.

get you some wd 40 and spray those buttons on the housings, thats the area where your door fits when shut, but you have to have your doors open to spray those little buttens, spray it push the butten in untill all the dust is gone.