In my vba code I use my application's address repeatedly. Unfortunately, when I move it or make it an .mde that code fails. I have MOSTLY fixed this problem. Now my application has a global variable for the address. So when I change the application's location, I just change that value.
My question is, can I TOTALLY eliminate this problem? Can I call a method that returns the path of the current db? I looked at all of the Environ() collection, and I did not find anything.
My question is, can I TOTALLY eliminate this problem? Can I call a method that returns the path of the current db? I looked at all of the Environ() collection, and I did not find anything.