i am a novice when it comes to Reports in MS Access. with that said, i was hoping i could get some help on something i would like to accomplish. i currently have a database comprised of many records within a table. these records in the table are tasks that need to be completed by people (we will call them "employees") throughout the day. each task is assigned to a to "employee" (each "employee" may have multiple tasks assigned to them). with that said, the users of this database will be monitoring the "employees" who need to complete their tasks for the day. each user will be responsible for multiple "employees". at the end of the work day the users will need to report the progress made by the "employees". what i would like to do is to create a command button within a form that will direct the users to a separate form, allow them to select the "employees" they would like to report on from a list box ('Ctrl + A' selections are preferred), and after they have made their selection they will click on yet another command button, which will generate a report based on those selections and will also give them the opportunity to email that report to a pre-selected email address with the subject line being automatically generated based on the selections they had made in the previous form. i would like to go even more in depth with this request, but for now i will stop there as i believe already i may be asking too much. any help would be appreciated. thanks.
Emailing Report
- Thread starter SoxPats83
- Start date
Trevor G
Registered User.
- Local time
- Today, 14:32
- Joined
- Oct 1, 2009
- Messages
- 2,364
Look at one of my previous threads which I have created a database to send out emails, based on a query value. This should give you a start point.
http://www.access-programmers.co.uk/forums/showthread.php?t=192890
Read the thread carefully as it gives you some detail about the Yes/No options when sending an email from access.
You can then create your form with a list box that is populated and when you select from the list box it can then generate the emails.
I hope this may help you and that I haven't missed the point to much.!.
http://www.access-programmers.co.uk/forums/showthread.php?t=192890
Read the thread carefully as it gives you some detail about the Yes/No options when sending an email from access.
You can then create your form with a list box that is populated and when you select from the list box it can then generate the emails.
I hope this may help you and that I haven't missed the point to much.!.
Similar threads
Solved
Email Report
- Question