Report Design Using Forms

  • Thread starter Thread starter Clarence
  • Start date Start date
C

Clarence

I have a form that was created in Microsoft Word. It is
basically a departmental requisition form and what I want
to do is use it as the design for a report in access.
I don't want to re-design it in access.

How do I do this?
 
You may need to use automation with Word or a Word Merge. You can't convert
a Word layout to an Access report form.
 
I don't want to convert the word document. Essentially
what I want to do is have it as a background picture so I
can insert the data fields in the correct locations. I
hope that makes sense.

If that's not possible then what do I need to do in access
to make the mail merge to the word document a simple fool
proof one click process. The folks using the application
are not going to want to have to open the word document
and do the mail merge steps nor would they know how.
 
I've read somewhere that Access isn't very good at handling the other office
applications, but you might be able to add a simple command button to a form
which will call a Word Document based a Word Template which could
conceivably contain an autorun macro. The autorun macro could then be made
to retrieve the Access data & insert it into your Word document in the
correct locations.

- Terry
 
It may be possible using software like SnagIt www.techsmith.com to capture
the screen and convert it to an image. Or print and scan the result. You can
use the image as a background for the report.
 
Back
Top