Is it possible to email a FORM in snapshot format?

MsLady

MsLady

Traumatized by Access
Local time
Today, 14:38
Joined
Jun 14, 2004
Messages
438
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.
 
Why email a form? Why not put the same results from the same query into a report and easily email that in snapshot format.
 
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?
 
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!!
 
So i guess it's not possible to email a snapshot or view of data on my form :rolleyes:
 
Wouldn't a screen dump do the job?
 
Can't you get docmd.sendobject to utilize the acFormatSNP output option?
 
KenHigg said:
Can't you get docmd.sendobject to utilize the acFormatSNP output option?
Click to expand...
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 :mad:

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!
 
Why don't you simply do a report to send?
 
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.
 
KenHigg said:
Why don't you simply do a report to send?
Click to expand...
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.
newpicture6tn1.png


Please help me, i'll love you forever!
 
Banana said:
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.
Click to expand...
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?
 
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?
 
Is each row on this form simply a row in a single table that has been filtered by the 'status' column?
 
KenHigg said:
Is each row on this form simply a row in a single table that has been filtered by the 'status' column?
Click to expand...
Yes sir, pretty much :D
 
Banana said:
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?
Click to expand...
I feel like im just going in circles here!

Mslady said:
If i have to create a report for each of this form, that's gonna be a lot of work.
Click to expand...
 
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.
 
MsLady said:
Yes sir, pretty much :D
Click to expand...

Then the effort to do a report is much less than you've already put into this thread... :) :)
 
KenHigg said:
Then the effort to do a report is much less than you've already put into this thread... :) :)
Click to expand...
Ken be gone
Kaboom.gif






:D
 
You must log in or register to reply here.

Similar threads

A
Solved In a continuous form : Disable / lock a textbox on a specific record on clicking a button within that record. Any way it can be done ?
Replies
6
Views
322
alan2013
A
T
Attache to email from attachment Field
Replies
2
Views
313
theinviter
T
Uncle Gizmo
Does Microsoft Access 2024 (Professional Plus 2024) Export Forms as Text for Re-Import?
Replies
14
Views
692
Josef P.
J
M
Signature Image in GMail email body
Replies
7
Views
464
Marshall Brooks
M
J
Unable to fined Reference Field
Replies
9
Views
352
DHookom
DHookom

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom