A
Andy
Hi;
Used Access 2K to create a database to track employees a few years ago.
Put the following in a Word Doc:
{IncludePicture "C:\\OurDBase\\Pics\\{MERGEFIELD "EmpNumber"}{MERGEFIELD
"EmpFirstName"}{MERGEFIELD "EmpLastName"}.jpg} and then used ALT-F9 to hide
the code.
It worked great for years.
Bring up the Employee on screen in Access, click a cmdButton Word opened and
that Employee's picture and info were displayed correctly in Word.
It worked great until last week.
Last week one of the bosses asked me to add a Field to the Word Document.
Everything went smooth.
Then noticed that the same picture was appearing for all the employees.
Also discovered that the "IncludePicture" string changed from:
{IncludePicture "C:\\OurDBase\\Pics\\{MERGEFIELD "EmpNumber"}{MERGEFIELD
"EmpFirstName"}{MERGEFIELD "EmpLastName"}.jpg}
TO:
{IncludePicture "C:\\OurDBase\\Pics\\{MERGEFIELD "1"}{MERGEFIELD
"John"}{MERGEFIELD "Smith"}.jpg}
The number and name of the Employee that was displayed when the Document
first Merged.
Used a backup copy of the Document. Added the new Field again, displayed the
IncludePicture string ALT-F9, hit the Save button and watched the string
change to {MERGEFIELD "1"}{MERGEFIELD "John"}{MERGEFIELD "Smith"}.
Tried it again. This time hiding the IncludePicture string. Saved it then
re-displayed the string. Same thing: "1JohnSmith".
Thought that it might be Access. Displayed a different Employee. Added the
Field in Word, Saved and the Employees Number and Name diplayed in Access
was displayed in the IncludePicture string in Word.
So its isolated to the Word Document.
Could someone point me in the right direction to overcome this snag? Why is
the IncludePicture string changing and how is it stopped?
Thank You for taking the time to read this post.
Andy
Used Access 2K to create a database to track employees a few years ago.
Put the following in a Word Doc:
{IncludePicture "C:\\OurDBase\\Pics\\{MERGEFIELD "EmpNumber"}{MERGEFIELD
"EmpFirstName"}{MERGEFIELD "EmpLastName"}.jpg} and then used ALT-F9 to hide
the code.
It worked great for years.
Bring up the Employee on screen in Access, click a cmdButton Word opened and
that Employee's picture and info were displayed correctly in Word.
It worked great until last week.
Last week one of the bosses asked me to add a Field to the Word Document.
Everything went smooth.
Then noticed that the same picture was appearing for all the employees.
Also discovered that the "IncludePicture" string changed from:
{IncludePicture "C:\\OurDBase\\Pics\\{MERGEFIELD "EmpNumber"}{MERGEFIELD
"EmpFirstName"}{MERGEFIELD "EmpLastName"}.jpg}
TO:
{IncludePicture "C:\\OurDBase\\Pics\\{MERGEFIELD "1"}{MERGEFIELD
"John"}{MERGEFIELD "Smith"}.jpg}
The number and name of the Employee that was displayed when the Document
first Merged.
Used a backup copy of the Document. Added the new Field again, displayed the
IncludePicture string ALT-F9, hit the Save button and watched the string
change to {MERGEFIELD "1"}{MERGEFIELD "John"}{MERGEFIELD "Smith"}.
Tried it again. This time hiding the IncludePicture string. Saved it then
re-displayed the string. Same thing: "1JohnSmith".
Thought that it might be Access. Displayed a different Employee. Added the
Field in Word, Saved and the Employees Number and Name diplayed in Access
was displayed in the IncludePicture string in Word.
So its isolated to the Word Document.
Could someone point me in the right direction to overcome this snag? Why is
the IncludePicture string changing and how is it stopped?
Thank You for taking the time to read this post.
Andy