Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error message on query exit (Access 2000)

    When I attempt to exit my query, I get this message: "This Action will reset the current code in break mode. Do you want to stop running code? To halt the execution of the program so the module window can be closed, select Yes. To leave the code in the current state, select No." The only way to exit the query is then to go back to design mode and than exit. How do I correct this? Previously I had written some update queries. I noticed this error message after the update queries were written. Thank you.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Error message on query exit (Access 2000)

    Are you running your queries using VBA? It sounds like it - otherwise some rogue code is being executed that you are unaware of - if it's a small database you might try posting it so we can sort out what is happening. Otherwise give us some additional details about how the query is being executed.
    Wendell

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    St. Charles, Illinois
    Posts
    222
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error message on query exit (Access 2000)

    I actually wrote some of the queries in SQL then switched back to design mode. However, I emailed the data base to myself and the error message did not appear. What bothers me is I didn't do anything to correct the error, so I am expecting the error message to return. Right now, no more help is needed. Thank you.

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Error message on query exit (Access 2000)

    It doesn't sound like you should have any code running. Do you reference any user functions in your query? That's the only thing I can think of at the moment.
    Wendell

Posting Permissions

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