Check boxes and email

[Lxmanager]

Hi guys, I'm new to this site and to Access programming so please be gentle with me.. I have a couple of questions, well actually I have dozens of them but a couple will do for now.



I am creating an Access database in work to record and analyze inspection data. So far I have created the necessary tables, forms and some reports/queries.

The problem I am having is on the main form, I have created the form so the inspection can enter the required data to be stored within a table. On the bottom of the form I have departmental people who the form has to be given, at the moment I have check boxes against each one so when clicked enters the word yes in the table and enters it within the field on the report. What I have been asked is can I add say a button on the form so as when the operator has checked the required names on the form he can click on the button and the form or associated report will be sent to Microsoft outlook as an attachment with the email addresses already in the send to field of the email. if it is possible could someone please explain how to do it and possibly show me the VBA code to go with it.

My second problem is on the same form I have created a button to send the form to a record, hopefully to show it in print preview ready for printing. It does that but the report has all the records created whereas I only want the one that was open in the form i.e. if record 105 was open in the form I only want that one in the report stopping the chance of accidently printing all 105 records. How do I achieve this.

Sorry my first post has been so long winded, my Access design is basic and my VBA programming is none existent, but I am learning.

Thanks for your help in advance.

Andy

[ajetrumpet]

Here is the way MS views the task: http://support.microsoft.com/kb/161088

The code can pretty much be copied verbatim from that site and used in any office program. Give it a whirl and see how you get on.

As a side note, your table might be a little too big if all of the info you've mentioned is on the same form, which is bound to the same table. If you can, try splitting up your data based on information groups and JOIN them together in a query. That's the purpose of Access.