<div>
Cheers and hurrahs John! &nbsp;Made my memorial day. &nbsp;Might get to eat some burgers and dogs after all! &nbsp;Appreciate your quick and brilliant response!!!
</div>


Cheers and hurrahs John!  Made my memorial day.  Might get to eat some burgers and dogs after all!  Appreciate your quick and brilliant response!!!

<div>
You're very welcome, have a great day!
</div>


<div>
<div class="content wysiwyg-content">
I have a hyperlink field in a table. &nbsp;I want to be able to COPY the referenced hyperlinked file to a NEW Folder, and leave the old folder and file intact. &nbsp;I can update the hyperlink reference in the table once it is moved to a new folder. &nbsp;This is not a one time move. &nbsp;It will occur many times per day. &nbsp;I have a field in my current table that indicates whether the item has been moved already. &nbsp;<br />
<br />
I would like to run a query that indicates those items that have not been copied to the new folder, then run some code that would allow the files to be copied all at once. &nbsp;They are all moving to a single folder, so there is no guesswork:<br />
<br />
\\crsql\BossAttachments\Ne<wbr />wAttachmen<wbr />ts\*.*<br />
<br />
Any help to make this as easy as possible would be appreciated
</div>
</div>


I have a hyperlink field in a table.  I want to be able to COPY the referenced hyperlinked file to a NEW Folder, and leave the old folder and file intact.  I can update the hyperlink reference in the table once it is moved to a new folder.  This is not a one time move.  It will occur many times per day.  I have a field in my current table that indicates whether the item has been moved already.  

I would like to run a query that indicates those items that have not been copied to the new folder, then run some code that would allow the files to be copied all at once.  They are all moving to a single folder, so there is no guesswork:

\\crsql\BossAttachments\NewAttachments\*.*

Any help to make this as easy as possible would be appreciated

Access 2007 Hyperlink Field in Table - Copy document to new folder

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.