K
Kiran
Hi
I am an average user on msaccess, but now am venturing into automation using
VBA. My first pet project is listed below; any assistance will be much
appreciated.
I currently have a database table with the following fields:
Field 1 - Account number (alphanumeric) PRIMARY KEY
Field 2 - Managers Name (Text)
Field 3 - Balance on account (numbers)
Field 4 - Managers response
I have 130 Managers, who can have a number of account numbers ranging from 2
to a maximum of 45 (depending on seniority) assigned to their responsibility.
Well, I need to export the records for each specific manager into their own
specific msexcel workbook in their name for their review and each manager
will put into the response column of excel workbook their response, which
will be returned to me and uploaded into field 4 from the excel workbook.
This will obviously be done via email.
Thanking you for your kind assistance.
I am an average user on msaccess, but now am venturing into automation using
VBA. My first pet project is listed below; any assistance will be much
appreciated.
I currently have a database table with the following fields:
Field 1 - Account number (alphanumeric) PRIMARY KEY
Field 2 - Managers Name (Text)
Field 3 - Balance on account (numbers)
Field 4 - Managers response
I have 130 Managers, who can have a number of account numbers ranging from 2
to a maximum of 45 (depending on seniority) assigned to their responsibility.
Well, I need to export the records for each specific manager into their own
specific msexcel workbook in their name for their review and each manager
will put into the response column of excel workbook their response, which
will be returned to me and uploaded into field 4 from the excel workbook.
This will obviously be done via email.
Thanking you for your kind assistance.