Access form and MS Word Doc

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

Guest

What I have is an access form that is used for data entry purposes. It is
basically a survey form, it has Contact information at the top and a series
of questions below. It was designed exactly like the hard copy form the reps
use to fill in the information by hand, which is then data enterd on the
access form. I need to be able to export this information on to a word
document...just as it appears on the hard copy and the access form...question
and answer. In following the instructions on exporting to word what I end up
with is a "spread sheet" with the data...not what I need:( . It does not
need to be a functional form in the word document, only a copy of it.
Someone had advised I create a template in word then export it to the
template???? I have no idea how this works. Any help will be greatly
appreciated. TY...Veronica
 
I will suggest to you, open your access program and goto your table object,
then select the table where your information is, look at the toolbar for
word icon(blue) or word symbol,then click publish to word.
 
What I have is an access form that is used for data entry purposes. It is
basically a survey form, it has Contact information at the top and a series
of questions below. It was designed exactly like the hard copy form the reps
use to fill in the information by hand, which is then data enterd on the
access form. I need to be able to export this information on to a word
document...just as it appears on the hard copy and the access form...question
and answer. In following the instructions on exporting to word what I end up
with is a "spread sheet" with the data...not what I need:( . It does not
need to be a functional form in the word document, only a copy of it.
Someone had advised I create a template in word then export it to the
template???? I have no idea how this works. Any help will be greatly
appreciated. TY...Veronica
Click to expand...

If I understand your question, you wish to send your form, as a form,
with all of it's bells and whistles, to Word.
You can't.
Access will send the data, not the actual picture/layout format of the
form.
Why do you need to send it to Word?
Right-click on the form (on the main database folder).
Select Save as Report.
Print the report (in Access).
If you wish to print out just one record, (as opposed to all of them),
don't forget to filter the OpenReport as needed.
 
Hi Veronica,

There are basically three-and-a-half ways to do.

1) Set up a Word mailmerge document to match your form, and then merge a
single record to that. This is easy if you have a simple form, but less
so if your form is in continuous view with an indefinite number of
questions below the header. THe following links should help.

Albert Kallal's sample mailmerge application:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

Q209976 ACC2000: Using Automation to Run Word Mail Merge from Access
http://support.microsoft.com/?kbid=209976

Q209882 ACC2000: Using Automation to Create a Word 2000 Merge Document
http://support.microsoft.com/?kbid=209882

http://word.mvps.org/faqs/MailMerge/index.htm

2) If the form is more complicated, and you want a Word document that
(a) preserves the layout of the form and (b) is a well-structured
document rather than one where the layout is achieved by a mess of tabs
and fonts and lines, you need to create a Word template to match the
form and then write VBA code that fires up Word, creates a new document
from the template, and puts the data from the Access form into the right
bookmarks or formfields. The following links should help:

ACC: Sending the Current Record to Word with Automation
http://support.microsoft.com/?id=131583 (Word 97)
http://support.microsoft.com/?id=209976 (Word 200& later)
http://www.mvps.org/access/modules/mdl0043.htm
Opening a new Word document based on a template through Automation

http://word.mvps.org/faqs/interdev/GetDataFromDB.htm

http://support.microsoft.com/?id=159328
and
http://support.microsoft.com/?id=209882
http://support.microsoft.com/?id=170988

3) If on the other hand you want the layout but don't care about the
structure, start by making a copy of your Access form and saving it as a
report. Then fiddle with it until it looks right in Preview mode, and
try Tools|Office Links|Publish with MS Word.

If you're lucky, you'll now have a suitable Word document. If not, (3.5)
go to http://www.lebans.com/ReportUtilities.htm and try the code there,
which does a better job with layout and graphics.
 
Hi John,

Thanks for your help. I used your last suggestion because it seemed to be
the least complicated(I took the easy way out) Anyway it did work in the
manner I needed, however....there always seems to be a but??? when I preview
it in either access report or the word doc. the margins are all messed up. I
really don't want a margin at all hence is where the problem lies...I think.
I have messed around with the different margin settings and have gotten close
"but" and for example when I puplish it gives me 4 seperate forms, this is ok
because those are the 4 records I need. when I scroll down the data tabs down
with every page. There are no headers or footers on the form only Titles and
of couse titles and text boxes for the Q & A's. The first page looks fine,
the second page starts about an inch below where the first page started and
half of that page is on the next and so on . Any ideas????
 
Veronica,

You don't say whether you used the standard "Publish it to Word" or
Stephen Lebans's alternative. If the former, this sort of thing is
normal. If Lebans, I don't know the details but there are some
complications and limitations. Read his documentation carefully and
you'll now a lot more about it than I do.
 
Back
Top