Access Form with Email Alerts -- 2

Замовник: AI | Опубліковано: 06.10.2025

I need a single-file Microsoft Access solution that lets regular users log in with their own passwords, fill out a data-entry form, attach photos directly from their local device, and submit. As the owner, I log in as Admin; every time a user clicks Submit I should automatically receive an email notification so I can track new entries in real time. The database must open to a secure login screen that distinguishes between Admin and standard User accounts. After authentication, Users see only the form, while my Admin view lets me review, edit or export the submitted records. I would like the form interface to look clean and a bit creative, so space for a small banner or logo image would be helpful. Photo handling is essential: the form should let Users browse their computer, pick one or more images, and store them with the record—ideally saved in the back-end table or as file paths, whichever you recommend for keeping the file size reasonable. Email alerts can be handled through Access VBA with Outlook or another reliable method you propose, provided it sends a succinct message containing the submitter’s name and time stamp immediately after the record is written. Once we agree on the exact text and numeric fields I need—name, contact details, and a few others—the job is to build, test, and deliver the finished .accdb file with all VBA code unlocked so I can maintain it later. A brief hand-over note explaining how to add more fields, reset passwords, and change the email address for alerts will complete the project.