Customizing forms after being generated

[Guest]

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

 

[John W. Vinson]

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

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]

 

[Guest]

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

 

[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?

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]

 

[Guest]

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.

 

[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...

 

[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.

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]

 

[Guest]

Thanks. for your feedback.

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...

 

[Guest]

Thank you for your feedback.

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]