RESUBMITTAL - Send New Record Only

I posted this in General 5 days ago and no one has answered me yet...

I have a submit button in my form. The form will be used for data entry. On
the OnClick option of the sumbit button,I would like to have the record that
was just created sent to someone by e-mail. Right now, I can only get it to
send the whole table, but I would like it to send only the last record of
that table. Is this possible?

"Lyne Savage" wrote in message
...
I posted this in General 5 days ago and no one has answered me yet...

I have a submit button in my form. The form will be used for data entry.
On
the OnClick option of the sumbit button,I would like to have the record
that
was just created sent to someone by e-mail. Right now, I can only get it
to
send the whole table, but I would like it to send only the last record of
that table. Is this possible?


What does the relevant code in the OnClick look like?

John... Visio MVP

It's a Macro...my training for Access has not yet begun (next week) and I'm
jumping the gun a bit...

"John... Visio MVP" wrote:

"Lyne Savage" wrote in message
...
I posted this in General 5 days ago and no one has answered me yet...

I have a submit button in my form. The form will be used for data entry.
On
the OnClick option of the sumbit button,I would like to have the record
that
was just created sent to someone by e-mail. Right now, I can only get it
to
send the whole table, but I would like it to send only the last record of
that table. Is this possible?


What does the relevant code in the OnClick look like?

John... Visio MVP

Lyne,

The key to sending *the new record* is determining how Access knows it's a
new record. Which sounds like what is missing. Please post the Macro
Actions. Also, is this and unbound form?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Lyne Savage" wrote in message
...
It's a Macro...my training for Access has not yet begun (next week) and
I'm
jumping the gun a bit...

"John... Visio MVP" wrote:

"Lyne Savage" wrote in message
...
I posted this in General 5 days ago and no one has answered me yet...

I have a submit button in my form. The form will be used for data
entry.
On
the OnClick option of the sumbit button,I would like to have the record
that
was just created sent to someone by e-mail. Right now, I can only get
it
to
send the whole table, but I would like it to send only the last record
of
that table. Is this possible?


What does the relevant code in the OnClick look like?

John... Visio MVP

The macro is made with SendObject...which sends the table that the form is
bound to. I don't know how to create a macro that will send only the new
record...

"Gina Whipp" wrote:

Lyne,

The key to sending *the new record* is determining how Access knows it's a
new record. Which sounds like what is missing. Please post the Macro
Actions. Also, is this and unbound form?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Lyne Savage" wrote in message
...
It's a Macro...my training for Access has not yet begun (next week) and
I'm
jumping the gun a bit...

"John... Visio MVP" wrote:

"Lyne Savage" wrote in message
...
I posted this in General 5 days ago and no one has answered me yet...

I have a submit button in my form. The form will be used for data
entry.
On
the OnClick option of the sumbit button,I would like to have the record
that
was just created sent to someone by e-mail. Right now, I can only get
it
to
send the whole table, but I would like it to send only the last record
of
that table. Is this possible?


What does the relevant code in the OnClick look like?

John... Visio MVP

Lyne,

You can base the Macro on a query and add a Where Condition to the query...
e: Forms![FormName]![NameOfKeyThatWOuldFiltereMailMessage]


--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Lyne Savage" wrote in message
...
The macro is made with SendObject...which sends the table that the form is
bound to. I don't know how to create a macro that will send only the new
record...

"Gina Whipp" wrote:

Lyne,

The key to sending *the new record* is determining how Access knows it's
a
new record. Which sounds like what is missing. Please post the Macro
Actions. Also, is this and unbound form?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Lyne Savage" wrote in message
...
It's a Macro...my training for Access has not yet begun (next week) and
I'm
jumping the gun a bit...

"John... Visio MVP" wrote:

"Lyne Savage" wrote in message
...
I posted this in General 5 days ago and no one has answered me yet...

I have a submit button in my form. The form will be used for data
entry.
On
the OnClick option of the sumbit button,I would like to have the
record
that
was just created sent to someone by e-mail. Right now, I can only
get
it
to
send the whole table, but I would like it to send only the last
record
of
that table. Is this possible?


What does the relevant code in the OnClick look like?

John... Visio MVP

A further point is that the macro should ensure that the current record is
saved (by calling the RunCommand action with the SaveRecord command) before
calling the SendObject action. Otherwise if the user has just entered data
for a new record in the form the record will not yet have been saved to the
table, so a query would not pick it up.

Ken Sheridan
Stafford, England

Lyne Savage wrote:
The macro is made with SendObject...which sends the table that the form is
bound to. I don't know how to create a macro that will send only the new
record...

Lyne,

[quoted text clipped - 23 lines]

John... Visio MVP

--
Message posted via http://www.accessmonster.com