Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

E-mailing from an access form

Discussion in 'Information Technology' started by Mr. Smiley, Jul 28, 2006.

  1. Mr. Smiley

    Mr. Smiley
    Expand Collapse
    Guest

    Hello. I have a questions about e-mailing from an access form. What I was
    hoping to create is a button a form that, when pressed, will take a
    screenshot, then open Outlook and paste the screenshot with a message that
    states "zero quantities". If anyone know how to accomplish this, please let
    me know. Thanks in advance.
     
  2. Loading...


  3. Scott McDaniel

    Scott McDaniel
    Expand Collapse
    Guest

    On Fri, 21 Jul 2006 04:26:01 -0700, Mr. Smiley <MrSmiley@discussions.microsoft.com> wrote:

    >Hello. I have a questions about e-mailing from an access form. What I was
    >hoping to create is a button a form that, when pressed, will take a
    >screenshot, then open Outlook and paste the screenshot with a message that
    >states "zero quantities". If anyone know how to accomplish this, please let
    >me know. Thanks in advance.


    Access doesn't do screenshots natively; you'll have to automate this somehow:

    http://support.microsoft.com/?kbid=240653

    This is a VB article, but should work with VBA as well.

    Once you do that, you'll need to automate Outlook to handle the rest. I've got an A2k sample on my website that shows
    how to do this:

    www.infotrakker.com/ProgSamples/OutlookEmail.zip



    Scott McDaniel
    scott@takemeout_infotrakker.com
    www.infotrakker.com
     
  4. Jeff C

    Jeff C
    Expand Collapse
    Guest

    As SCott says, Access willnot email forms or screen shots but the workaround
    I use is to save the form as a report. Open your form in designe mode and go
    to "file", "save as", and choose a report. Build a query to use as the
    record source for your report with criteria that specify the current record
    showing on your form. Add a command button that activates the "SendObject"
    specifying the report you just created and a report that basicvally resembles
    your form will be attached to an email. You will have a minimal amount of
    re-design to do on the report after you create it but this workaround is
    effective for some things.
    --
    Jeff C
    Live Well .. Be Happy In All You Do


    "Mr. Smiley" wrote:

    > Hello. I have a questions about e-mailing from an access form. What I was
    > hoping to create is a button a form that, when pressed, will take a
    > screenshot, then open Outlook and paste the screenshot with a message that
    > states "zero quantities". If anyone know how to accomplish this, please let
    > me know. Thanks in advance.
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page