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 Programming / October 2006

Tip: Looking for answers? Try searching our database.

users quit from main app button but lose data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Nugimac - 12 Oct 2006 14:00 GMT
Form has a before update routine that cancels the update if required fields
are null.  There is a close button and the form's close X is hidden. I wish
to continue allowing users to use the main app X at top RHS to close the app.

The problem is this:
When they do quit, if the form is dirty, the before update message about
required fields appears, but then the app closes and that last dirty record
with a required field null is lost. Is there any way to stop the app closing
until the user either completes the required field or cancels, without
disabling the main app X button?

I thought about warning users if they clicked that main app X, but how to
let the current form know if they have clicked it while the form is dirty and
imcomplete?

Is there any other solution?

nugimac
pietlinden@hotmail.com - 12 Oct 2006 17:30 GMT
How about checking for Required and stopping the close if the values
there are null?
Nugimac - 12 Oct 2006 23:09 GMT
thanks Piet, yes the before update checks for null values and cancels the
update if nulls found. The update is canceled which stops any incomplete
records from being saved in the table, however the app still closes, the
record is not saved, and from a user's point of view, data that has been
entered has been lost.

How can I stop the app from closing and in the process closing the form by
canceling the update if required data is not entered? I don't wish to disable
that main app X at top RHS. I still want users to be able to quit from
clicking that main app X.

> How about checking for Required and stopping the close if the values
> there are null?
 
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.