I need create an Access Macro that will copy folders and files from a server to a directory on tablet attached to the local workstation. \\oiclx\public\tabletsync e:\. I can either execute this from a macro, use vba from command button, run a batch file--which ever is best and least complicated but reliable. Thank you.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder.
But why not let Windows retr…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …