Can apply for some type of a ride a few times a week to a local dinner or even the CVS to pick up his pills?

As an RN who provides care in the home I would have thought that you should be the one most likely to know the agencies and services available in your community. What do your other clients do? What does the agency that you work for recommend? I know that the agency that provides aides for my mother also has accessible transportation available as well as volunteer drivers for outings and appointments, but each community will be different.

Does he have mobility issues? If not, then what about Uber? I wonder if their rates would be less than the transport by a professional agency. 

He might also check with a local church or one that he may attend.  I know that some of the retired people at my parent's church volunteer to take seniors or the disabled to doctor appointments, lunch, pharmacy, etc.  They are free all day and love getting out to socialize and help others.  They don't charge anything either. 

In my area, there is a public transit for seniors and the disabled. They have a very small fee, but, you have to sign up early and could be kept out for most of the day due to their schedules. They advise you pack a lunch, because depending on which part of the county they have to go after they drop you off, you could end up waiting at your destination for many hours. To me, that's not practical for seniors and the disabled who tire easily, need to get home to bathrooms, take meds etc. but, it's almost free, so many have no other choice.

Is there an access a ride program there for seniors? I would check with him joining a senior citizens center. They have lots of resources and may have a pick up service to get him daily. If anything the soccial worker there can give options and referrals.

My parents recently started using an caregiver agency for driving. If the agency drives my parents car they pay the hourly fee (with a minimum of 2 hours). If they have to use the company car it is hourly fee plus mileage. The agency can be called up to a day in advance. It is a little more expensive than calling the senior program (which as freqflyer mentioned) you have to make a reservation. In our area, you need to call a month in advance.

When my Dad had professional caregivers at his home, they would drive him to run errands.  Dad would need to pay for their mileage at the end of the month through the Agency.

Otherwise, have your client call the county Agency on Aging to see what programs are available for transportation.   Some areas have small buses that will come to the house to pick an elder up, this has to be made by reservation.