LarryDavidow
Technical User
I have a form that is similar to the Employees Form in the Northwind Sample Database (Access 2002).
Basically, you can add and remove various images to and from the form.
I would like to add the following. Double-click the image, and a new message in Outlook is created with the image as an attachment. If you leave the New Message open and go back to the database, select another record and double click on that image, it then inserts that image as an attachment into the same message as the first.
Second prize, I guess, would be to add a numeric field to the table which has a checkbox control on the form. You would scroll through the records and select the "Employees" you want to email pictures of and then have a query run with [checkbox]=-1. I would still need to know how to take those image paths and have the images inserted into an email. I would also need something to reset the [checkbox] field of all the records back to 0.
Any help or direction would be greatly appreciated!!
Basically, you can add and remove various images to and from the form.
I would like to add the following. Double-click the image, and a new message in Outlook is created with the image as an attachment. If you leave the New Message open and go back to the database, select another record and double click on that image, it then inserts that image as an attachment into the same message as the first.
Second prize, I guess, would be to add a numeric field to the table which has a checkbox control on the form. You would scroll through the records and select the "Employees" you want to email pictures of and then have a query run with [checkbox]=-1. I would still need to know how to take those image paths and have the images inserted into an email. I would also need something to reset the [checkbox] field of all the records back to 0.
Any help or direction would be greatly appreciated!!