Help or Suggestions on how to change path

[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.

[Phil Stanton]

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.