A few days ago I got some help creating a string so that a database would get its own residing directory to look for a word document I wanted to merge.
It worked beautifully..... until I needed to move the entire content of the directory to another PC.
The Access part still works perfectly - it works out where the word document is (in the same folder as it!!) BUT, the word document then says "C:\\server\...." etc etc is not a valid path as the folder no longer resides on the server...
Is there any way in the code in access to pass the path and table info to the word document to prevent this? am I barking up the wrong tree?
maybe I'm just going barking mad from trying to learn this stuff
It worked beautifully..... until I needed to move the entire content of the directory to another PC.
The Access part still works perfectly - it works out where the word document is (in the same folder as it!!) BUT, the word document then says "C:\\server\...." etc etc is not a valid path as the folder no longer resides on the server...
Is there any way in the code in access to pass the path and table info to the word document to prevent this? am I barking up the wrong tree?
maybe I'm just going barking mad from trying to learn this stuff
