By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,489 Members | 1,954 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,489 IT Pros & Developers. It's quick & easy.

Help or Suggestions on how to change path

P: n/a
jpr
Hello,

I have almost ultimate my database which works with forms that export
their data to word documents.

The code behind the forms indicates that path to which it will find the
word documents.

As I will be sharing my program with several offices, I will need that
each Office will have to change the path based on their server name.

Examples of path: \\ABC123\shared\templates\mydoc.dot

Is there a way each office or better on person which will be the
database administrator can change the ABC123 in all forms without
having to open each one in design view and manually make the change?

I was thinking of some kind of text box where to write the path and a
cmd that will do it for us.

Appreciate any help. Thanks.

Sep 6 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
I tend to have a table with company information and path informtion calles
"TblPaths". It holds such things as a default path to photos associated with
that particular database, DatePath (where the back end DB is held) etc. So
you could have a paths table including WordPath and use DLookup("WordPath",
"TblPaths") or better still if you have the ELookup function, use that.
Assuming you are running the front end DB on a number of computers, and the
Back end on a server, you need to keep the TblPaths with the back end

HTH

Phil
"jpr" <jp***@tin.itwrote in message
news:11*********************@p79g2000cwp.googlegro ups.com...
Hello,

I have almost ultimate my database which works with forms that export
their data to word documents.

The code behind the forms indicates that path to which it will find the
word documents.

As I will be sharing my program with several offices, I will need that
each Office will have to change the path based on their server name.

Examples of path: \\ABC123\shared\templates\mydoc.dot

Is there a way each office or better on person which will be the
database administrator can change the ABC123 in all forms without
having to open each one in design view and manually make the change?

I was thinking of some kind of text box where to write the path and a
cmd that will do it for us.

Appreciate any help. Thanks.

Sep 6 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.