 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / April 2008Import Word doc into an Access report
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]  SignatureKARL DEWEY Build a little - Test a little > 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 [quoted text clipped - 8 lines] > Is this even doable in Access? I've been pulling my hair out for a week > trying to get it to work. 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. > >>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. [quoted text clipped - 14 lines] > > Is this even doable in Access? I've been pulling my hair out for a week > > trying to get it to work. 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. SignatureKARL DEWEY Build a little - Test a little > 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 [quoted text clipped - 19 lines] > > > Is this even doable in Access? I've been pulling my hair out for a week > > > trying to get it to work. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.