reports

[Guest]

I have 4 different reports that I want to print at the same time. Right now I
have 4 reports that I've created using queries with one criteria field
needing to be filled out before displaying the results of the report. Once
the end user specifies the criteria they are being prompted for i.e.: SSN,
the report will be populated with the proper information to be printed off.
Now, what I want to do is make one report command button to prompt for the
criteria information and then print all of the 4 reports that I have already
created.

Thanks in Advance,

 

[Guest]

Instead of prompting for the criteria, create textboxes on the form for the
criteria. Base the reports' queries' criteria on the textboxes instead of on
a prompt. For example, in your queries, you now have something like [Enter
the SSN] somewhere on the criteria row. If you add a textbox to your form
called txtSSN, your query's criteria line would change to:

Forms!frmReports!txtSSN

If you made this change to all your reports, you couls open all the rpoerts
from the command button and they would all filter on the same value.

HTH,
Barry

 

[Guest]

Barry,

Thanks for getting back to me; but I don't know if this solution will
work. Sometimes the person using the database won't be on the form to print a
report on a particular person, or print off a person without losing their
current data record that they are inputting. I think the solution that you're
suggesting, is assuming that someone is on the form and the text box will be
populated with the information that he/she wants to print which is not always
the case. That is why I have all of my reports based on the queries asking
for that piece of information. There is another form that houses all of the
report buttons for the client to choose from in the case that someone needs a
on client A, while the customer is still putting in the record of Client B. I
just want to create one button that will print 4 different reports that match
the criteria I provide it with.

Thanks Again,

Instead of prompting for the criteria, create textboxes on the form for the
criteria. Base the reports' queries' criteria on the textboxes instead of on
a prompt. For example, in your queries, you now have something like [Enter
the SSN] somewhere on the criteria row. If you add a textbox to your form
called txtSSN, your query's criteria line would change to:

Forms!frmReports!txtSSN

If you made this change to all your reports, you couls open all the rpoerts
from the command button and they would all filter on the same value.

HTH,
Barry

I have 4 different reports that I want to print at the same time. Right now I
have 4 reports that I've created using queries with one criteria field
needing to be filled out before displaying the results of the report. Once
the end user specifies the criteria they are being prompted for i.e.: SSN,
the report will be populated with the proper information to be printed off.
Now, what I want to do is make one report command button to prompt for the
criteria information and then print all of the 4 reports that I have already
created.

Thanks in Advance,

 

[Guest]

Another alternative is to have the code prompt for the criteria with an
InputBox and pass the criteria to the reports as a filter. Something like:

Dim strSSN as String
Dim strCriteria as String
strSSN = InputBox("Enter the SSN","SSN")
strCriteria = "[SSN] = " & strSSN ' Not sure is SSN field is numeric or text.
Docmd.OpenReport "rptFirst", WhereCondition: = strCriteria
DoCmd.OpenReport "rptSecond", WhereCondition:=strCriteria

HTH,
Barry

Barry,

Thanks for getting back to me; but I don't know if this solution will
work. Sometimes the person using the database won't be on the form to print a
report on a particular person, or print off a person without losing their
current data record that they are inputting. I think the solution that you're
suggesting, is assuming that someone is on the form and the text box will be
populated with the information that he/she wants to print which is not always
the case. That is why I have all of my reports based on the queries asking
for that piece of information. There is another form that houses all of the
report buttons for the client to choose from in the case that someone needs a
on client A, while the customer is still putting in the record of Client B. I
just want to create one button that will print 4 different reports that match
the criteria I provide it with.

Thanks Again,

Instead of prompting for the criteria, create textboxes on the form for the
criteria. Base the reports' queries' criteria on the textboxes instead of on
a prompt. For example, in your queries, you now have something like [Enter
the SSN] somewhere on the criteria row. If you add a textbox to your form
called txtSSN, your query's criteria line would change to:

Forms!frmReports!txtSSN

If you made this change to all your reports, you couls open all the rpoerts
from the command button and they would all filter on the same value.

HTH,
Barry

I have 4 different reports that I want to print at the same time. Right now I
have 4 reports that I've created using queries with one criteria field
needing to be filled out before displaying the results of the report. Once
the end user specifies the criteria they are being prompted for i.e.: SSN,
the report will be populated with the proper information to be printed off.
Now, what I want to do is make one report command button to prompt for the
criteria information and then print all of the 4 reports that I have already
created.

Thanks in Advance,