Retaining Default Records After Editing

[GeoffreyB]

Hello,

These discussions have been a tremendous resource, and have really
helped me make a lot of progress in a project that I'm working on. As
for my problem... I've been working on a form generator in access and
have encountered a stumbling block. I've created a table with a set of
default memo records (the field name is Clauses) that I would like the
user to be able to edit based on the specific nature of their case.
However, I would like to retain the default clauses everytime the
database is started, in other words I don't want one users changes to
the Clauses field to carry over to the next user session. After
reading some posts I've found that probably copying the clause records
and pasting them in the same table as a new field ClauseEdit would
probably be a solution. Is there a way to do this (maybe some sort of
macro)? Also, can this be done in a multi-user environment. Thanks.

Geoffrey

[Larry Linson]

I'm sorry that I don't understand: this "table with a set of default memo
records" -- is it a source from which the clauses are copied into another
table, and then edited (I guess if that were the case, there'd be no
question about restoring the original). If you allow the defaults to be
edited, then you will need some way to restore them.

I'd consider having my table of defaults not available to the user, using
the approach (example at MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm) of creating a temporary database, and
using CopyObject to copy the table of defaults to a temporary table to which
the user has access, then deleting the temporary database and table when
your application is closed. Thus, there is no confusion -- the user never
has the opportunity to change the basic defaults.

Larry Linson
Microsoft Access MVP
"GeoffreyB" <Ge*************@gmail.comwrote in message
news:11**********************@k73g2000cwa.googlegr oups.com...

Hello,

These discussions have been a tremendous resource, and have really
helped me make a lot of progress in a project that I'm working on. As
for my problem... I've been working on a form generator in access and
have encountered a stumbling block. I've created a table with a set of
default memo records (the field name is Clauses) that I would like the
user to be able to edit based on the specific nature of their case.
However, I would like to retain the default clauses everytime the
database is started, in other words I don't want one users changes to
the Clauses field to carry over to the next user session. After
reading some posts I've found that probably copying the clause records
and pasting them in the same table as a new field ClauseEdit would
probably be a solution. Is there a way to do this (maybe some sort of
macro)? Also, can this be done in a multi-user environment. Thanks.

Geoffrey

[GeoffreyB]

Thanks Larry for pointing me in the right direction. Your answer has
been a big help.

Geoffrey

Larry Linson wrote:

I'm sorry that I don't understand: this "table with a set of default memo
records" -- is it a source from which the clauses are copied into another
table, and then edited (I guess if that were the case, there'd be no
question about restoring the original). If you allow the defaults to be
edited, then you will need some way to restore them.

I'd consider having my table of defaults not available to the user, using
the approach (example at MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm) of creating a temporary database, and
using CopyObject to copy the table of defaults to a temporary table to which
the user has access, then deleting the temporary database and table when
your application is closed. Thus, there is no confusion -- the user never
has the opportunity to change the basic defaults.

Larry Linson
Microsoft Access MVP
"GeoffreyB" <Ge*************@gmail.comwrote in message
news:11**********************@k73g2000cwa.googlegr oups.com...

Hello,

These discussions have been a tremendous resource, and have really
helped me make a lot of progress in a project that I'm working on. As
for my problem... I've been working on a form generator in access and
have encountered a stumbling block. I've created a table with a set of
default memo records (the field name is Clauses) that I would like the
user to be able to edit based on the specific nature of their case.
However, I would like to retain the default clauses everytime the
database is started, in other words I don't want one users changes to
the Clauses field to carry over to the next user session. After
reading some posts I've found that probably copying the clause records
and pasting them in the same table as a new field ClauseEdit would
probably be a solution. Is there a way to do this (maybe some sort of
macro)? Also, can this be done in a multi-user environment. Thanks.

Geoffrey