form to specify copies of different reports

[Ann in CA]

Hello,
I have a table with two fields, spec type and report name. The report name
is not visible to the user, it is a field with the title of the report. So if
a person clicks on the type of spec in a different field, it looks up the
report name and opens it in print preview. Now, I would like to take this one
step further and have a continuous form with a list of all of the types for
which reports are available (query that says reportname is not null) AND has
a box for "quantity" which would specify how many copies of the report (which
are all one page, unbound reports). So the user interface would basically be:


<u>Report Copies</u>
Basic 1
Standard 0
Advanced 2
Expert 0
______
| Print |
---------

There is no need to store the number of copies for each form, each time the
users (all using distributed mde front ends) opened the form everything would
be at zero.

Is this possible?

TIA...

 

[Carl Rapson]

Hello,
I have a table with two fields, spec type and report name. The report name
is not visible to the user, it is a field with the title of the report. So
if
a person clicks on the type of spec in a different field, it looks up the
report name and opens it in print preview. Now, I would like to take this
one
step further and have a continuous form with a list of all of the types
for
which reports are available (query that says reportname is not null) AND
has
a box for "quantity" which would specify how many copies of the report
(which
are all one page, unbound reports). So the user interface would basically
be:


<u>Report Copies</u>
Basic 1
Standard 0
Advanced 2
Expert 0
______
| Print |
---------

There is no need to store the number of copies for each form, each time
the
users (all using distributed mde front ends) opened the form everything
would
be at zero.

Is this possible?

TIA...

Sure it's possible. What I would do is use a local table in the front-end as
the Record Source of your continuous form. In the Form_Load event, empty the
table and then populate it with the list of reports, setting the Copies to
0. Something like:

INSERT INTO temp_table([spec],[reportname],[Copies])
SELECT [spec],[reportname],0 FROM my_table
WHERE [reportname] IS NOT NULL;

I assume you will use a command button to "kick off" the reports. In the
Click event of the button, open a recordset on the table and print the
reports the appropriate number of times.

Carl Rapson

 

[Ann in CA]

That sounds great. Thank you for your help!

Hello,
I have a table with two fields, spec type and report name. The report name
is not visible to the user, it is a field with the title of the report. So
if
a person clicks on the type of spec in a different field, it looks up the
report name and opens it in print preview. Now, I would like to take this
one
step further and have a continuous form with a list of all of the types
for
which reports are available (query that says reportname is not null) AND
has
a box for "quantity" which would specify how many copies of the report
(which
are all one page, unbound reports). So the user interface would basically
be:


<u>Report Copies</u>
Basic 1
Standard 0
Advanced 2
Expert 0
______
| Print |
---------

There is no need to store the number of copies for each form, each time
the
users (all using distributed mde front ends) opened the form everything
would
be at zero.

Is this possible?

TIA...

Sure it's possible. What I would do is use a local table in the front-end as
the Record Source of your continuous form. In the Form_Load event, empty the
table and then populate it with the list of reports, setting the Copies to
0. Something like:

INSERT INTO temp_table([spec],[reportname],[Copies])
SELECT [spec],[reportname],0 FROM my_table
WHERE [reportname] IS NOT NULL;

I assume you will use a command button to "kick off" the reports. In the
Click event of the button, open a recordset on the table and print the
reports the appropriate number of times.

Carl Rapson