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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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


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

He said FIELDS not records.
 
Mike said:
He said FIELDS not records.


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