Hi,
I am using MS office 2007. I'am in process of making one automated VBA user form for multiple users (5) using split database for smooth data entry in common shared drive.
Problem: I want to populate data from shared access table to VBA form of each user by name & date automatically one after one once they click on "SAVE" till the time all actionable entries for each user is not finished.
Post clicking on "SAVE" button newly added user form entries will be sent to back-end database in common shared drive.
But I'am not able to find it any suitable code for this activity.
above idea is somewhat based on dialor concept we generally use in BPO companies for calling purpose. But in this idea call will be done through landline phone but details will be picked through VBA form..
Any guiding help will be highly appreciated.
Thanks in advance..!!!
Balvinder rayat
I am using MS office 2007. I'am in process of making one automated VBA user form for multiple users (5) using split database for smooth data entry in common shared drive.
Problem: I want to populate data from shared access table to VBA form of each user by name & date automatically one after one once they click on "SAVE" till the time all actionable entries for each user is not finished.
Post clicking on "SAVE" button newly added user form entries will be sent to back-end database in common shared drive.
But I'am not able to find it any suitable code for this activity.
above idea is somewhat based on dialor concept we generally use in BPO companies for calling purpose. But in this idea call will be done through landline phone but details will be picked through VBA form..
Any guiding help will be highly appreciated.
Thanks in advance..!!!
Balvinder rayat