Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Simple File Routines Overwrite

Status
Not open for further replies.
SuperDuperNuker

SuperDuperNuker

Technical User
Apr 3, 2006
6
US
I need a query that automatically (without confirmation) copies FileA to a location where FileA already exists automatically overwriting the file that is there and without making a backup of it.
 
Sort by date Sort by votes
how does a query, copy a file??
anyhow, try FileCopy()
 
Upvote 0 Downvote
sorry, not a query.... a function or sub (VBA) that performs a copy from one location to another overwriting a file with the same name, without confirmation. Thanks....
 
Upvote 0 Downvote
strFile = "C:\Documents And Settings\...\DBase.mdb"
strCopiedFile = "C:\Documents And Settings\..\Desktop\DBaseII.mdb"

FileCopy(strFile,strCopiedFile)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
251
dhookom
dhookom
Moss100
  • Locked
  • Question
Access prompts "open or save" when I preview an excel file 1
Replies
1
Views
114
combo
combo
rdpress
  • Locked
  • Question
Question Open Shellling to File Explorer
Replies
3
Views
114
Andrzejek
Andrzejek
Aurillius
  • Locked
  • Question
Help with Unzipping a file and saving to a folder in Excel VBA
Replies
1
Views
224
Aurillius
Aurillius
AS Mughal
  • Locked
  • Question
Select Multiple Images and store their file path and image name in text fields of ms access table 1
Replies
7
Views
217
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top