Agree re bird and bat houses. It's a longer term solution that is not going to fix anything right now. It takes a good while for bats to take up residence in your bat house (they don't like human smell on it, so it has to weather a bit). But once they do, they are voracious insect eaters.
Growing your squash/cucumber under row cover keeps the JB's and the cucumber beetles and everyone else off it. But if you leave the row cover on, then you have to hand pollinate the flowers, because bees can't get to them either.
If you are starting to have big populations of beetles, you can just go over the plants with a vacuum cleaner (maybe hand held like dust buster) and suck them up.
The pyrethrins are effective against them. You can minimize (which isn't necessarily the same as eliminate) the effect on honeybees by spraying very late (after dusk) or very early (before dawn). Also the beetles congregate on the leaves. If you can spray the leaves, including undersides, and as much as possible avoid spraying the flowers, it's better for the bees. (Spraying late or early helps with that too, since the flowers aren't open).
Other possibilities: Neem oil, kaolin clay, garlic pepper spray (type that into search the forum for recipes)