KBV - test query without saving

Normally when I use Access, if i go into query design and change criteria
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12896-kbv-test-query-without-saving.html
from say >100 to >200 and run it, it will run but not save my change. then
when i click "X" to close, it will ask me "do you want to save changes", if i
say "no", it will not save the new criteria and it will go back to original
>100...

For some reason, in this new db i am working on, if i make a change in query
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12896
design and run it, its automatically saving - not giving me the option to
test - can you tell me how i can make this allow me to test run without
saving??

thank you!

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

How about opening it and saving it right away under another name testqry or
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12896
something. Then if you want to keep it, save it again, but as the original
name.


"KBV" wrote in message
news:8ABF6C80-7EDE-4EC3-8E89-BFDA0DDBD0AD@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12896
> Normally when I use Access, if i go into query design and change criteria
> from say >100 to >200 and run it, it will run but not save my change. then
> when i click "X" to close, it will ask me "do you want to save changes",
> if i
> say "no", it will not save the new criteria and it will go back to
> original
>>100...
>
> For some reason, in this new db i am working on, if i make a change in
> query
> design and run it, its automatically saving - not giving me the option to
> test - can you tell me how i can make this allow me to test run without
> saving??
>
> thank you!
>

That won't work because when I enter the "test criteria", it is saving on the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12896
spot (and it overrides the existing query) i am guessing it has to do with a
setting.

pls advise...


"Adam" wrote:

> How about opening it and saving it right away under another name testqry or
> something. Then if you want to keep it, save it again, but as the original
> name.
>
>
> "KBV" wrote in message
> news:8ABF6C80-7EDE-4EC3-8E89-BFDA0DDBD0AD@microsoft.com...
> > Normally when I use Access, if i go into query design and change criteria
> > from say >100 to >200 and run it, it will run but not save my change. then
> > when i click "X" to close, it will ask me "do you want to save changes",
> > if i
> > say "no", it will not save the new criteria and it will go back to
> > original
> >>100...
> >
> > For some reason, in this new db i am working on, if i make a change in
> > query
> > design and run it, its automatically saving - not giving me the option to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12896
> > test - can you tell me how i can make this allow me to test run without
> > saving??
> >
> > thank you!
> >
>
>
>