Greetings, thank you all for looking. This is probably very easy but it is
late and I am having brain problems. I built a quick "issues" form that
allows people to enter information when they encounter problems with my
databse. Hopefully it will never need to be used ;)
So I have them click a button that will always be available from the form
header. The button opens the issue form ready for a new record. The data
that is entered gets posted to a table called...tbl_issues. The issue form
has a submit button that uses the sendobject action to send me an email of
the issues table.
So the trick is that the user must complete the record and move on to a
potential new record for it to get to post to the table. My question is...I
would like to ensure that the data that is entered gets posted to the issues
table...regardless if they actually complete the form. If they click the
send button I want whatever is in the data fields to get posted to the table
and then sent to me.
I hope this is really easy for someone. Thank you all for looking and I
look forward to your responses.
-john
Wayne-I-M - 31 May 2008 12:48 GMT
If the form is bound to a table - as soon as the record is created anything
input in the controls (bound to field) will be stored in the table. You
don't need to do anything. Of course if they delete the data in the controls
then you will not save it but the record will still be saved (unless they
delete the record)
You just need to create a report (filtered that the record primary field)
and use SendObject to send this report to you in whatever format you have set.

Signature
Wayne
Manchester, England.
> Greetings, thank you all for looking. This is probably very easy but it is
> late and I am having brain problems. I built a quick "issues" form that
[quoted text clipped - 18 lines]
>
> -john
Wayne-I-M - 31 May 2008 12:49 GMT
Have a look at this link
http://www.lebans.com/mousewheelonoff.htm

Signature
Wayne
Manchester, England.
> Greetings, thank you all for looking. This is probably very easy but it is
> late and I am having brain problems. I built a quick "issues" form that
[quoted text clipped - 18 lines]
>
> -john
Bob Quintal - 31 May 2008 18:01 GMT
> Greetings, thank you all for looking. This is probably very easy
> but it is late and I am having brain problems. I built a quick
[quoted text clipped - 20 lines]
>
> -john
in your send button's on click procedure, add the following lines
before your code to create the email.
If me.dirty then
me.dirty = false
end If
dirty is a property of the form that indicates that the form has
unposted data.

Signature
Bob Quintal
PA is y I've altered my email address.
** Posted from http://www.teranews.com **