DBApprentice
On Error GoTo AWF *****:
- Local time
- Yesterday, 23:22
- Joined
- Dec 24, 2018
- Messages
- 150
Guys,
I have a small DB and it has a form where users can input information. Since sometimes they have to input the basic information all the time, they asked me if it would be possible to have a "copy" of a certain record to paste it on the acNewRec, so they can change only the few things that differs them from the previous records.
Now, I believe I could:
- Put a button or check box called "Template Me" or something like that.
- If the user click on that control, it will save data to the underlying query and also will save it to a temp table or query to write it the data there after saving the records
- On a new record the button "Paste from previous record", or something like that, would be activated and the user can click it to paste the data from the temp table/query.
-The temp table/query would be cleared once the user unload/close the form.
I was wondering what would be the best solution and I would like to know if you have any comments in case you have dealt with such a thing (I am quite sure you did!), what pitfalls I should avoid.
Thanks for your time!
I have a small DB and it has a form where users can input information. Since sometimes they have to input the basic information all the time, they asked me if it would be possible to have a "copy" of a certain record to paste it on the acNewRec, so they can change only the few things that differs them from the previous records.
Now, I believe I could:
- Put a button or check box called "Template Me" or something like that.
- If the user click on that control, it will save data to the underlying query and also will save it to a temp table or query to write it the data there after saving the records
- On a new record the button "Paste from previous record", or something like that, would be activated and the user can click it to paste the data from the temp table/query.
-The temp table/query would be cleared once the user unload/close the form.
I was wondering what would be the best solution and I would like to know if you have any comments in case you have dealt with such a thing (I am quite sure you did!), what pitfalls I should avoid.
Thanks for your time!