Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Export data in a textbox on a form in Access to a word document

Posted on 2008-10-28
6
273 Views
Last Modified: 2010-04-21
I have text data in a memo field that is displayed for a record.  I need the ability to export the text data in the textbox on the form to a word document.  I have seen other postings but mostly to merge or dump from a table.
0
Comment
Question by:avalonwgi
  • 4
  • 2
6 Comments
 

Author Comment

by:avalonwgi
ID: 22825531
Could someone please respond to this?  It is important for me to continue with what I am working on and it has been 4 hours since my post.  Thanks for your help!
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 22828659
You can merge into a word template using bookmarks in Word. Memo data sometimes truncates (will do so if emporting from a query, but work OK if exporting from a table) and I'm not sure what would happen from a form.

Essentially, you have a word template that you open using a background instance of Word, export the text to a bookmark that exists in the correct location on the template then save this as a doc file to a location & filename that you specify..

Is this what you're looking for?


Kelvin
0
 

Author Comment

by:avalonwgi
ID: 22831183
Kelvinsparks,
That's not what I was hoping for.  I was hoping that this was similar to just exporting to excel.  I don't want to early bind, but I would like to late bind word application and then just dump the text to a new and empty word doc.  Is that possible and if so, how? (inlcuding the binding)
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 22

Accepted Solution

by:
Kelvin Sparks earned 500 total points
ID: 22835536
Ok

You can export a form to word (have to use rtf format. It doesn't look pretty but a line like this will work

DoCmd.OutputTo acOutputForm, "frmTest", acFormatRTF, , True

You could use a variation on that and  write the data to a temp table & then export that table would need an extra 3 or 4 lines of code plus a variation of the one above.

Kelvin
0
 

Author Comment

by:avalonwgi
ID: 22837267
So I can export the data, but it exports all field data on the form and not the specific fields that i want exported.  Is there a way to do this and just as text?
0
 

Author Closing Comment

by:avalonwgi
ID: 31510803
I got it to work with some minor changes.  Thanks
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question