I certainly understand your situation and have tried all kinds of things when we have company.
Last night we had all adults, so I had the three girls upstairs in a bedroom, then let them out slowly and they were fine.
But, for whatever reason, some of our nieces and nephews just set off one or more of the dogs. I do try to teach them to ignore the dogs and let them smell, but don't touch. I have also put dogs on a leash. Also, we have had children leave dirty plates on a coffee table in the basement within reach, so really have to watch that too.
It is difficult, but to me my dogs' safety is first. So, our company might have to put up with barking and crying, even if it is embarrassing to my DH. Or, go somewhere else for a gathering.