Does anyone look at these forums?
I had to write the code per Sub to get it to work. I do not like doing it this way and should be a better way.
I removed the Option Explicit and made a MySQL Module with read and write functions and it works fine now.