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 / New Users / December 2005

Tip: Looking for answers? Try searching our database.

Prevent SAVE till button click

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MS learner - 28 Dec 2005 14:41 GMT
Hi, I have a form for user data entry set up. I have a save button as the
last tab. However, as long as the user tabs through and fills in all the
Required fields, the record gets saved without having to click on the SAVE
button. Is there any way to prevent a record from saving until the SAVE
button is clicked.

Thanks for any help.
Rick Brandt - 28 Dec 2005 15:25 GMT
> Hi, I have a form for user data entry set up. I have a save button as the
> last tab. However, as long as the user tabs through and fills in all the
[quoted text clipped - 3 lines]
>
> Thanks for any help.

There are *numerous* events that will trigger Access to automatically save a
record.  The best thing to do is to realize that this is how Access works and go
with it instead of fighting it.

If you want a thin-client "detached" sort of form where nothing happens until
you tell it to then the way to achieve that in Access is to use an unbound form.
Of course doing this forces you to lose virtually all of the built in stuff that
makes Access one of the easiest and fastest tools for making database
applications with.

Signature

I don't check the Email account attached
to this message.     Send instead to...
RBrandt    at       Hunter      dot      com

BruceM - 28 Dec 2005 15:34 GMT
A record is saved when you navigate to another record unless you
specifically prevent it from being saved.  Are you using table-level
valication to ensue all fields are filled in?  You can prevent the user from
tabbing to a new record by setting the form's Cycle property (Other tab on
the form's property sheet) to Current Record.  But why do you want to force
users to reach for the mouse or go through the extra step of clicking the
Save button?  Navigating to a new record accomplishes exactly the same thing
as explicitly saving the record with a command button.

> Hi, I have a form for user data entry set up. I have a save button as the
> last tab. However, as long as the user tabs through and fills in all the
[quoted text clipped - 3 lines]
>
> Thanks for any help.
John Nurick - 28 Dec 2005 18:58 GMT
As others have said, it's best to work with the grain and allow the
record to be saved automatically. Using a combination of "required"
fields, field- and table-level validation rules, and maybe VBA code in
the BeforeUpdate events of your form and its controls, you can ensure
that the users can't save incomplete records.

>Hi, I have a form for user data entry set up. I have a save button as the
>last tab. However, as long as the user tabs through and fills in all the
[quoted text clipped - 3 lines]
>
>Thanks for any help.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
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.