A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Test Possible Before Saving?



 
 
Thread Tools Display Modes
  #1  
Old June 3rd, 2010, 03:21 PM posted to microsoft.public.access.gettingstarted
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default Test Possible Before Saving?

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.
  #2  
Old June 3rd, 2010, 04:02 PM posted to microsoft.public.access.gettingstarted
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default Test Possible Before Saving?

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" wrote in message
...
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.



  #3  
Old June 4th, 2010, 02:18 PM posted to microsoft.public.access.gettingstarted
trip_to_tokyo[_3_]
external usenet poster
 
Posts: 932
Default Test Possible Before Saving?

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" wrote in message
...
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.



.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:01 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.