R
Roundy
I am trying to use a macro to output a report to file. I would prefer to
output to .rtf, but the logo I have on the report does not come accross then.
My main question relates to how to save the file in a specific location,
that is different each time. For example, the field I am filtering on
JobNumber is also a folder number in our directory structure on the network.
So I would like to ouput the file to
I am not sure what is the best way, because there are a few variables. The
job number starts out with the year in it, for example 2006001, so if that is
the job number I would want to go to M:\06_Jobs\2006001\Service. If the job
number were 2005001 I would want it to save to M:\05_Jobs\2005001\Service.
Access 2003 SP2
TIA
output to .rtf, but the logo I have on the report does not come accross then.
My main question relates to how to save the file in a specific location,
that is different each time. For example, the field I am filtering on
JobNumber is also a folder number in our directory structure on the network.
So I would like to ouput the file to
I am not sure what is the best way, because there are a few variables. The
job number starts out with the year in it, for example 2006001, so if that is
the job number I would want to go to M:\06_Jobs\2006001\Service. If the job
number were 2005001 I would want it to save to M:\05_Jobs\2005001\Service.
Access 2003 SP2
TIA