Results 1 to 3 of 3
  1. #1
    dssrun is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2010
    Posts
    83

    Saving over a query


    Is there a way to create a query over the original. For example

    Code:
    Set qryDef = CurrentDb().CreateQueryDef(myCriteria,sqlFinal)
    This errors saying that the object already exists. I just want to overwrite the original query with the new data I recieve daily. So do i need to delete the actual query with the code below before I run the createquery or is there another method?

    Code:
    DoCmd.DeleteObject myCritiera

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,848

  3. #3
    dssrun is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Oct 2010
    Posts
    83
    great I knew it would be something simple like that I just couldn't find it!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 12-20-2010, 09:09 AM
  2. Saving Label on the Fly
    By frobro390 in forum Forms
    Replies: 3
    Last Post: 10-07-2010, 10:52 AM
  3. Saving Record
    By mwabbe in forum Programming
    Replies: 12
    Last Post: 09-15-2010, 12:09 PM
  4. Export query without saving
    By prag in forum Queries
    Replies: 1
    Last Post: 11-18-2009, 06:22 PM
  5. Unable to close Query without saving
    By jhrBanker in forum Access
    Replies: 0
    Last Post: 06-08-2009, 05:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums