confirm

[confirm data on a access page by another]

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

 

[John Vinson]

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

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