Output to file????

[Guest]

Thanks in advance.....
I could use some help with the following.

Here's what I have so far....
Dim stDocName As String
Dim stCriteria As String

stDocName = "rptFosterHome"
stCriteria = "[FHFileID] =" & Me![FHFileID]
DoCmd.OutputTo acReport, stDocName

What I need now is for this to go to a file folder on the I: drive.

Can anyone help????

Regards.

 

[SusanV]

You need to pass additional parameters for output file type and path &
filename.
Here's an example for a text file, there are other options available.

DoCmd.OutputTo acReport, "rptFosterHome", "MS-DOSText(*.txt)",
"I:\Folder\rptFosterHome\YourReport.txt", False, ""

If this is a network share that users will be outputting to you should use
the UNC rather than the mapped drive (in case the user maps something else
as I)

DoCmd.OutputTo acReport, "rptFosterHome", "MS-DOSText(*.txt)",
""\\Server\Share\Folder\rptFosterHome\YourReport.txt", False, ""

 

[Guest]

Hello Susan Thank you.

But, this output captures a snapshot for saving.
I need to upload tif imaages to our scan server from my desktop.

So would I then change say the MSdos..... for example SNP or something to that
effect......

Again thank you

You need to pass additional parameters for output file type and path &
filename.
Here's an example for a text file, there are other options available.

DoCmd.OutputTo acReport, "rptFosterHome", "MS-DOSText(*.txt)",
"I:\Folder\rptFosterHome\YourReport.txt", False, ""

If this is a network share that users will be outputting to you should use
the UNC rather than the mapped drive (in case the user maps something else
as I)

DoCmd.OutputTo acReport, "rptFosterHome", "MS-DOSText(*.txt)",
""\\Server\Share\Folder\rptFosterHome\YourReport.txt", False, ""

--
hth,
SusanV

Thanks in advance.....
I could use some help with the following.

Here's what I have so far....
Dim stDocName As String
Dim stCriteria As String

stDocName = "rptFosterHome"
stCriteria = "[FHFileID] =" & Me![FHFileID]
DoCmd.OutputTo acReport, stDocName

What I need now is for this to go to a file folder on the I: drive.

Can anyone help????

Regards.