Welcome to SPN

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

Sign Up Now!

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

    >
    >
    >
     

Share This Page