double entry

i'm looking for some suggestions on how to handle double entry.

the first pass will store the record.

the second pass will validate the entire record after the last field
has been entered and the user will make any needed corrections then.
a boolean flag within the record will be updated when all is corrected.

what would be the best way to hold the temp record for the 2nd pass?

tia,
mcnewsxp-

how you set up the form depends partly on the work flow. will the second
pass be made immediately after the first pass is completed, or at a later
time? by the same user, or a different user?

hth


wrote in message
ps.com...
i'm looking for some suggestions on how to handle double entry.

the first pass will store the record.

the second pass will validate the entire record after the last field
has been entered and the user will make any needed corrections then.
a boolean flag within the record will be updated when all is corrected.

what would be the best way to hold the temp record for the 2nd pass?

tia,
mcnewsxp-

the second pass can be performed by the same user, but only after
completely filling out the form for the current record.
i suppose i'll have to have some way of recalling the existing records
for the second pass.

actually, the solution i have in mind won't be too hard to set up. if the
second pass may be entered by a different user and/or at a different time,
then yes, you will need to "recall" or select the record that will be
verified by the second pass. is there an "order number" or something similar
that the user will have available, that will/can be entered in the first
record, so a particular record can be "found" in order to work with it on
the second pass?

hth


"mcnews" wrote in message
oups.com...
the second pass can be performed by the same user, but only after
completely filling out the form for the current record.
i suppose i'll have to have some way of recalling the existing records
for the second pass.

that's the way i see it.
user may enter the record twice in one sitting or a user else may enter
second pass at a different sitting.
i would use a primary key to recall the records.

if you want to post the table name, and some field names - including the
field that a user would "search" to find a specific record - i'll work up a
quick-and-dirty demo db illustrating a possible solution, and load it to my
website so you can download and look at it.

hth


"mcnews" wrote in message
oups.com...
that's the way i see it.
user may enter the record twice in one sitting or a user else may enter
second pass at a different sitting.
i would use a primary key to recall the records.

that would be swell.

just use anything for a table.
eg:

PrimaryKey
PersonName
PersonAddress
PersonCity
PersonState
PersonZip
PersonPhone

NOTE: this is an ADP.

thanks much.

hmm, well, i can work up a .mdb demo, but i've no experience working with
..adp's. but my example might work for you with some tweaking, or at least
give you a direction you might want to explore. keep an eye on this thread -
i'll post back when i've uploaded the demo.

hth


"mcnews" wrote in message
oups.com...
that would be swell.

just use anything for a table.
eg:

PrimaryKey
PersonName
PersonAddress
PersonCity
PersonState
PersonZip
PersonPhone

NOTE: this is an ADP.

thanks much.

okay, go to http://home.att.net/~california.db/instructions.html and scroll
down to the "demo" link at the bottom of the page. after downloading the
file, make sure you change the file extension from .bac, back to .mdb,
before opening the database in Access. btw, i should have mentioned that
this is an A2000 db built in A2003.

hth


"tina" wrote in message
...
hmm, well, i can work up a .mdb demo, but i've no experience working with
.adp's. but my example might work for you with some tweaking, or at least
give you a direction you might want to explore. keep an eye on this
thread -
i'll post back when i've uploaded the demo.

hth


"mcnews" wrote in message
oups.com...
that would be swell.

just use anything for a table.
eg:

PrimaryKey
PersonName
PersonAddress
PersonCity
PersonState
PersonZip
PersonPhone

NOTE: this is an ADP.

thanks much.

thanks for your efforts.
will have a look.