Report Outputto new folder

[prodtest]

Hi,
Not sure if what I want to do is possible, I need to be able to have a button on a form which when selected generates a report with the file named after a text box on my form and saves in it in a new folder with the same name as the report. The folder needs to be saved in a folder on a server.
Is this possibe ?
Ben

 

[Remou]

You will need
Dir - to check if the directory already exists
And
MkDir (strDir) - to create the directory

Then, for the file:
DoCmd.OutputTo

 

[ZmrAbdulla]

To create a folder
"CreateFolder Method" ,"MkDir Statement" are the basic things you are looking for. check it in the vba help.

To save report
you have to look for "OutputTo" , "SendObject" etc..


________________________________________________________
Zameer Abdulla
Help to find Missing people
My father was a realistic father; not a vending machine dispense everything I demanded for!!

 

[ZmrAbdulla]

Remou, sorry I didn't refresh the page.

________________________________________________________
Zameer Abdulla
Help to find Missing people
My father was a realistic father; not a vending machine dispense everything I demanded for!!