Customizing forms after being generated

J

John W. Vinson

Can you customize a form after being generated by the database?
(Yes, I'm new.)
Click to expand...

Yes, and it's very routine to do so.

Click the Forms tab on the database window; select the form; and click the
Design tool (looks like a triangle and straightedge).

John W. Vinson [MVP]
 
J

jehmsit

John, thanks for responding - - However, what I meant to ask was... "Is it
possible to edit (pref. by the user, from within Access) a desired report,
after the form has been submitted and the database output (letter) has been
generated?

Situation: Using a form, selected information (which is contained in db
tables) are used to generate a letter. Is it then possible to insert
additional "unique" data by hand into the report prior to printing? (pref.
within access, or by automatically having access open up word or something?

Thanks in advance.

JohnH
 
J

John W. Vinson

John, thanks for responding - - However, what I meant to ask was... "Is it
possible to edit (pref. by the user, from within Access) a desired report,
after the form has been submitted and the database output (letter) has been
generated?

Situation: Using a form, selected information (which is contained in db
tables) are used to generate a letter. Is it then possible to insert
additional "unique" data by hand into the report prior to printing? (pref.
within access, or by automatically having access open up word or something?
Click to expand...

Not to my knowledge, no. The Report is an output-only object.

You can output a report to Word, saving it as a .rtf file, but this often
messes up the formatting badly; or you can use VBA code to actually create a
Word document (usually from a template) filled in with database field values;
or you can do it all from Word, using a mail merge with Access as the data
source.

John W. Vinson [MVP]
 
J

jehmsit

Acknowledged.
-
Is there an existing thread that you are aware of or can you provide some
insight to the last suggestion (mail merge with Access as the source)?
J.
 
A

Amanda

Hi John H,

Just add a field (or two, however many is necessary) that allows a
user to enter whatever customized info they need to enter. Have them
enter this BEFORE the report is generated and, inside the report,
insert that extra field or two wherever and set the property to grow.

I've done that before...
 
J

John W. Vinson

Hi John H,

Just add a field (or two, however many is necessary) that allows a
user to enter whatever customized info they need to enter. Have them
enter this BEFORE the report is generated and, inside the report,
insert that extra field or two wherever and set the property to grow.
Click to expand...

Good idea! You needn't even add the field to the table; you can have unbound
fields on the form which launches the report and use textboxes with control
source like

=Forms!NameOfForm!NameOfControl

to display the data from the form.

John W. Vinson [MVP]
 
J

jehmsit

Thanks. for your feedback.

Amanda said:
Hi John H,

Just add a field (or two, however many is necessary) that allows a
user to enter whatever customized info they need to enter. Have them
enter this BEFORE the report is generated and, inside the report,
insert that extra field or two wherever and set the property to grow.

I've done that before...
Click to expand...
 
J

jehmsit

Thank you for your feedback.

John W. Vinson said:
Good idea! You needn't even add the field to the table; you can have unbound
fields on the form which launches the report and use textboxes with control
source like

=Forms!NameOfForm!NameOfControl

to display the data from the form.

John W. Vinson [MVP]
Click to expand...
 
Top