I would like to have two different tools.
TO BE USED BY USERS
1 - A form to entry/update/delete data (form sample with all fields required in excel), with a search feature(search feature example in excel), the data must be written in mdb file. This tool must work on a simple usb disk without excel or access installed on pc. (multilanguage so that I can change the labels easily)
The tool must have a button to change the mdb file name according with the data in one form field and send it to email. (optional - only if not too expensive)
TO BE USED BY MASTER
2.1 - A tool to import all mdb files that will be in a subfolder, to one master mdb file.
This tool will have also the same search feature as tool 1, and must work on a simple usb disk without excel or access installed on pc. (multilanguage so that I can change the labels easily).
The tool must have a button to send the master mdb file to email. (optional - only if not too expensive)
TO BE USED BY SUB-MASTERS
2.2 - A tool to read the master mdb file with the same search feature as tool 1, and must work on a simple usb disk without excel or access installed on pc. (multilanguage so that I can change the labels easily).
This project is for a non profit organization to run a disaster emergency plan.
Attachments:
Form Fields Sample - When opened with excel with Macros enabled it will give you an error, that's because the form field names are duplicated... just open it with vba to see the form fields that must be present in the tool that will be produced.
Form Engine Sample - This is the file that is working (this sample as less form fields), that you can use to see how the tool should work, the button "Pesquisar" will open the search feature that I want for the project (this sample as less form fields).
Any doubt please PM me.