Prev: macro help
Next: 2 value formula help needed
From: trip_to_tokyo on 3 Jun 2010 10:21
ACCESS 2007

If I have made some changes (for example modifying a field to make sure that
values are required and / or creating a lookup for a field to name just 2
possibilities) is there a way to ensure that the above changes are tested
before I save the changes I've made?

TIA for any replies.
From: Al Campagna on 3 Jun 2010 11:02
trip,
No.
(You don't indicate whether your referring to a table or a form)
You make your changes in Design Mode, and test in
Form/Datasheet View.

If you're concerned that you might save some changes that might not
work,
then make a backup copy of your original object before you begin, and save
your
changes under a diferent name... until fully tested. If OK... save to the
original
object name.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"trip_to_tokyo" <info(a)pierrefondes.com> wrote in message
news:59AC844A-AF22-4281-B665-B7589A9F0831(a)microsoft.com...
> ACCESS 2007
>
> If I have made some changes (for example modifying a field to make sure
> that
> values are required and / or creating a lookup for a field to name just 2
> possibilities) is there a way to ensure that the above changes are tested
> before I save the changes I've made?
>
> TIA for any replies.


From: trip_to_tokyo on 4 Jun 2010 09:18
I was referring to a table and not a form; thanks for the answer.

"Al Campagna" wrote:

> trip,
> No.
> (You don't indicate whether your referring to a table or a form)
> You make your changes in Design Mode, and test in
> Form/Datasheet View.
>
> If you're concerned that you might save some changes that might not
> work,
> then make a backup copy of your original object before you begin, and save
> your
> changes under a diferent name... until fully tested. If OK... save to the
> original
> object name.
> --
> hth
> Al Campagna
> Microsoft Access MVP 2007-2009
> http://home.comcast.net/~cccsolutions/index.html
>
> "Find a job that you love... and you'll never work a day in your life."
>
> "trip_to_tokyo" <info(a)pierrefondes.com> wrote in message
> news:59AC844A-AF22-4281-B665-B7589A9F0831(a)microsoft.com...
> > ACCESS 2007
> >
> > If I have made some changes (for example modifying a field to make sure
> > that
> > values are required and / or creating a lookup for a field to name just 2
> > possibilities) is there a way to ensure that the above changes are tested
> > before I save the changes I've made?
> >
> > TIA for any replies.
>
>
> .
>
 | 
Pages: 1
Prev: macro help
Next: 2 value formula help needed