Import Word doc into an Access report

  • Thread starter Thread starter Ojoy
  • Start date Start date
O

Ojoy

I have a database that has products in one table and their options in
another. They both have associated pictures and advertising text so I have a
field that stores a path to the picture file and a path to the word doc where
the advertising text is located.

I am trying to create a report that allows me to select a product(s) and any
options that I want to include and then prints them in a formated layout with
the picture followed by the ProductName or OptionName and then the
advertising text from the Word doc. The reason I am want to use a word doc is
that the text is formatted into lists with bullets on the left of each item.
Is this even doable in Access? I've been pulling my hair out for a week
trying to get it to work.
 
The reason I am want to use a word doc is that the text is formatted into
lists with bullets on the left of each item.
You can have bullets in Access by adding the character to your list like
this --
Chr(149) & " " & [YourListField]
 
That's good to know but I would still like to be able to use the Word doc.
When the manufacturer emails their new sales info it's in a word doc and it
would be a lot easier if I can just replace the old one with the new one and
not have to enter everything into a database.

KARL DEWEY said:
lists with bullets on the left of each item.
You can have bullets in Access by adding the character to your list like
this --
Chr(149) & " " & [YourListField]

--
KARL DEWEY
Build a little - Test a little


Ojoy said:
I have a database that has products in one table and their options in
another. They both have associated pictures and advertising text so I have a
field that stores a path to the picture file and a path to the word doc where
the advertising text is located.

I am trying to create a report that allows me to select a product(s) and any
options that I want to include and then prints them in a formated layout with
the picture followed by the ProductName or OptionName and then the
advertising text from the Word doc. The reason I am want to use a word doc is
that the text is formatted into lists with bullets on the left of each item.
Is this even doable in Access? I've been pulling my hair out for a week
trying to get it to work.
Click to expand...
Click to expand...
 
See if this is of any help --
I use Access database with Word mail merge. Data is loaded
in Access and pulled out using a query to select what you want and the Word
document.

Word Mail-Merge--- Open a blank Word document, click on menu TOOLS -
Letters and Mailings - Mail Merge. It opens an additional window on the
right and has step-by-step instructions and choices. You can also backup in
the process. Works fine for me.

--
KARL DEWEY
Build a little - Test a little


Ojoy said:
That's good to know but I would still like to be able to use the Word doc.
When the manufacturer emails their new sales info it's in a word doc and it
would be a lot easier if I can just replace the old one with the new one and
not have to enter everything into a database.

KARL DEWEY said:
The reason I am want to use a word doc is that the text is formatted into
Click to expand...
lists with bullets on the left of each item.
You can have bullets in Access by adding the character to your list like
this --
Chr(149) & " " & [YourListField]

--
KARL DEWEY
Build a little - Test a little


Ojoy said:
I have a database that has products in one table and their options in
another. They both have associated pictures and advertising text so I have a
field that stores a path to the picture file and a path to the word doc where
the advertising text is located.

I am trying to create a report that allows me to select a product(s) and any
options that I want to include and then prints them in a formated layout with
the picture followed by the ProductName or OptionName and then the
advertising text from the Word doc. The reason I am want to use a word doc is
that the text is formatted into lists with bullets on the left of each item.
Is this even doable in Access? I've been pulling my hair out for a week
trying to get it to work.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top