Sending a form in Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, i'm a self taught user and am in need of help. I've created a form where
a user can input data and select items. After they have finished i created a
button where they can email the form back to me. I can't seem to get the
data back to me in the format that i want, right now i'm using a macro to
send object as a form and in HTML format, however i'd like it to be in the
same format as the form is, and to only send the current, or new record
created. Does anyone know of a better way to do this, some other solution,
or what I may be doing wrong?
 
Reed33OKC said:
Hi, i'm a self taught user and am in need of help. I've created a form where
a user can input data and select items. After they have finished i created a
button where they can email the form back to me. I can't seem to get the
data back to me in the format that i want, right now i'm using a macro to
send object as a form and in HTML format, however i'd like it to be in the
same format as the form is, and to only send the current, or new record
created. Does anyone know of a better way to do this, some other solution,
or what I may be doing wrong?
Click to expand...

A form is only a data *entry* object, it doesn't actually contain any data.

What should be happening is that the form stores the information into a
table, and you're emailing the contents of the table back to you.
 
How about having it sent to you as a screen shoot.
This may not work well but you can create a access web form and send it that
way.
 
Thanks for the help, I managed to get it to "somewhat" work like I wanted. I
created a button that saves the data after input into the form, and a button
to send the data as a snapshot of a report. This comes through email in the
format I wanted after creating a new report as a template of course. Problem
i'm up against now, is to have just one new record come through the snapshot
instead of all records. Thanks for the advice.
 
Reed33OKC said:
Thanks for the help, I managed to get it to "somewhat" work like I wanted. I
created a button that saves the data after input into the form, and a button
to send the data as a snapshot of a report. This comes through email in the
format I wanted after creating a new report as a template of course. Problem
i'm up against now, is to have just one new record come through the snapshot
instead of all records. Thanks for the advice.
Click to expand...

You should set the source for your report to a query, rather than the
table directly. Then you can use criteria to limit the results of the
query to just the single record you want.
 
I resolved sending forms by e-mail by:

Save your form as a report

Base the report on a query

Specify as criteria in the query the current record, often I will pull
in the autonumber field for the recordset of the form I am using and
set the visibility to False, but reference this field as the criteria
in the query.

This will give you a report that is identical to your current form.

I have a send email command button using the sendobject method to call
the snapshot of the report and attach it to an email.

works very well
 
Back
Top