Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Nov 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Saving a query (Access 2000)

    If I want to take the values returned by a query and save them in a table, how do I do so?

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Saving a query (Access 2000)

    It depends on what exactly you want to do. One way is to turn the query into a Make-table query. That will give you a table with the same fields as the query and with the records returned by that query at that particular time. Does that answer your question?
    Charlotte

  3. #3
    Star Lounger
    Join Date
    Nov 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Saving a query (Access 2000)

    Thanks! That works great except for the message asking you if you're sure you want to delete the table every time you want to run the query. (I have the option set so that it doesn't ask me on delete queries, but that doesn't take care of this annoying message) I'm trying to keep things as simple as possible for the user.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Saving a query (Access 2000)

    How will the user be running the make-table query? If it's called from a macro, add a SetWarnings action before and after the OpenQuery. Turn if off before the OpenQuery and back on afterward. If you're calling it from VBA code, use a DoCmd.SetWarnings instead.
    Charlotte

  5. #5
    Star Lounger
    Join Date
    Nov 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Saving a query (Access 2000)

    Great! Thanks for the help! (I'll probably be posting more questions because this project is due in a week!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •