Auto Save Option

[JMA]

Hi Guys,

Is there a way in MS Access 2002 to disable the autosave option ? I don't want to save the data to database until I ask to do so.

Any help will be really appreciated.

Thanks in advance.

 

[namliam]

Only way i know how is if you would make the form(s) unbound...

Greetz

 

[ghudson]

You can control how and when a record can be saved by using code in the forms BeforeUpdate event. There are a lot of samples and suggestions posted within this forum.

Here is a link to the method that I use. It all started when I tried to prevent a user from scrolling to another record or trying to close the form but the record had been altered [dirty] and the user might not be aware that they are going to save the record by their action. Check this post and sample out and see if it will work for your situation. A better mouse trap?

 

[lilFlip]

I looked through your code but you force them to save before moving to another record. Is there a way where you can edit all records in the subform and then make it save?

 

[ghudson]

No. Why would you since you need to evaluate if the change to each record in the record source of the sub form [and or main form] should be saved or not before allowing the user to move to off of the dirty record.

 

[lilFlip]

ghudson,

I guess that's where I'm trying to do something different or odd. I'm used to using a different backend and developing all the forms in VB rather than Access. It appears that Access handles the containers/subforms in a different manner when either a query is attached to it (Record Source) or a disconnected recordset is attached (Recordset). Once a row/record has focus and has been changed with the Recordset attached, the form/subform container will not allow you to move off of the selected record.

Is there a property that I need to set that allows this, or did I set my disconnected recordset up incorrectly?

Is this a major design flaw on my part? Or, am I trying to exceed the capabilities of the environment? I'm fairly new to Access but not VB.

 

[ghudson]

Access forms only allow you to work with one record at a time in a form/subform when you are making manual edits. Once you move the focus off of the record it is saved or an error occurs if the safe is invalid [unless you use code like in my examples to prevent a user from moving the focus off of a dirty record].

 

[lilFlip]

ghudson,

Thanks for the information. I'll have to rethink the design then.

Thanks again...

 

[lilFlip]

ghudson,

Thanks for the information again. I re-thought the design and am using a temporary tables that is saved back to the main table when the user saves the parent/main record. The temporary table is removed once the user closes the parent record.

Thanks for all the help.