Re: Creating automatically different export paths

From: GeoHunter (anonymous_at_discussions.microsoft.com)
Date: 07/04/04


Date: Sun, 4 Jul 2004 04:35:58 -0700

Ken, can you please show me the line of code, I'm sot very
good in code.

thx

>-----Original Message-----
>VBA contains the command MkDir which allows you to create
a new directory.
>
>--
>
> Ken Snell
><MS ACCESS MVP>
>
>"GeoHunter" <anonymous@discussions.microsoft.com> wrote
in message
>news:268fa01c4617c$9f852a80$a301280a@phx.gbl...
>> I run a report for multiple customers - for each
customer
>> it's own report. In my proccess after the report is
>> generated it is exported to a specific location and
after
>> it is e-amiled as an attachment. Is there possible to
>> create on the fly a new path where to save the reports?
>> Let's to say for customer AA the path will be
>> C:\MyDocument\AA, for cust BB to save in
>> C:\MyDocument\BB...my question if the folder AA or BB
can
>> be created through the proccess not before I run the
>> reports?
>>
>> thx
>>
>
>
>.
>



Relevant Pages

  • Re: Calculating a new balance for each line item reported
    ... I actually don't have a one in the header but that can be easily ... Thx for the quick reply I will test it out tomorrow. ... rather than allenbrowne at mvps dot org. ... >> Basically how do I do that in a report where we do NOT have the Avail Bal ...
    (microsoft.public.access.reports)
  • Re: Microsoft Access Report - summing only grouped values
    ... > Microsoft Access MVP ... >> I have redundant area detail. ... The redundancy is eliminated in report ... >> thx. ...
    (microsoft.public.access.reports)
  • Re: How to Report Delta on Queried Data?
    ... Thx for the reply. ... I can compare all records created today against all ... We report progress on project task assignments everyday, ... each other for a delta in one of the fields and report on any records ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Creating automatically different export paths
    ... "GeoHunter" wrote in message ... > I run a report for multiple customers - for each customer ... > it's own report. ... In my proccess after the report is ...
    (microsoft.public.access.modulesdaovba)
  • Re: multiple columns error...pls hlp
    ... the subreport and make sure that they appear even though the subreport might ... thx again. ... > There is a limit to the number of columns support by Access reports. ... >> you loaded a form or report that has controls or properties that Microsoft ...
    (microsoft.public.access.reports)