Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / May 2008

Tip: Looking for answers? Try searching our database.

Make sure table gets data from form before close

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
H0MELY - 31 May 2008 01:46 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 "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 **

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.