Can a subset of a form's fields be EASILY printed.

T

ThomasAJ

A form has over 100 fields.
I want to enable a programmer preselected number of fields for a user
selected number of records to be EASILY printed.

Sure I can store the form's unique key in a file when a user presses a
button on the form, then use that info to drive a report. But I don't want to
go down that path. I want the user to press a button on the form and then
have access print 20 of the forms fields (fields that I have selected for
printing).
 
P

Pat Hartman

If you look at the arguments for the OpenReport method, you'll see that it
is possible to specify a where clause. That will allow you to restrict
printing of the report to only the current record on the form.
 
T

ThomasAJ

With respect Pat I'm not sure that you have read the question carefully.

I'm not sure that I can explain it more fully without knowing what it is
that you are unsure of.

--
Regards
Tom


Pat Hartman said:
If you look at the arguments for the OpenReport method, you'll see that it
is possible to specify a where clause. That will allow you to restrict
printing of the report to only the current record on the form.
Click to expand...
 
R

Rick Brandt

ThomasAJ said:
A form has over 100 fields.
I want to enable a programmer preselected number of fields for a user
selected number of records to be EASILY printed.

Sure I can store the form's unique key in a file when a user presses a
button on the form, then use that info to drive a report. But I don't
want to go down that path. I want the user to press a button on the
form and then have access print 20 of the forms fields (fields that I
have selected for printing).
Click to expand...

While printing forms is generally not a good idea every object on the form has a
DisplayWhen property that you can set to "Screen Only" which causes them to NOT
be printed if you print the form.
 
M

Marshall Barton

ThomasAJ said:
A form has over 100 fields.
I want to enable a programmer preselected number of fields for a user
selected number of records to be EASILY printed.

Sure I can store the form's unique key in a file when a user presses a
button on the form, then use that info to drive a report. But I don't want to
go down that path. I want the user to press a button on the form and then
have access print 20 of the forms fields (fields that I have selected for
printing).
Click to expand...


You didn't explain if those records are just multiple copies
of the single record on the form or if they are a random
group of records from a table or what.

It's easy enough for the programmer to specify the fields in
a report and print duplicate copies for a single record.
Similaly for a random selection of records, but I wouldn't
want to speculate on how to implement some unspeciified
operation.
 
M

Mike Painter

Marshall said:
You didn't explain if those records are just multiple copies
of the single record on the form or if they are a random
group of records from a table or what.
Click to expand...

He said FIELDS not records.
 
M

Marshall Barton

Mike said:
He said FIELDS not records.
Click to expand...


Simon said "programmer" selected fields, but he didn't say
how the programmer would select them.

How the report would be set up also depends on what
record(s?) would be included in the report.
 
Top