print name

[Joel Allen]

Hello,

From a macro, is there a way to print with a specific file name derived from
the database?

e.g. C:\test\[JobName]\

Thansks for your help,
Joel

 

[Steve Schapel]

Joel,

I am sorry, can you please clarify what you mean? Do you mean you want
the report to include the file name printed on the report somewhere? Or
are you talking about exporting the report to a specific file? If so,
what sort of export are you doing? Or something else? And what does
"derived from the database" mean? You mean there is a filename field in
a table? If so, how do we know which record in the table to use in
referencing the file name?

 

[Joel Allen]

Thanks for repsonding Steve. You've been very helpful to me in the past.

Let's say I have a report with several records. In the report it has a
field called JobName. I'm trying to make the macro open the report, output
to html with the file name c:\test\[JobName]. Then go to the next record,
output to html with the file name c:\test\[JobName], etc.........

Is this possible?

Thanks,
Joel

Joel,

I am sorry, can you please clarify what you mean? Do you mean you want
the report to include the file name printed on the report somewhere? Or
are you talking about exporting the report to a specific file? If so, what
sort of export are you doing? Or something else? And what does "derived
from the database" mean? You mean there is a filename field in a table?
If so, how do we know which record in the table to use in referencing the
file name?

--
Steve Schapel, Microsoft Access MVP

Hello,

From a macro, is there a way to print with a specific file name derived
from the database?

e.g. C:\test\[JobName]\

Thansks for your help,
Joel