Emailing Forms

J

Jay

Could anyone please tell me how to produce a snapshot view of a form so that
I can email it. I can do it for a report but not a form.

Many thanks

JM
 
R

Rick Brandt

Jay said:
Could anyone please tell me how to produce a snapshot view of a form
so that I can email it. I can do it for a report but not a form.

Many thanks

JM
Click to expand...

Easiest way (IMO) is to temporarily change the Popup property of the form to
True (if not already set that way), then open the form and press
<Alt-PrtScrn>. That will copy the image of the form to your clipboard which
you can then paste into a mail message. Without the Popup property set
<Alt-PrtScrn> will capture the entire Access window instead of just the
form.

If you need to do this regularly as part of your application (strange
requirement) then you might have to build a report that has the same
appearance as your form. Just right-click and choose "Save As Report".
 
J

Jay

Hi Rick,

I tried both solutions, but neither are suitable. Converting the form to a
report so that I can e-mail using snapshot was a good idea, but the form is a
data input form, and thus currently has 8k records. I only want to e-mail one
specific record at a time.

The other solution of grabbing a copy of the screen works, but as you
said,is only a temporary measure.

The output to e-mail that I need, is the same as if I had selected a single
record and printed it. Previously we faxed this print, but the powers that be
have decided that they want these e-mailed not faxed as we send about 30 to
40 a day.

Do you have any other ideas.

Kind regards

JM
 
R

Ryan

I have the same problem. I have an SQL database linked to ACCESS front ends.
I have Project Managers around the country filling out forms. Again, I need a
single record emailed to a particular person. I figured out how to email the
form, but the subform that goes with it does not get included.

To do the form itself, I made a command button to email a report (any
report). Then, in Design view, I went to the button's properties, then to
Event. From there, I went to the Code builder for the "On Click" event and
changed the name of the report to the name of the form and "acReport" to
"acForm" and it worked. However, the subform wasnt included in the email.
 
Top