Is it possible to email a FORM in snapshot format?

[MsLady]

Is it possible to email as attachment a FORM in snapshot format?
I have a form that gets the results of a query. I'd like to send the data displayed on this form as snapshot format. Possible? Any alternatives? Suggestions? Please help, i've looked high and low.

 

[CEH]

Why email a form? Why not put the same results from the same query into a report and easily email that in snapshot format.

 

[MsLady]

Thanks Curtis.
See, there are other controls on the form, like print, and a details button right beside each record that opens up the mainform containing the information of that particular record. I'd only like to have a snapshot of the results form.

Is there a way?

 

[Wilfy06]

Totally agree with CEH, i used to run the reports at old job and then very easy to send from there, file sendto, as attachment, Snapshot Format, Good Luck!!

 

[MsLady]

So i guess it's not possible to email a snapshot or view of data on my form

 

[Banana]

Wouldn't a screen dump do the job?

 

[KenHigg]

Can't you get docmd.sendobject to utilize the acFormatSNP output option?

 

[MsLady]

Wouldn't a screen dump do the job?

Hi Banana, what do you mean by "screen dump"?

 

[MsLady]

Can't you get docmd.sendobject to utilize the acFormatSNP output option?

Apparently i can't use this, as *.snp is not available in the format types of forms. It looks like only reports can do snapshot

I was just reading somewhere that i can print my form to pdf and attach to email. I guess i should go do more research on that. If anyone has any knowledge of this, please share. thanks all

or better yet, if anyone has any idea how i can get and attach a shot of the data displayed on my form to an email (i really don't care which format as long as it attaches and is viewable) i'd really appreciate it!

 

[KenHigg]

Why don't you simply do a report to send?

 

[Banana]

Screen dump:

get that form on your screen. Makes sure it's in front and is uncluttered.

Press "Print Screen" key which is just above the "Insert" key and right of F12 key.

Go to MS Paint (Start -> All Programs -> Accesories -> Paint)

Paste into the blank space.

You now have the full screen. You then can re-select just the form itself and save just that without the rest of screen. It's now ready to be emailed as JPG, PNG, or whatever format you like. SNP isn't one of them, though.

 

[MsLady]

Why don't you simply do a report to send?

This same form opens up with different criteria.
The same form opens up "Pending jobs", "Completed Jobs", "Past due Jobs", "At risk jobs" depending on what button is clicked on my mainmenu etc. The form opens up with a different caption and different background based on the data on it all done programmatically. I have an email button on this form, and i'll like it to email as attachment whatever data is displayed when that form is opened.


So let's say i click the "Pending Jobs" button, and it brings up this form with "Pending data", i'll like to click that email button i have on it to email a snapshot/picture/view of the Pending Jobs to my boss!

If i have to create a report for each of this form, that's gonna be a lot of work. I cannot make this form a report cos of the onclick buttons i have on there. The details button opens up the whole detail of the job

Here's a screenshot on the form.

Please help me, i'll love you forever!

 

[MsLady]

Screen dump:

get that form on your screen. Makes sure it's in front and is uncluttered.

Press "Print Screen" key which is just above the "Insert" key and right of F12 key.

Go to MS Paint (Start -> All Programs -> Accesories -> Paint)

Paste into the blank space.

You now have the full screen. You then can re-select just the form itself and save just that without the rest of screen. It's now ready to be emailed as JPG, PNG, or whatever format you like. SNP isn't one of them, though.

Thanks Banana, for ur continuing assistance, but I don't think the button on my form will be able to do all this for me
Can you please look at my post to Ken?

 

[Banana]

So you were looking for something more automatic. My apologies.

That said, can't you just copy and paste all the controls to reports without the buttons?

 

[KenHigg]

Is each row on this form simply a row in a single table that has been filtered by the 'status' column?

 

[MsLady]

Is each row on this form simply a row in a single table that has been filtered by the 'status' column?

Yes sir, pretty much

 

[MsLady]

So you were looking for something more automatic. My apologies.

That said, can't you just copy and paste all the controls to reports without the buttons?

I feel like im just going in circles here!

If i have to create a report for each of this form, that's gonna be a lot of work.

 

[CEH]

Heres a thought...... Create a blank report. Put it in design view, drag and drop your form onto the report. Now you have a report with a form embedded in it. When you preview the report, you preview the open form. I have played a little with this..... works so far for me... You might have to add some code to filter what form records show..... BUT...... it is now a report.... So the Docmd.sendobject should work now with a snapshot format.

 

[KenHigg]

Yes sir, pretty much

Then the effort to do a report is much less than you've already put into this thread...

 

[MsLady]

Then the effort to do a report is much less than you've already put into this thread...

Ken be gone