Custom Report Name?

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

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

Jeff Boyce said:
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>

Brook said:
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
Click to expand...
Click to expand...
 
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>

Brook said:
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

Jeff Boyce said:
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>

Brook said:
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
Click to expand...
Click to expand...
Click to expand...
 
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

Jeff Boyce said:
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>

Brook said:
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

Jeff Boyce said:
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
Click to expand...
Click to expand...
Click to expand...
 
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>

Brook said:
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

Jeff Boyce said:
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>

Brook said:
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
Click to expand...
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top