Please message me in ASAP for copy of database / further details and bid accordingly.
Notes on functionality of database-
All emails (email1, email2, email3, email4, email5) are pooled together to verify all emails are unique.
All phones (phone1, phone2, phone3) are pooled together to verify all phone numbers are unique.
All websites (website1, website2, website3, website4, website5) are pooled together to verify all website are unique.
LIST OF CURRENT ISSUES / MODIFICATIONS NEEDED ; (This is a start with plenty more)
Recently a button (Show Duplicates) has been added to form “frmLeads” to show conflicting duplicate records (email, phone, website) to easily display and correct conflicts and or delete duplicate record. Current issue. If you try to delete one of the records you receive errors (Error message Run-time error 3022 [url removed, login to view] sSQL, dbFailOnError) . If you try to delete or modify the conflicting field you receive an error.
Reports form. “LeadsWebQRpt_Filter” does not correctly work. Selecting only one DH field properly shows results but if you select more than one DH field or all DH fields no results show.
User currently can receive an error message “ok or debug” and it allows them to disable the macro running and can continue using database. This need to close the workbook as rights are controlled by macro. Need to lock the system before distribution.
Convert to client button on form “frmLeads” does not work properly. Every field properly is moved to tblClients except “Address Street 1”. All other fields correctly transfer.
Add search box to bottom or top ribbon similar to CTRL+F with the ability to select next & previous matching record. SEARCH ALL FIELDS WITHIN SYSTEM (tblLeads & tblClients)
Add Query Wizard button to top ribbon for Admin users.
34 freelance ont fait une offre moyenne de 1262 $ pour ce travail
Respected Sir / Madam i have the skills and experience of working with MS Access / VBA etc, can update your application Start Immediately. Kindly send me database and details Warm regards vnb400
Dear, we are Team of French + US. 11 years experience on Access/Excel/VBA automations. - Could you send me your Db file ? As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice