Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

KBV - test query without saving

Discussion in 'Information Technology' started by KBV, Jul 28, 2006.

  1. KBV

    KBV
    Expand Collapse
    Guest

    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!
     
  2. Loading...


  3. OP
    Adam

    Adam
    Expand Collapse
    Guest

    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" <KBV@discussions.microsoft.com> 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
    > test - can you tell me how i can make this allow me to test run without
    > saving??
    >
    > thank you!
    >
     
  4. OP
    KBV

    KBV
    Expand Collapse
    Guest

    That won't work because when I enter the "test criteria", it is saving on the
    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" <KBV@discussions.microsoft.com> 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
    > > test - can you tell me how i can make this allow me to test run without
    > > saving??
    > >
    > > thank you!
    > >

    >
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page