K
Kevin
Simply, yes!
The easiest way is to create your form so that it is bound
to the table in question. There is a wizard to help you
get this done, but you will probably want to fine tune the
layout as the wizards output, quite often, does not look
that great. Then create a query that pulls information
from your table. You can have the result of the query then
present just the selected record on the form by putting
criteria in the query for at least one of the fields in
the query that is tied back to your form. The next step is
to create your report. The source for the information on
the report should be your query. Again, there are wizards
to help with this, but the look might need some help after
the wizard is done. Lastly, create a button and put it on
the form. In the onclick event put the following vba code:
DoCmd.SendObject acReport, "your report name", "HTML
(*.html)", emailaddress, "", "", "email subject", "",
False, ""
The email address can either be hard coded(i.e.
(e-mail address removed)), or set programatically.
I hope this helps!
Kevin
The easiest way is to create your form so that it is bound
to the table in question. There is a wizard to help you
get this done, but you will probably want to fine tune the
layout as the wizards output, quite often, does not look
that great. Then create a query that pulls information
from your table. You can have the result of the query then
present just the selected record on the form by putting
criteria in the query for at least one of the fields in
the query that is tied back to your form. The next step is
to create your report. The source for the information on
the report should be your query. Again, there are wizards
to help with this, but the look might need some help after
the wizard is done. Lastly, create a button and put it on
the form. In the onclick event put the following vba code:
DoCmd.SendObject acReport, "your report name", "HTML
(*.html)", emailaddress, "", "", "email subject", "",
False, ""
The email address can either be hard coded(i.e.
(e-mail address removed)), or set programatically.
I hope this helps!
Kevin