Re: Creating automatically different export paths

From: Ken Snell (kthsneisllis9_at_ncoomcastt.renaetl)
Date: 07/04/04

  • Next message: M.L. Sco Scofield: "Re: Paramer queries" 
    Date: Sun, 4 Jul 2004 00:10:52 -0400

    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
>
  • Next message: M.L. Sco Scofield: "Re: Paramer queries"

    Relevant Pages

    • Abuse report
      ... This is an automated response to the email you sent to the BT Customer ... All cases of abuse are taken very seriously. ... please report abuse where someone using a BT domain or a BT IP ... directly to the offender's Internet Service Provider. ...
      (uk.rec.motorcycles)
    • Re: Help ... Creating an invoice
      ... So what you will want is a query that will return the required information ... for a report to use. ... for just the records for that customer. ... > if I want that order to be placed on the invoice? ...
      (microsoft.public.access.forms)
    • Re: move data from list box or combo box to another list
      ... employees is because each employee gets paid commission on the service they ... The customer and dates are ... Lets address your problem with your report which seems to be your main ... Oh yeah and also you should/could have a filter in your query so that your ...
      (microsoft.public.access.forms)
    • Re: DBForms convert Access db and forms from Access to PHP + Mysql
      ... After conversion you'll have to use PHP tools, AJAX and work with MySql. ... say hey here's some great report writer that works with mySql. ... taking orders from a customer. ...
      (comp.databases.ms-access)
    • Re: Have date automatically go into another form
      ... i have created a report from the table in which i have diffrent customers ... i.e if for example i need to see the reports of the customer who have made a ... On Error GoTo Err_ ButtonNname _Click ... Dim stDocName As String ...
      (microsoft.public.access.gettingstarted)