Forms and Saving

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I've created a form that will be used for data entry. I don't however want
the data that is inputed to be saved until it is completly filled out. If
someone stops half way through, i don't want the data that they entered to be
saved. Can anyone get me started here?
Thanks
 
SC said:
Hello,
I've created a form that will be used for data entry. I don't
however want the data that is inputed to be saved until it is
completly filled out. If someone stops half way through, i don't
want the data that they entered to be saved. Can anyone get me
started here?
Thanks
Click to expand...

Well one way would be to make all the fields as "Required" in the table design.
Then with no code at all it would not be possible to save a record unless they
were all filled in.
 
Unfortunatly, the form contains checkboxs, many of which will be left blank.
So I don't think that option will work in this case.
 
SC said:
Unfortunatly, the form contains checkboxs, many of which will be left
blank. So I don't think that option will work in this case.
Click to expand...

Well then you have to have some sort of definition for a form that is "half
filled out". If many fields can be left empty then how do you know when they
have filled out enough?
 
Unfortunatly, the form contains checkboxs, many of which will be left blank.
So I don't think that option will work in this case.
Click to expand...

Um?

That's a contradiction.

You say the user must fill everything out.
That means they must check all the checkboxes, since a checkbox can
only be unchecked or checked, and it's unchecked by default.

John W. Vinson[MVP]
 
No, the user doesn't have to fill everything out. The problem with the
record being saved before it is finished is that because of Security reasons
the user's can't go back and edit the records. so if they start a record and
don't finish it, by default Access would save a recored with partial info.

This is what i need: Access not to save until user clicks a save button.
The save button is easy. How do you tell acces not to save until the user
clicks the save button.
 
SC,

Here's something like how I have done this...

1. Make a module level variable, by putting something like this at the
top of the form's module...
Dim AllowSave As Boolean

2. On the Click event of the 'Save' button, put code like this...
AllowSave = True
Me.Dirty = False

3. On the form's Before Update event, put code like this...
If AllowSave Then
AllowSave = False
Else
Me.Undo
Cancel = True
End If

Does that meet the requirement?
 
SC said:
Hello,
I've created a form that will be used for data entry. I don't however
want
the data that is inputed to be saved until it is completly filled out. If
someone stops half way through, i don't want the data that they entered to
be
saved. Can anyone get me started here?
Click to expand...

What I do is rather than use the actual table as the record source for the
form,
I use a dummy table. Then, if I choose to save, the actual table is updated
from
the dummy table otherwise the dummy table is discarded.

Tom Lake
 
What I do is rather than use the actual table as the record source for
the
form, I use a dummy table. Then, if I choose to save, the actual table
is updated
from the dummy table otherwise the dummy table is discarded.
<<<

Another approach would be to have all data entry happen through an
unbound form. The bound form itself would be read only just used for
review purposes and the user would have to click a button to generate
the intermediate unbound form to make any new entries. Only when the
user has clicked the Save button and the data has been checked would it
then be written to the actual table.
 
Back
Top