Stopping and starting data entry.

[hoose]

Hi all,

I was wondering if it is possible to halt the data entry process and be able to automatically continue it at a later date.

My current thoughts are to store the current record and control, and have a macro that will bring them up the next time I start entering data.

Am I on the right track or way off base? Any help would be most appreciated. Thanks in advance.

Dan

 

[mpastore]

I would probably use a temp table that mimics the structure of your actual table. You can store work-in-progress data to temp table and then commit the record to the actual table when user is done entering data.

Mike Pastore

Hats off to (Roy) Harper

 

[hoose]

Thanks for the reply, I've started but run into another problem.

User will be entering data from clients while conducting interviews. Clients may leave before the interview is complete. I need to be able to easily halt the data entry process, and pick it up again where it left off.

I now have a temp table that stores incomple interviews. (Primary key CHILDID)

I need an easy way for an interviewer to restart an incomplete interview at position it was left off.

I'm thinking i could have the temp table store the current control of the interview. When an interview is to be restarted, the interviewer could enter the CHILDID, and a macro could set the focus to the current control.

Does this make any sense?

thanks

dan

 

[mpastore]

I think you are on the right track. Trial and error will be the best way to arrive at the optimal solution.

Mike Pastore

Hats off to (Roy) Harper