Printing Reports on single records upon request

[Guest]

Hi,

I've recently completed a databse, that has a table with a bunch of
different software names and information. Each row has the name and
information for a single piece of software. I can print reports of all the
software one after the other, or I can print it with each row(record) on a
sperate page, but that comes out to a load of pages. What I want to do is
have the user pick what single software they desire, and print that on a
single page, without any of the other ones. BUT HOW??!?!

Thanks Guys,
Felix

 

[Guest]

Fiddles,

Make a standard report based on your table or query which has the info you
want to print. Set it up the way you want. Don't worry about it having all
the records available when you open it.

Now on a/your form which your users will use to go through the software and
perform searches... add a new button to print the current record. add the
following code to the on click event

Typical Synthax:
DoCmd.OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode,
OpenArgs)

Your Case:
DoCmd.OpenReport "YourReportName",acViewPreview,
,"[Table/QueryPrimaryKeyFieldName]=" & Me.FormPrimaryKeyControlName

What we'eve done basically is opened your report but adding a condition to
filter only on the current record.

Hope this is what you had in mind,

Daniel P

 

[Guest]

Thanks, I believe this is what I am looking for, but im having problems. I
want to use a join table query to be preinted to a report, and I cannot
extract teh values from it. I get a message box asking me to type in the
parameter value for my where cluase, and if i type it the value that should
equal the current record, it prints all of them??

Thx thx,
felix

Fiddles,

Make a standard report based on your table or query which has the info you
want to print. Set it up the way you want. Don't worry about it having all
the records available when you open it.

Now on a/your form which your users will use to go through the software and
perform searches... add a new button to print the current record. add the
following code to the on click event

Typical Synthax:
DoCmd.OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode,
OpenArgs)

Your Case:
DoCmd.OpenReport "YourReportName",acViewPreview,
,"[Table/QueryPrimaryKeyFieldName]=" & Me.FormPrimaryKeyControlName

What we'eve done basically is opened your report but adding a condition to
filter only on the current record.

Hope this is what you had in mind,

Daniel P

Hi,

I've recently completed a databse, that has a table with a bunch of
different software names and information. Each row has the name and
information for a single piece of software. I can print reports of all the
software one after the other, or I can print it with each row(record) on a
sperate page, but that comes out to a load of pages. What I want to do is
have the user pick what single software they desire, and print that on a
single page, without any of the other ones. BUT HOW??!?!

Thanks Guys,
Felix