Two stage Data entry form

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

I need to build a data entry form that allows the user to enter data then
either cancel or confirm before the data is added to the table.
Cancel , via a form button that closes the form, Confirm via a macro that
adds the data.

If I use the normal form with record source pointing to the table and
dataentry property on a record will be added every time the form is
activated, not what I need.
I have tried using unbounded text boxes on the form as temporary fields to
accept the data but have struggled to get a macro to add a record and
transfer the data from the temporary fields to the record fields .
I thought about using a intermediate table to accept the data then a macro
to append from the intermediate table to the real table, then tidy up.
Out maybe I have missed something fundemental here.

Richard
Not a VB person but fine on macros
 
The other alternative is to:
1. Open a transaction.
2. Open a recordset.
3. Assign the recordset to the Recordset of your form.
4. In the Close event of the form (or when the user clicks a button), Commit
or RollBack the transaction.

Limitations of this approach:
- Only Access 2000 and later;
- Subforms don't work in this scenario (since the subform records reload
each time the main form changes record);
- Fairly easy to get instability (crashing);
- Not good for multi-user setting (everyone trying different overlapping
transactions).
 
Thanks Allen,
I like the idea but according to access help, batch transactions require my
database is connected to a Microsoft SQL Server database , unfortunately
its plain vanilla access.
Richard
 
You can do this in plain Access (i.e. JET tables).

However, I did give up on the idea because the limitations were overriding.
 
I thought about using a intermediate table to accept the data then a macro
to append from the intermediate table to the real table, then tidy up.
Out maybe I have missed something fundemental here.
Click to expand...

That's probably the best bet. This is *not* an easy task in Access,
unfortunately! You'll certainly have learned some VBA code (opening
Recordsets frex) before you're done.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top