confirm

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

Guest

I want to prepare an access data page that requires 1 or 2 steps of appraval
by another person(s). Page is ready by I couldn't manage to add confirming by
second person. Clearly my aim is a page on which first person enters data,
second person confirms and I make some transactions as per confirmed data.

Thanks and regards.

Murat Erdis
 
On Thu, 25 Nov 2004 23:25:09 -0800, "confirm data on a access page by
another" <confirm data on a access page by
I want to prepare an access data page that requires 1 or 2 steps of appraval
by another person(s). Page is ready by I couldn't manage to add confirming by
second person. Clearly my aim is a page on which first person enters data,
second person confirms and I make some transactions as per confirmed data.

Thanks and regards.

Murat Erdis
Click to expand...

This can be a bit of work to set up. You may need to have either two
separate tables - a data entry table and a production table - with VBA
code to move the data from the first into the second upon
confirmation; or, more simply, just add a Confirmed yes/no field to
the table. Make sure that the database's security and forms are set up
so that only the person authorized to confirm data can change the
value of this field.

It's going to be rather difficult to manage this *just* on the data
access page.

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