Report with "form fields"

E

EdS

Is there a way to create an access report which has some embedded "form
fields" which a recipient can then reply to by "filling in the blanks"
(perhaps using Microsoft Word to edit the report)? This would then allow
them to keyboard in their responses, and email the report back. Effectively
this would then function just as a Microsoft Word "forms report".

Since there is much database information that needs to be on the report, I
need to generate the report from Access, instead of a generic Microsoft Word
report.
 
E

EdS

Since you CAN create an interactive form/report in both Word and Excel, my
question still remains; can this be done in Access as well?
 
R

Rick Brandt

EdS said:
Since you CAN create an interactive form/report in both Word and
Excel, my question still remains; can this be done in Access as well?
Click to expand...

Remember the old DOS word processor programs where you did all your typing
in a terminal font and the program used colors and underlines to indicate
BOLD or font changes? The later (VGA) versions of these provided a "Print
Preview" which was an on-screen image of what your report would look like
were you to actually print it. Since it was just an image you couldn't
actually work with it in preview mode.

Access reports are similar. The report "object" is a VBA Class that when
run will cause a certain pattern of ink to come out of your printer. The
Print Preview is simply a picture of "what you will get if you print it" and
as with the old word processor programs it cannot be typed in or have
buttons to press like a form. It is just pixels.
 
T

Tom Lake

EdS said:
Is there a way to create an access report which has some embedded "form
fields" which a recipient can then reply to by "filling in the blanks"
(perhaps using Microsoft Word to edit the report)? This would then allow
them to keyboard in their responses, and email the report back.
Effectively
this would then function just as a Microsoft Word "forms report".

Since there is much database information that needs to be on the report, I
need to generate the report from Access, instead of a generic Microsoft
Word
report.
Click to expand...

There's no way to use a report for that but you can use a form.

Tom Lake
 
E

EdS

Thank for the clarification, Rick.


Rick Brandt said:
Remember the old DOS word processor programs where you did all your typing
in a terminal font and the program used colors and underlines to indicate
BOLD or font changes? The later (VGA) versions of these provided a "Print
Preview" which was an on-screen image of what your report would look like
were you to actually print it. Since it was just an image you couldn't
actually work with it in preview mode.

Access reports are similar. The report "object" is a VBA Class that when
run will cause a certain pattern of ink to come out of your printer. The
Print Preview is simply a picture of "what you will get if you print it" and
as with the old word processor programs it cannot be typed in or have
buttons to press like a form. It is just pixels.
Click to expand...
 
Top