suggestions on sending forms

[seth]

I have a database where I would like to send a form to another person. I
can't seem to find the best way to go about it.
In excel, you can take a spreadsheet and send it to someone and it looks the
same in the mail message.
I would like to be able to do that also in access. I have tried to send to
as attachment through access but it doesn't work the same way.
If I select html format, it takes the entire form with all fields, etc and
creates a large table in html format and attaches it.
Same thing if I select rtf of xls. I am basically looking for a wysiwyg
format so in the mail message it can show the form the way it's formatted
with the current record.

any thoughts?
is this even possible?

 

[Rick B]

A form is an Access object used to enter data. If you want to send data to
a user, you would do so with a report.

Create a report that shows the data you want and send that through email.
You can even add a button to your form to do it for you. Make sure you
filter it to only pull the current record.

There are many previous posts that outline the specifics to accomplish these
tasks.

 

[Arvin Meyer [MVP]]

The only way to export live data without sending a database is to output to
an Excel spreadsheet or a text file. You can send the data in an image, but
that can't be used by other application.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[seth]

of course...use a report (duh!)

A form is an Access object used to enter data. If you want to send data to
a user, you would do so with a report.

Create a report that shows the data you want and send that through email.
You can even add a button to your form to do it for you. Make sure you
filter it to only pull the current record.

There are many previous posts that outline the specifics to accomplish
these tasks.