Report with blank

[Cody Kiroff]

Hello,
First, I would like to preface by saying I am an intern and my time is
ending soon. I want to have this working before I leave.

What I want:
I have a form with several subs. I want them to be put onto a report.
(done, no problem) There is another section that needs to be filled out and
will change with each record. I was unsure how to set up a table for this,
so I haven't yet. This is my first access endeavor.
I want the user to click the print record button on the form and have the
following occur:
1)Insert all values from form into the report
2)Leave a table on the report blank so the user can fill out the information
after the report event.

Please help

 

[John W. Vinson]

Hello,
First, I would like to preface by saying I am an intern and my time is
ending soon. I want to have this working before I leave.

What I want:
I have a form with several subs. I want them to be put onto a report.

Ummmm... No. You don't.

You want the *data in the Tables* put into a report. The Form is just a tool,
a window which lets you edit data in tables. The tables are fundamental; the
forms and reports are secondary.

(done, no problem) There is another section that needs to be filled out and
will change with each record. I was unsure how to set up a table for this,
so I haven't yet. This is my first access endeavor.
I want the user to click the print record button on the form and have the
following occur:
1)Insert all values from form into the report

Base the Report on a Query (based on the table that the form is updating); the
query can reference a control on the Form to determine which record or records
should be included in the report.

2)Leave a table on the report blank so the user can fill out the information
after the report event.

Do you mean that you just want a grid of lines printed on the paper so the
user can write on the sheet? If so use the Line and/or Rectangle controls. You
can't "leave a table blank on the report" if you mean and Access Table object.

 

[Cody Kiroff]

Right, I'm sorry I didn't mean that I wanted forms printed on the report. I
meant I want the fields I have on the form that reference the tables to be on
the report.

How would I go about basing the query on a form with subforms. Does this
have something to do with saving my recordsource as object type query?

I want a place where users can type. The report would open with the updated
information from a specific record. Then there would be a table that they
could manually enter in data via the keyboard. Is this possible?

Thanks in advance.

 

[John W. Vinson]

Right, I'm sorry I didn't mean that I wanted forms printed on the report. I
meant I want the fields I have on the form that reference the tables to be on
the report.

Again:

The Form is linked to the Tables.

The Report is also linked to the Tables.

The Report is (with one exception, see below) *NOT* linked to the Form.

How would I go about basing the query on a form with subforms. Does this
have something to do with saving my recordsource as object type query?

Typically you would use a Form (based on the "one" side table in a
relationship) with one or more Subforms (based on the "many" side tables) to
update a related set of tables. A Report would instead be based on a Query
(not the same query as used for the form!) joining all of these tables with
appropriate join types. Not knowing anything about your data structure I'm not
sure what these would be.

I want a place where users can type. The report would open with the updated
information from a specific record. Then there would be a table that they
could manually enter in data via the keyboard. Is this possible?

Well... yes. You would have a Table (not a grid of lines on paper, but an
Access Table used for data storage); you would base a Form or perhaps a
Subform on that table; the user would use the Form to enter data into the
Table; you would include that Table in the Form's Recordsource.