RESUBMITTAL - Send New Record Only

Lyne Savage · External Since: Sep 10, 2009 Posts: 10

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?

John... Visio MVP · External Since: Jan 08, 2009 Posts: 41

"Lyne Savage" <LyneSavage RemoveThis @discussions.microsoft.com> wrote in message
news:AB9D75DD-B630-47EF-81C4-209B69E3FA51@microsoft.com...
>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 Savage · External Since: Sep 10, 2009 Posts: 10

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" <LyneSavage.TakeThisOut@discussions.microsoft.com> wrote in message
> news:AB9D75DD-B630-47EF-81C4-209B69E3FA51@microsoft.com...
> >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
>
>

Gina Whipp · External Since: Sep 25, 2003 Posts: 426

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" <LyneSavage.TakeThisOut@discussions.microsoft.com> wrote in message
news:9C3D3712-92AB-432A-9E3D-99DB95553ACB@microsoft.com...
> 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" <LyneSavage.TakeThisOut@discussions.microsoft.com> wrote in message
>> news:AB9D75DD-B630-47EF-81C4-209B69E3FA51@microsoft.com...
>> >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 Savage · External Since: Sep 10, 2009 Posts: 10

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" <LyneSavage.RemoveThis@discussions.microsoft.com> wrote in message
> news:9C3D3712-92AB-432A-9E3D-99DB95553ACB@microsoft.com...
> > 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" <LyneSavage.RemoveThis@discussions.microsoft.com> wrote in message
> >> news:AB9D75DD-B630-47EF-81C4-209B69E3FA51@microsoft.com...
> >> >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
> >>
> >>
>
>
>

Gina Whipp · External Since: Sep 25, 2003 Posts: 426

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" <LyneSavage.TakeThisOut@discussions.microsoft.com> wrote in message
news:EEEC0038-9136-4FEB-857F-8999B428AADD@microsoft.com...
> 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" <LyneSavage.TakeThisOut@discussions.microsoft.com> wrote in message
>> news:9C3D3712-92AB-432A-9E3D-99DB95553ACB@microsoft.com...
>> > 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" <LyneSavage.TakeThisOut@discussions.microsoft.com> wrote in message
>> >> news:AB9D75DD-B630-47EF-81C4-209B69E3FA51@microsoft.com...
>> >> >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
>> >>
>> >>
>>
>>
>>

KenSheridan via AccessMon · External Since: May 16, 2009 Posts: 68

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