General :: Copy A Pdf File Between 2 Directories
May 31, 2013
I am trying to copy a pdf file between 2 directories. I am using xCopy, When I build my copy statement based upon various parameters, it looks something like this:
xCopy C:PDF995OUTPUT*.* P:Billing1297344137.pdf /y
I might note that there is only one file in C:PDF995OUTPUT at a time. So I copy what is there, delete it and it is empty until the next usage.when it executes the statement, I get a DOS message asking whether what is being copied is a File or a Directory.How can I identify that without needing to respond to a message?
View Replies
ADVERTISEMENT
Dec 19, 2012
Got to the stage where I'm creating and accessing folders via my db.
Is there a number out there for what is deemed a sensible maximum number of subfolders in a folder?
View 2 Replies
View Related
Nov 26, 2012
Would it be ok just to make a copy of the BE file (every so often) rather than to make a copy via code?The user can then just paste over the original if it becomes corrupt.
View 4 Replies
View Related
Feb 19, 2013
I have to create a flat file to send to a group each month. The file type I create is M(a 7 digit number).(a three digit number), like M1234567.123. I create it as a text file and rename it from a field on a form. The field is in the last line of code below, WaiverFile.
START OF CODE
Dim NewFormName As String
DoCmd.TransferText acExportFixed, "WaiverFiles", "qryViewWaiverBilling",
"C:PSWaiverFilesPSWaiverFile.txt", False, ""
Dim stFileLoc As String stFileLoc = "C:PSWaiverFiles"
FileCopy stFileLoc & "PSWaiverFile.txt", stFileLoc & Forms!frmDailyLogOptions!WaiverFile
END OF CODE
I have a procedure that this is part of. The next thing I need after the code above is to copy this file, M1234567.123, or “M?.?”, to a folder on a mapped drive, that is T:PSWaiverFiles. I need to copy it as M*, so that I can get the file every time. I have tried several things, including:
START OF CODE
FileCopy “C:PSWaiverFilesM*”, “T:PSWaiverFiles”
END OF CODE
View 3 Replies
View Related
Feb 28, 2014
How can I overwrite the existing Access database with another Access database without the need for the end user to get involved in the process.
I want the code to copy a new mdb file over the database I am using (!) and then automatically start the new mdb file...
View 9 Replies
View Related
Aug 27, 2012
AUTOMATIC BACKUP FILE
I have a database that is updated every weekday, every hour. I make a copy of it end of the day so i do not lose that data so far. I wish there was was a way to make a backup copy, say end (once sometime) of the day, automatically.
View 3 Replies
View Related
Jun 4, 2013
I have an access 2007 database that is split front end and back end. There are about 15 users and the backend is stored on the network. Currently I am e-mailing out the FE when chagnes are made so they have the latest copy.
With everything I have read I think a bat file would work the best at allowing me to make changes on demand without having to continually email out new versions of the FE. Sometimes the changes are behind the scenes unnoticable to the user while others are obvious.
Questions: Exactly HOW does a bat file work? When the user clicks on the access file stored on their laptop? Where is the bat file stored? I am unfamiliar with where to write the bat file code as well - notepad perhaps?
I am not sure how to create a bat file and what the code should be?
For version tracking I need to put a version table in the BE and in the front end correct?
have made a few significant changes but I'm holding out e-mailing it if I can get this version copying figured out and in place first.
View 4 Replies
View Related
Aug 7, 2014
I have been trying to set up a batch file to allow users to copy the latest version of the front end whenever a change is made. The following is the code that I am trying to get to work properly. The first part works fine, the old front end is copied to a folder on the user's desktop as a backup. But I cannot get the copy of the server - the "P" drive, to overwrite the current copy on the user's desktop. Actually I cannot get the code to copy the new front end from the server and install it on the user's desktop. I think the path is correct for I seem to be able to run the new front end from the server.
When I look for the location on my computer, the server locations is listed as:
General (Servernamefiles) (P: ) (there is no space after the P: it seems to result in a smiley face when I type it and try to post it).
for /f "tokens=2-4 delims=/ " %%a in ('date /T') do set year=%%c
for /f "tokens=2-4 delims=/ " %%a in ('date /T') do set month=%%a
for /f "tokens=2-4 delims=/ " %%a in ('date /T') do set day=%%b
set TODAY=%year%-%month%-%day%
rem echo %TODAY%
[Code] .....
This code works so I thought that the path was correct
rem this works
rem start the new DB front end
Start P:AccessMainSplitBENewFrontEndDBMain.accdb
But this code does not.
echo f | xcopy /f/y/ P:AccessMainSplitBENewFrontEndDBMain.accdb c:UsersUserNameDesktopDBMain.accdb
Neither does this:
echo f | xcopy /f/y/ ServerNamefilesP:AccessMainSplitBENewFrontEn dDBMain.accdb c:UsersUserNameDesktopDBMain.accdb
View 2 Replies
View Related
Jun 15, 2006
Hi All.
I have searched forums......honest!! But cannot find an answer.
I have the following code to make a directory....the directory name is as the ID_number....
---------------------------------------------------
Private Sub Command216_Click()
Dim strDirectoryPath1 As String
strDirectoryPath1 = "\server1Helpdesk_Calls" + CStr(Me.ID_Number)
If Len(Dir$(strDirectoryPath1 & ".", vbDirectory)) <> 0 Then
MsgBox "The project folder already exists, the folder will now open"
stAppName = "C:Windowsexplorer.exe \server1Helpdesk_Calls" + CStr(Me.ID_Number)
Call Shell(stAppName, 1)
Else
MkDir (strDirectoryPath1)
MsgBox "A folder has been created on the network at location \Server1Helpdesk_Calls" + CStr(Me.ID_Number)
stAppName = "C:Windowsexplorer.exe \Server1Helpdesk_Calls" + CStr(Me.ID_Number)
Call Shell(stAppName, 1)
End If
End Sub
------------------------------------------------
This works fine, and makes a directory on the network drive i.e
\server1helpdesk_calls123456
My question is, how do I also make it create directories under this one i.e
\server1helpdesk_calls123456Emails
It is the ID_number that is throwing me....have tried with numerous goes!!
Many Thanks.
Frank.
View 2 Replies
View Related
Jan 20, 2006
From a command button what would be the code to copy a file from one location to another i.e copy c:datasalesdata.mdb to e:databackupsalesdata.mdb
Jabez
View 1 Replies
View Related
Jun 17, 2005
Hi all,
I've set up security on my database before with great success, and now I'd like to use the same workgroup file (a copy with a new name and location) to secure a nes db.
I open the new db, and join my earlier created mdw file. I'm prompted with that I have joined my workgroupfile.
I then set permissions for each user in the workgroupfile, remove admin rights for the admin user account, and assign admin rights to my own account. I am also the owner of thr db.
I now run the security wizard, and I make no changes to any checkboxes.
This goes nicely, and the wizard closes after making a backup file.
I now want to re-join the system.mdw file, so I don't get prompted with the logon dialog when opening a new db or an unsecured db.
If I now try to start my new secured db by double-clicking on the secured mdb file it opens ?????
Where am I going wrong?
Thanks in advance for any help.
View 6 Replies
View Related
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
Jan 8, 2014
How can copy table from another mdb file in current opened mdb file? If copy table is exist in current file table will be replaced.
View 7 Replies
View Related
Aug 31, 2012
I'm new user for access 2010, what i need is to copy some data to a text file from a form?
For example: I have a form have 3 fields, id, user & password;
What I need is to generate a text file for the user field?
View 5 Replies
View Related
Mar 31, 2015
All I need to do is copy an excel file from a location (while coping the file, the location of the source file remains same all the time)and paste that excel file where ever I want (Browser Option) from an Access VBA.
View 4 Replies
View Related
Dec 22, 2014
Is it possible in access, to create a button that will copy a file to a new directory? Specifically, the data field in question is an access hyperlink that we can click on to open a PDF drawing of a part. I just want to copy the file the hyperlink points to, into a new directory.
EX:
X:database/drawings/somefile.pdf
X:erp/drawings/somefile.pdf
I don't think a macro can do this, but perhaps vbscript can.
View 2 Replies
View Related
Apr 28, 2015
How easy it is to add a button to a form with a function to copy a zipped file to another location and unzip it?
View 10 Replies
View Related
Jul 27, 2007
This forum is really helpful!
I am using following code to copy low value from Access table to excel file, but only to find that it changed in excel file. How should I do to not change that?
ThisWorkbook.Sheets("EV Data").Cells(row + 2, col + 2) = _
rs.Fields(col).Value
RecordIDDateTimeStampSetupIDStringBaseProductIDStringMGDBIDStringVAGLBIDStringPWDCohortIssueAge1IssueAge2NumberOfCellsNumberOfScenariosTotalWeightInitialPremiumEV_MeanEV_P995EV_P99EV_P95EV_P90EV_P75EV_P50EV_P25EV_P10PrEVGTZero
51907/27/2007 7:04:36 PMAccess2006Max72006MGIBAllCombinedAllCombinedAllCombined95010.006800000006810000009.33604218011769E-03-2.48487734766947E-02-2.35810657931309E-02-1.44083677074442E-02-1.10775676515645E-02-2.1878002261516E-037.92060932296671E-031.95193525290664E-023.06835072412068E-020.70658682634731
52007/27/2007 7:04:37 PMAccess2006Max7LifePayIAllCombinedAllCombinedAllCombined185010.005110000001.19424841908013E-02-1.67115163990304E-02-1.42187111112351E-02-8.08910871821918E-03-4.62961276311795E-032.72200376166994E-031.04312882683217E-022.06668892126601E-022.96649979111015E-020.80638722554891
52107/27/2007 7:04:37 PMAccess2006Max7NoneAllCombinedAllCombinedAllCombined95010.0054410000007.98908918707603E-03-1.67789382388317E-02-1.56490361783179E-02-1.07703746693193E-02-0.00753365556878-7.10709517675212E-046.72111941423526E-031.59418102675589E-022.44078788510759E-020.730538922155694
52207/27/2007 7:04:37 PMAccessRat2006MGIBAllCombinedAllCombinedAllCombined95010.0030199999969810000009.52176602967384E-03-1.56233866973614E-02-1.49901562045925E-02-8.41152147122661E-03-5.44762510232609E-034.05576508882054E-047.33588282834675E-030.0164686012768352.61950530898991E-020.754491017964078
52307/27/2007 7:04:37 PMAccessRatLifePayIAllCombinedAllCombinedAllCombined185010.00226499999773510000001.06805510377118E-02-0.014626108301625-1.20428523073918E-02-6.08984658852046E-03-2.22851888030373E-034.04428276871694E-039.82402795120803E-031.68655595406923E-022.40410662469335E-020.856287425149709
52407/27/2007 7:04:37 PMAccessRatNoneAllCombinedAllCombinedAllCombined95010.00241599999516810000005.8666292477999E-03-1.13844546795139E-02-1.04027261898336E-02-6.72766534794549E-03-4.77103336054974E-03-3.11542830732602E-044.5158867397345E-031.06654135236169E-021.76803347713142E-020.730538922155694
View 7 Replies
View Related
Apr 18, 2014
I have a folder which holds 1000s of pictures organised in subfolders, for example:
D:~AI Database Print Scans2009family and
D:~AI Database Print Scans2009holiday
And so forth. In total at the moment 17 main subfolders, each of which hold another 2-3 subfolders.
I am putting together a database to bring pictures together with all sorts of details. I import the picture via hyperlink and complete the various fields. All that works fine but there are a lot of pictures! And it gets confusing to see which ones have already been entered into the database and which ones haven’t.
One solution for this is to copy the pictures that have been “completed” to another folder. I have found a way to do that:
Dim fs As Object
Dim oldPath As String, newPath As String
oldPath = Forms!frmPrintDetails.txtPath1
newPath = "D:~AI Database Print ScansCompleted_Entries"
Set fs = CreateObject("Scripting.FileSystemObject")
fs.CopyFile oldPath, newPath
Set fs = Nothing
Works fine, but the problem is that I loose the subfolder structure, it copies all pictures to the same main folder. I’d like to maintain the subfolder structure and add code to create the correct subfolders and next copy the picture. With the different paths I’m lost. I don’t know how to extract the correct path in code. I’d also like to either rename or remove the picture once I have completed entry of the details. The problem I have again is that I don’t know how to code for a changing path.
View 12 Replies
View Related
Mar 11, 2014
I often create contract using mail merge. I have an access file that I want to use as data source for word file. But it does not automatically.
Please download the attached file !
If there are 1 customer and 1 property, I do not need to do anything. Conversely, if there are many customers and many properties, I take time to manipulate.
Firstly, I open the word file. I have to copy and paste paragraphs that I want. Highlight of the original paragraphs is blue.
Secondly, I click 'Insert Word Field' -> select 'Next Record'.
In short, I wish to use VBA in access file to automatically perform the steps that I have outlined.
View 3 Replies
View Related
Oct 5, 2014
I've got the forms and queries in one .accdb file and my tables in a separate .accdb file. The forms file links to the tables in the tables file. The tables file resides in a folder called simply enough C:acc_tables and thats where i browsed to (obviously) when i set up the linkage.
One of the users does not wish (for whatever goddamn reason) to create a C:acc_tables file to stick the tables file in , and wants the tables file in some other folder.. Unfortunately this user does not have the skills to delete the existing links and re-link to the tables file after putting it in the folder he wants.
Where in the file that holds the forms and and queries do i find the path setting to the tables linked file? Can it be changed without deleting links and then re-linking?
View 4 Replies
View Related
Jan 5, 2014
I am still trying to copy an Excel file from a parent folder to a sub-folder, that this code creates, and name the copied file with the name used to name the sub-folder, using the name entered in a control field (named 'TheDirName) of an Access 2007 form. Here is my VBA, which names the copied file "TheDirName.xlsx.:
Private Sub MakeDir_Click()
Dim appExcel As Excel.Application
Dim lngLastDataRow As Long
Dim Folder_Path As String
'Create path for customer folder & files
[code]....
View 3 Replies
View Related
Jul 11, 2013
I need some simple code that will copy an Excel file or a table in Access to a specific location on an FTP server. I would think this would be a very simple task, but I have yet to find any sample code that is *simple*. I have seen lots of code that requires downloading this dll or that mda, but the examples don't work. There must be something built into MS Access 2010 that will allow a file to be uploaded to an FTP site.
All the variables are known:
The FTP location (it never changes)
The FTP Username and Password (they never change)
The destination folder on the FTP site (it never changes)
The File type (it never changes)
The File name (available from the form in Access from which this will be executed)
I can either produce an output file, then copy it to the FTP site, or I can export the table directly to the FTP site with the file name for that day.
This seems to be a very simple task with no simple solution. Currently I am using an FTP app to get the file to the FTP site, but I would like to automate this. The process that creates the output file is already automated, so I would just like to add this to the existing code as its own module.
I'm looking for a simple command on the idea of:
DoCmd.FTPFile, acExel, TableName, FTPFilePath, FTPFileName, Username, Password, acUpload
just made all that above up and none of it is a real function/command in VBA, but is just the kind of thing I'm looking for.
I would think that since I can download and XML file from an FTP site that it should be child's play to upload a simple file to an FTP site, but I can't figure it out.
View 8 Replies
View Related
Sep 10, 2012
How do I make an accdr file out of an accde file?
View 9 Replies
View Related
Sep 6, 2012
Is it possible to follow a hyperlink to a file without using a file extension?
I have links being created based on the name of a file, but because I haven't used a file extension it crashes.
I know I can give the user a choice of what the file extension is and add it to the hyperlink, but it's an extra step, and another place for someone to make a mistake.
I'm potentially using 3 different file types, Word, Excel and PDF's.
The hyperlink works if I just reference a drive/folder, or if I add the file extension.
View 3 Replies
View Related
Aug 28, 2012
I use a batch file to distribute the front end of a database application. Currently, everytime the user clicks the shortcut on her desktop, the batch file executes and copies the front end from a network location to user's local machine. The FE is updated like every couple of days. The users run the database more frequently.
I would like to modify the batch file so that it checks some attribute of the FE file to decide whether it needs to be updated. I can't rely on file size, since the FE includes temporary tables. I essentially need something like the "tag" property of form controls, only for files. It would be ideal if it was me who sets this property, like "version number". Except it has read without opening the file itself.
View 14 Replies
View Related