To spray or not to spray

I have a seven-year-old Cavalier who keeps barking whenever he goes into the garden because there is a horse on one side of the garden and cattle on the other side – both groups of animals often come up quite close and my Cav starts barking when he sees them.

I am thinking about using a spray collar or some sort of vibrating collar and would like some opinions on them and how effective they are. I don’t know what else to

do and do want to stop my neighbours complaining about the dog!

Maggie, Isle of Wight, by phone

Barking mad

I have two dogs, one Parson Jack Russel who is five and one 11 month old Yorkshire Terrier cross, the problem is with the Parson Jack Russel, she is well behaved when in the house, but when we take her out and she sees another dog, she just won't stop barking, even when she goes up to the other dog and meets him/her, she will bark really loudly in their face, the Yorkshire Terrier cross is well behaved out, she loves meeting other dogs but has started picking up bad habits from my Parson Terrier and tries copying her when she barks at other dogs, any advice please on how to cure this embarrassing and very annoying behaviour, so that it can be more enjoyable when going out.
Emma Rich, by email

Can anyone suggest anything to help Emma?