Completed

MS ACCESS AUTO RENAME AND MOVE FILES

We are looking partner Freelancer to develop MACRO/VBA Code Button to use in MS ACCESS TABLES to rename and move files into a target folder about attachments existing inside MS ACCESS table,

We would like to have a VBA OR MACRO OR ADDINS solution

when we save our MS access tables,

the documents enclosed in attachment column of that Access table will be copied into a new directory folder with their new names generated automatically.

Documents will be saved by auto-naming such a name-string generated from values of table fields...

Following points will be important when the VBA/MACRO/ADDINS developing by freelancer,

1- Document attach steps will be as usual in MS ACCESS without any change,

one column in table will be attachment column and The attachments might be search and selected from anywhere on PC through pop-up file explorer as usual in Access, The freelancer's code start after that.....

2- all the attached files/documents existing in table will save in a folder set by USER, one Directory's foldet for one table.

Thus every table will have it's own Documents Folder in local drive carrying documents renamed by table values.

3- In every MS ACCESS session user might change or not change target Folder where table files saved,

Thus user, might create a querry table and save that filtered new table or create a new shorter table's which the attachments will be available belong another Folder basis on new table criterions.

4- In each table attachment's auto-name-string generation method would be set by User such about selection of columns. which field's value will be used at which order, in a name string generation.

Thus user will be flexible to select different field's to be used in different order for different tables,

Table A might use field's of [login to view URL] as name while Table B might use [login to view URL] as name at the time of auto-generating file names.

5- Files re-name operation in the table will not be valid only for new added rows and leave older ones,

That rename operation must be valid for older rows for the total of table,

Thus if any change made in older values of some fields in the table, those will be reflected and corrected on attachments' name string too...

Skills: Microsoft Access, Visual Basic, Office Add-ins, Microsoft Office, C Programming

See more: convert exe files database ms access, automation expert excel vba and ms access kerala, ms access vba and finance linkedin profile india, software to record sales and calculate profit & loss on ms access, software to record sales and calculate profit loss on ms access, ms access and sql expert freelance, looking for ms access freelance, ms excel and ms access consulting brisbane city services for hire computer telecom freelance, rename and move/copy script/windows, monitor folder and move files automatically, how to prevent direct access to css and js files, why do apps need access to photos and media files, ms access 2016 charts and graphs, batch file create folder and move files, find and move files windows, powershell monitor folder and move files, powershell script to zip and move files, ms access exam questions and answers pdf, how to copy and move files in bash, how permissions are handled when you copy and move files and folders

About the Employer:
( 0 reviews ) Turkey

Project ID: #30195039

Awarded to:

(19 Reviews)
5.3

18 freelancers are bidding on average $281 for this job

(237 Reviews)
8.0
(295 Reviews)
7.8
Prashantskin

[login to view URL] I have gone through your project requirements. I have understood the whole process. I will make all the requirements in your access application .. My ratings and reviews will give you confidence in me Pleas More

$180 USD in 7 days
(498 Reviews)
7.2
(62 Reviews)
6.4
(68 Reviews)
5.6
(18 Reviews)
4.6
(25 Reviews)
4.4
Saimi786

Hello Thanks for your posting. I am a senior developer so i can do it very easily if you want.I’ve read your job description carefully and I am very interested in your project. I am sure that I can finish this project More

$140 USD in 7 days
(15 Reviews)
3.9
(2 Reviews)
3.9
(13 Reviews)
3.8
ahteixeira

Hi My name is Alvaro from Portugal, I have more than 20 years of experience in MS Access and VBA. I am global moderator (ahteixeira) of the largest Portuguese language Ms Access forum ([login to view URL]), if you want More

$1667 USD in 25 days
(2 Reviews)
1.3
EyepanEkal

Hi, I am Dennis. I am skilled in Ms office packages and I can get the job done for you. I am also skilled in Access Macros and I can implement your specifications for you. In addition, I will consolidate all the More

$50 USD in 2 days
(0 Reviews)
0.0
RamiJb

i already have this file available i can share it with you. you can transfer - rename - delete files

$167 USD in 1 day
(0 Reviews)
0.0
Mendez61187

I see your project that I should use API and different libraries in order to manage the files and rename them with a string.

$250 USD in 5 days
(0 Reviews)
0.0
leiyonz

Leave a message then I can show you some result within few hours Please check my work below for consideration: [login to view URL] I am quite familiar with: Data Warehouse | ETL | Business Intelligence | Analytics | More

$185 USD in 5 days
(0 Reviews)
0.0
vipin0110

Greeting! My name is Vipin Kumar Garg and I am a software engineer and qualification is Master of Computer Application (MCA). I have 20+ Yrs. Exp. in MS Excel VBA (Macro) and MS Access, I have worked in MNC companies a More

$140 USD in 7 days
(0 Reviews)
0.0
hortonchelsean

Ready and willing to work. I have administrative assistant and data entry experience. Anything I don’t know I can learn and pick up fast. Thank you for your consideration.

$130 USD in 7 days
(0 Reviews)
0.0