Search results

when I am trying to declare some strings in my code it would appear the access doesnt seem to like my last declared string. I have to add a unused string at the end before it will move on. This only seems to happen if I set the last string to nothing. heres a basic module for you to replicate...

I have to rename a table in my code so I can do some comparing. anyway If I run my code manually (or by running a macro that calls the code) everything works as it should. BUT if I call the macro from a batch file the docmd.rename part doesnt run. the rest of the code does. heres a simple way...