Copy Files Into Specific Folder

Apr 16, 2012

I have created a database that saves a link of technical data. Now i have forms where you can add the hyperlink of the data in the database. You can also type information about the data into the form (like location, what kind of part etcc.)But I was asked to save the data in a specific folder that you can select.

So what I have to do is:

Browse for a file in a form.Save the hyperlink of the file in the database.Don't save the file in the database, but copy the file that's selected when browsing to specified folder

View Replies


ADVERTISEMENT

Modules & VBA :: Search For All Picture Files In Documents And Copy To A Folder On Desktop

Mar 28, 2014

I've been trying to search for all picture files in my documents and copy them to a folder on the desktop. I found this and it work great for searching however I'm having trouble getting the copy to work. [URL] ....

Code:
Dim colFiles As New Collection
RecursiveDir colFiles, "C:Photos", "*.jpg", True
Dim vFile As Variant
For Each vFile In colFiles
Debug.Print vFile
Next vFile

Code:

I replaced the debug.print vfile with my copy function. I've tried copyfile but it needs to specify the destination with the file name. I tried using the FSO filecopy method and can't get it to work (keep getting a compile error "Expected =") I feel the hard part is done and this part should be simple.

View 3 Replies View Related

Modules & VBA :: Moving PDF Files To User Specific Folder

Feb 11, 2015

I'm Trying to move PDF Files associated with a customer to there specific folder

The query gathers the data, Gives me a list of files by account number

Now I want to use the results of the query to move those files

View 5 Replies View Related

How To Open A Dialog Box To Move Files Inside A Folder That Is Setup As Current Folder

Sep 2, 2015

I'm trying to automate a process of selecting a set of file/s and move them in a folder. When I click on a button, it should open a current folder that is setup in the code.

Lets say that I have a folder C:documents est, and very time I click on the button, it should open the dialog box with that path so I can select the files from another folder, drag them there and they will be saved in that folder.

This will form part of wider automation that will send an email stating that those file/s where placed in that folder.

I have in the same form where the button is placed, 3 check boxes that needs to be passed to the email as well that one or all the files where placed in the folder.

View 10 Replies View Related

Modules & VBA :: Merging All PDF Files In Particular Folder

Oct 25, 2014

I'm trying to write a simple little database. At one point on a form, I'm trying to merge all the pdf files in a particular folder. (I'm using the pdftke.exe program and there will be multiple pdf files)

It all works perfectly if I call it as below, with the actual paths already hard coded. It combines all the pdf files and renames it to the "merged filename.pdf" correctly

Dim stAppName1 As String
stAppName1 = "C:a folder namepdftk.exe C:another folder nameprints*.pdf cat output C:folder where merged file will bemerged filename.pdf"
Call Shell(stAppName1, 1)

However, I'm trying to have it work with the middle portion (the folder where all the pdf files are) being created on the fly so to speak.

The middle portion/path I have stored from a previous form and it's stored in a table.

So I'm trying the below, but doesn't seem to work.

Dim stAppName1 As String
Dim combine_files As String
combine_files = (this pulls a path from a stored field on the open form) + "" + CStr("*.pdf")

stAppName1 = "C:a folder namepdftk.exe (combine_files) cat output C:folder where merged file will bemerged filename.pdf"
Call Shell(stAppName1, 1)

With the code above, it doesn't seem to do anything.

View 2 Replies View Related

Modules & VBA :: Loop Through All Files In Folder?

Aug 26, 2014

I believe this is most recurring scenario for all. Any simple way like:

Code:
For each file in folder.files
Msgbox File.Name
Next File

For your information the above code doesn't work

View 10 Replies View Related

Modules & VBA :: Combine PDF Files In A Folder

Oct 21, 2013

I added to my database a button to ouput the data to PDF. It works as it should. We do print out the letters in paper and put a copy in the folder from the client (connected with the ID nr). From time to time we need to attach a PDF document to the letter and combine it. My question is now if it is possible to have some code to the button that when it finish the output to PDF it will combine all the PDF files that are in the folder and put it in a second folder. After that, I need to put the combined PDF in another folder.

View 6 Replies View Related

Copy From A Drive To A Folder

Feb 27, 2006

Hi.
I have been searching previous threads and the help file and got half way, but have got stuck.

I want to copy all files from a floppy disk to a drive on a directory on a server. I can check to make sure the directory exists and if not, can make it. All I want to do is copy all the files from the floppy disk drive (A drive) to the direcory I have just created.

I got this from the help in access:-

FileSystemObject.CopyFolder "c:mydocumentsletters*", "c: empfolder"

but can't get it to work......is this the way I want to go?

Can anyone help?

Thanks.

Frank.

View 3 Replies View Related

Modules & VBA :: Copy File From One Folder To Another

Feb 28, 2014

I need to create a function that I can launch using a macro that will copy an excel file from one folder to another in the file system.

View 4 Replies View Related

Modules & VBA :: Conditional Formatting With Files That Update In A Folder

Aug 20, 2013

I have a folder that .csv files which are connected to my database are updating in. Once the .csv that i specify updates I want a color box to turn green. Is there a way to do this? Maybe just use when the linked text file updates?

View 2 Replies View Related

Modules & VBA :: Delete A Folder To Include Subfolders And Files?

May 25, 2015

I need a way to delete a folder along with subfolders and files associated with a record via command on a form:

The path is stored in a text field "txtDocuments".

For example: "C:UsersWatsonDesktopFY1515051505-010"

So, I would want the code to pull the folder location from the txtDocuments text field and delete folder "1505-010" and all sub folders & files contained within it.

View 4 Replies View Related

General :: Copy Network Folder To Another Location And Rename It

Jul 17, 2013

I'm looking for copy folder functionality and I can't find anything.

In access 2007 when I push a button on a form, I want to copy a network folder to another location and rename it.

View 1 Replies View Related

General :: Copy A Folder To Location Selected By The User?

Sep 4, 2012

I have a folder with Access files, subfolders, and some .vbs files in it. It requires one person to navigate through a setup process. Once the setup is completed, they need to copy the folder and its contents to a location on a shared drive, which is unknown to me and will be chosen by the user at the site. There could be many sites.

It basically works like this:

Files are downloaded to C:Program Files.

A vbscript is run and extracts a folder directly to the C:Drive and opens it. I'll call it C:Test.

The user manually moves the BE file to a shared drive.

The user opens the FE file and is walked through using the Linked Table Manager.

The user then follows a series of forms to input data.

After this, the FE closes and another DB opens.

The second DB walks them through the Linked Table Manager and closes.

Option #1 At this point I would like to have a script and have it copy that folder, C:Test, and its contents, and have a dialog box open telling the user to paste it in a location where all users have access to.

Option #2 A script that will backup the folder and all its contents to a shared location selected by the user.

Either option will l allow others to navigate to that location, copy the folder, and paste the folder to their C: Drive.

View 2 Replies View Related

Forms :: Adding Links To Files Into A Field - Accessing Correct Folder

May 16, 2014

I have a code to add links to files into a field, I recently migrated from Windows 7 to 8 and the name of the folders in 8 are different; therefore the database I have does not find the linked file anylonger.

To avoid this happening in future, I would like to have the option for the user to set the folder path through maybe a table and then the link will refer to the settings in the table.

Currently I am using the following code:

Private Sub AddLinkDoc_Click()
Dim strFilter As String
Dim strInputFileName As String
Dim varDirectory As String
varDirectory = "C:UsersMarco TagliaferriDocumentsBA CityflyerCrew SchedulerDocumentationDocs"

[Code] ......

View 2 Replies View Related

Modules & VBA :: Access 2013 - Make Copy Of PDF Document In Specified Folder?

Apr 25, 2014

I need to make a copy of a pdf document that the user identifies in a "hidden" folder that is associated with my backend database. how to code this. I am using Access 2013.

View 6 Replies View Related

Modules & VBA :: Locate A Specific Folder In Access

Sep 4, 2013

In order to act as a system, I would like to have a function or windows firstly displayed all the folder names in a drive, and then allow user to locate/select freely a folder among different folders. Is there anything for my reference or for me to start??

View 4 Replies View Related

General :: Open A Specific Windows Folder

Aug 14, 2013

Open a specific Windows Folder.I am using this code to open a specific Windows folder ..... and it works perfect:

As String Dim folder
folder = "c: Documents WORD"
Dim Retval
Retval = Shell ("explorer.exe / e, / root," "" & folder & "" "", 1)

... but also need to open in the specified path, taking the data "UserName" of one field in a table:

TABLE: "Assignments" IDEExp, UserName, Date

So instead of going to the folder = "c:Documents WORD" would go to: c: Documents WORDUserName ". In Windows and subfolders are created with UserName1, 2,3,4, etc.

View 10 Replies View Related

Modules & VBA :: How To Take Screenshot And Save In A Specific Folder

Jul 25, 2014

how using vba i can take a screenshot of my screen and save the pdf or whatever form its in into a specific folder path.

View 1 Replies View Related

General :: How To Remove Specific Folder Rule

Oct 16, 2012

I have a specific access database that my customer have sent to me and it only works in a specific folder. I want to make it analyzed and worked in other folders but when I click, it turns out with a warning box that I should work with it in that folder.

View 1 Replies View Related

Forms :: Use A Hyperlink To Open A Folder Within A Specific Directory

Nov 26, 2014

I have 3 attachment boxes in my table that appears in a form.each attachment box contains specific files (not specific as in extension such as PDF, JPEG, etc.) but specific as in Company Documents, Certifications, Resumes. The issue is there's a lot of document and I see my database growing (fast)...My question finally is....

Can I use a Hyperlink to open a folder within a specific directory where multiple file are located so i can open the specific file need there RATHER than attaching them in the attachment box individually?.?.....If not how this can be done (no SQL) unless that route is very simple and basic coding.

My thinking would be to place the file path to the documents in the table and hyper link that column in the table, but not knowing exactly how Hyperlinks work I don't think it would actually work..

View 6 Replies View Related

Modules & VBA :: Saving Picture To Specific Folder With Customized Name?

Feb 8, 2014

I have below module to save picture under named folder:

Code:
Option Compare Database
Public Enum acFileType
acPicture = 1
acFiles = 2
End Enum

[Code] ....

But how to save the picture with customized name, say "Materials 0001.Jpg"

View 7 Replies View Related

General :: Save A File To A Specific Folder On Server

Feb 23, 2013

We have a server that we use to run a Microsoft Access application. This application creates folders, subfolders and files on the server.Users are in 4 different offices. Each office has at least 3 computers. Some users also work from home.

Users creates file through word, or scanning a document or by saving an email on their local pc.My problem is that users need to be able to save a file to a specific folder on server.

View 1 Replies View Related

Forms :: Copy Specific Fields From Selected Record To Specific Fields In Subform?

Jul 9, 2015

I am new to access i have a problem which is i have made a form which contains a subform and a read only subreport, what i want is the ability to select a record in read only subreport as in the picture attached and make a button that when i press on it, it should copy the values of the itemsID field, Packing field, ContainerNo field and origin field from the selected record and then paste them in the subform below.

Also i want to add more then one item, so the when i press on another record it should paste the values below the first record.

View 12 Replies View Related

Modules & VBA :: How To Open Treeview Node To A Specific Folder / Subfolder

Dec 18, 2014

I have a tree-view object that is filled with a specific folder list, when a command button is pressed I would like too expand to a specific node based on a variable/foldername.

How to achieve this? My knowledge of tree-view is limited and I am still learning VBA.

View 2 Replies View Related

Modules & VBA :: Run A Query And Export To Specific Folder As Excel File

Oct 13, 2014

In VBA I have set a timer on a form to run a query and export to a specific folder as an excel file.

If I open the database as 'File Open' and open the form and let the timer run it exports perfectly.

As soon as I put the database into runtime - the Timer code kicks in and starts running but as soon as it hits the export line. It stops and then does nothing

I have tried several combinations of either:

- docmd.runsavedimportexport "Query"
- docmd.outputTo acquery etc ...

View 3 Replies View Related

Modules & VBA :: Automate Scanning From Access To Specific Folder On Server

May 16, 2014

I have some code set up to automate scanning from access to a specific folder on the server. I have searched the web for different codes and have not come across anything that will scan an unknown amount of documents. The best I found was the code I am currently using, that will scan up to 10 documents separately, then convert these documents into 1 PDF. This is not ideal, however, because it would require the user to scan 1 document, wait, than scan another, wait, etc. Also, the code I am currently using will only scan from the glass, not the auto feeder, and I am unsure how to change this.

Private Sub cmdCOC_Click()
'scan COC
On Error GoTo Err_Handler
Const DEVNAME As String = "Brother MFC-7860DW LAN"
Dim ComDialog As WIA.CommonDialog

[Code] .....

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved