How do i save files to specific folder

[AccessTest]

Hi guys,

I have access 2000 application for real estate.
I have form that i was creating a "file open" dialog box.
I was using the module from http://www.mvps.org/access/api/api0001.htm
and it is working fine.
This module is uploading the image that i want to specific field in the DB.

Now i have another issues and i would appreciate your help:
assuming that i am uploading image (with the module) and this image should be saved as well into the directory of the building - from some reason i can not manage to do so, any suggestions how to save files from access db to specific folder?

Appreciate your time.
Thanks

 

[dcobau]

Don't know if I understood your Q properly. I use the following line of code to transfer the contents of a temp table to a 'hard coded' directory:

DoCmd.TransferText acExportMerge, , "tblMailMerge", "c:\temp\MergeTable.txt", True

Dave

 

[The_Doc_Man]

Assuming you know the name of the source file and the name you want it to have in the destination, do this from VBA:

FileCopy source-file-spec,destination-file-spec

where the source and destination file specifications can include device, path, name, and type.

 

[a_20120]

Hi All,
I am eager to know this too, mean when we upload the a picture into image control, then How save the picture in a specific folder, with another name maybe

 

[AccessTest]

Hi guys,

Thanks for your reply.

Dave, i will try to explain myself, i am using dialog box form the URL that i sent here - http://www.mvps.org/access/api/api0001.htm - this is the common FileSave API that is uploding images to the DB - this is works perfect.
Once the image is in the DB i.e. within table 'T_Building' field 'Path_Plan' i would like to save the image that is currently located in the table on giving directory on my 'C'.

Also, in your code can i move specific field and not all the table?
DoCmd.TransferText acExportMerge, , "tblMailMerge", "c:\temp\MergeTable.txt", True

Thanks a lot

 

[dcobau]

Hi,

I am pretty sure you cannot send the values of only some of the fields. You could use a query (based on the temp table) to export text (check out TransferText in Access help) or modify the make table query to export only the values of the fields you need.

BTW, acExportMerge is only for merging mail so you will probably need acExportDelim or acExportFixed.

Dave