How do you fix the path for a macro?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having trouble with my paths working. They use to work but we changed
the computer server around and now the paths will not connect to the word
documents.
 
Michael,

Are you referring to macros within Microsoft Access? If so, can you
give examples of what actions are in the macros, and further details of
what is happening (or not happening)? Thanks.
 
Steve,

Yes I am referring to the macros within Microsoft Access.
Our company had the program running fine and then took out the computer the
was supporting our data and moved the data to another computer.
This was the old path they used: \\ds5\ds5\Program Files\Microsoft
Office\Office\winword.exe \\ds5\ds5\database\labels6.doc
\\ds5\ds5 is the computer name.
Now the data is on the network \\Ds9\DataBase
I am trying to reconnect the database to Microsoft Word where our forms have
been created.
 
Sorry to be so thick here, Michael. I still can't grasp what this is
all about. You mentioned macros, but I have no idea what these macros
might be, or what they are for. Can you give details or examples of
what actiosn are in the macros? Can you also please say what use is
made in your database of the reference to Word and the path to the Word
document? Thanks. I mean, I understand the meaning of
"\\ds5\ds5\Program Files\Microsoft Office\Office\winword.exe
\\ds5\ds5\database\labels6.doc", but... where does it fit in and where
is it used and what does it do?
 
Its okay, just trying to figure it out myself. The database in Access that
we have made has all our customers info. The macros that we have are RunApp
types that go from access to word with all the info that are in the tabels in
access to the fields in word where our forms are.
For Example:
We fill out all the customers info in our "New Job Form"
then say we want a Transmittal Form. Well it use to work where we click on
the Transmittal button and it would open up the form in Word with all the
cutomers info.
The path to the Word Document where the forms are saved is
for example: \\DS9\Database\trans.doc
 
Michael,

So, unless I am missing something here, isn't it simply a matter of
editing the Command Line argument of the RunApp macro actions to
indicate the new path?

Mind you, I think there should be ""s in the command line example you
posted, like this...
"\\ds5\ds5\Program Files\Microsoft Office\Office\winword.exe"
"\\ds9\database\labels6.doc"
 
Back
Top