Recent content by bini

Thanks guys. The reason for the terrible task is because I am converting the backend to mysql to have a webbased applicated. But I can't build the webbased app in a day so I am going to have to keep the access databse going for a while. The spaces in the fields in mysql have caused me so many...

Is there a way to rename the fields in queries using vba. I am using the code below but get the error "Can't assign to read only property." at the point that I have highlighted. The reason that I need to do this is because I am renaming all the fields in the tables to eliminate white spaces...