Re: How can I send a form through e-mail

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thank you for the information! I have been asking this for days in different
posts, and you are the first to tell me that you can not send a form by
e-mail. THANK YOU!

Can you still help me I am still having problems. I have created a report
with the same information in it but, I am still receiving an error message
stating that "Employees can't send a message for the reason stated in the
preceding alert." although there isn't a preceding alert. I have created
the macro under the sendobject action. Is this not the correct way to send a
report by e-mail?

"John Vinson" wrote:

> On Tue, 5 Jul 2005 08:25:06 -0700, "AccessNewbe"
> <AccessNewbe@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> >I have been working on a database that shows a new hire packet that needs to
> >be filled out by employees. The form has links which are PDF files to be
> >accessed by the employees to print out. What I am trying to do is to
> >successfully send an email of this form to an employee. I am finding that
> >when I put in an event procedure some problems come up. First, I finally got
> >the form to send by email, but when I send the form the contents of the form
> >do not show up just a blank screen. Second, after only trying to send the
> >form a couple of times the code seems to quit working so now I can not even
> >get it to send by email now. What am I doing wrong?
>
> Assiming that a Form is anything more than a window, a tool for
> displaying data from within the database.
>
> The Form isn't "portable" in this way; it doesn't contain any data,
> and is of no use except within the database itself.
>
> You can create a Report to send a (static) image of selected data from
> your database; to get data back into the database you will need some
> VBA code to parse the *text* of an EMail message and enter it into
> your tables.
>
> John W. Vinson[MVP]
>
.

Relevant Pages

  • Re: Crosstab query and report
    ... I download your example database called CrossTab.mdb. ... >> report I am using. ... It also contains some VBA code which I do understand. ... >> Duane, If I remove the where clause, the report runs great. ...
    (microsoft.public.access.reports)
  • Re: OT: SQL
    ... query processing. ... FROM Employees e, Employees m, Management mgt ... Manager and Employee Salaries. ... The scheme used does not model database files in general, ...
    (sci.logic)
  • And yet another one from the mind of Lohkee!
    ... Internet Content Blocking Software ... Some organizations that allow employees to surf the net have ... a database of websites that have been categorized by type of the content ... existence of a web site before you can categorize it. ...
    (comp.security.misc)
  • And yet another one from the mind of Lohkee!
    ... Internet Content Blocking Software ... Some organizations that allow employees to surf the net have ... a database of websites that have been categorized by type of the content ... existence of a web site before you can categorize it. ...
    (comp.os.ms-windows.nt.admin.security)
  • And yet another one from the mind of Lohkee!
    ... Internet Content Blocking Software ... Some organizations that allow employees to surf the net have ... a database of websites that have been categorized by type of the content ... existence of a web site before you can categorize it. ...
    (microsoft.public.win2000.security)