double entry

  • Thread starter Thread starter mcourter
  • Start date Start date
M

mcourter

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
 
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
 
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
 
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
 
hi tina - can give the link you sent me for this again.
i am ready to give it a try now.
thanks again.
michael
 
tina - like your idea.
i wish that i had been invlolved with this project i inherited from the
start.
i would have done something like that.
the app i am retro-fitting contains several forms tied to one main
table so the verification needs to happen on the last form.
also, the original developer create some class modules that handle all
form navigation and record handling so i have to figure out how to work
with this.
thanks again!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need help with count query 6
disconnected reorcdset (or something) 5
query to retrieve most recent information 2
add new record from linked table 9
password protect 13
inventory variance report 1
Trouble flagging conditions in Excel using VB 6
query that doesn't select dupes 2

Back
Top