Custom Report Name?

[Guest]

I have a report that I printpreview from a form, I would like to have either
1or2 fields from my form/report to show up in my reportname so that when I
save/export the report, I don't have to type a report name. Is this possible?
if so how?

thanks in advance,

Brook

 

[Jeff Boyce]

Brook

In your report definition, in the Header section, add an unbound textbox
control.

In the control's source, add something like (your syntax may vary):
=Forms![YourFormName]![YourFormFieldContainingTheTitle]

 

[Guest]

Jeff,

Thank you very much, that worked perfectly!

When I export my report, will this new Report name show up in my save as
dialog box?

Brook

Brook

In your report definition, in the Header section, add an unbound textbox
control.

In the control's source, add something like (your syntax may vary):
=Forms![YourFormName]![YourFormFieldContainingTheTitle]

--
Regards

Jeff Boyce
<Access MVP>

I have a report that I printpreview from a form, I would like to have either
1or2 fields from my form/report to show up in my reportname so that when I
save/export the report, I don't have to type a report name. Is this possible?
if so how?

thanks in advance,

Brook

 

[Jeff Boyce]

Brook

Not there, can't tell what you're trying to do.

"When I export my report" ... to where? If another Access database, that
other database won't have the form the report uses, will it?

More info, please...

Jeff Boyce
<Access MVP>

Jeff,

Thank you very much, that worked perfectly!

When I export my report, will this new Report name show up in my save as
dialog box?

Brook

Brook

In your report definition, in the Header section, add an unbound textbox
control.

In the control's source, add something like (your syntax may vary):
=Forms![YourFormName]![YourFormFieldContainingTheTitle]

--
Regards

Jeff Boyce
<Access MVP>

I have a report that I printpreview from a form, I would like to have either
1or2 fields from my form/report to show up in my reportname so that when I
save/export the report, I don't have to type a report name. Is this possible?
if so how?

thanks in advance,

Brook

 

[Guest]

Jeff,

What I am trying to do is have a report name so that when I print to PDF,
the report name will automatically be filled in in the "Save As" dialog box.

Brook

Brook

Not there, can't tell what you're trying to do.

"When I export my report" ... to where? If another Access database, that
other database won't have the form the report uses, will it?

More info, please...

Jeff Boyce
<Access MVP>

Jeff,

Thank you very much, that worked perfectly!

When I export my report, will this new Report name show up in my save as
dialog box?

Brook

Brook

In your report definition, in the Header section, add an unbound textbox
control.

In the control's source, add something like (your syntax may vary):
=Forms![YourFormName]![YourFormFieldContainingTheTitle]

--
Regards

Jeff Boyce
<Access MVP>

I have a report that I printpreview from a form, I would like to have
either
1or2 fields from my form/report to show up in my reportname so that when I
save/export the report, I don't have to type a report name. Is this
possible?
if so how?

thanks in advance,

Brook

 

[Jeff Boyce]

Brook

I don't know specifically, but you may want to take a look at the PrtDevMode
syntax. You may be able to find what you're after there.

Also, try searching at Google.com for something like "print to PDF"

--
Regards

Jeff Boyce
<Access MVP>

Jeff,

What I am trying to do is have a report name so that when I print to PDF,
the report name will automatically be filled in in the "Save As" dialog box.

Brook

Brook

Not there, can't tell what you're trying to do.

"When I export my report" ... to where? If another Access database, that
other database won't have the form the report uses, will it?

More info, please...

Jeff Boyce
<Access MVP>

Jeff,

Thank you very much, that worked perfectly!

When I export my report, will this new Report name show up in my save as
dialog box?

Brook

:

Brook

In your report definition, in the Header section, add an unbound textbox
control.

In the control's source, add something like (your syntax may vary):
=Forms![YourFormName]![YourFormFieldContainingTheTitle]

--
Regards

Jeff Boyce
<Access MVP>

I have a report that I printpreview from a form, I would like to have
either
1or2 fields from my form/report to show up in my reportname so

that
when I

save/export the report, I don't have to type a report name. Is this
possible?
if so how?

thanks in advance,

Brook