Do the planets have any affect on the tides?

Negligible. The effect of Venus is 0.0054% that of the Moon. For most places this corresponds to an effect of less than 0.1mm so in reality we don’t worry too much about it.