Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    This should be a simple one!

    This should be a simple one!

    I make changes in a module and decide I don

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: This should be a simple one!

    You say that you exit the module, but then when you go back in the changes are still there. Yet when you close the database, apparently you are getting a "Do you want to save changes" question. I'm assuming you don't get this question when you just exit the module, which I find rather odd. My assumption at this point is that you aren't really exiting the module, you merely minimize or hide it. Which version of Access are you using?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: This should be a simple one!

    I

  4. #4
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: This should be a simple one!

    And here is another reason why I don't upgrade to Access2000! It certainly doesn't seem to be "developer-friendly". Unfortunately, I don't have it loaded on my system, so I can't be more helpful. Although it does certainly seem like the module isn't be closed until you close the database.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: This should be a simple one!

    Well I can

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

    Re: This should be a simple one!

    All you're closing in Access 2000 is the VBE window, not the module itself. And yes, this appears to be normal behavior for Access 2000.

    You can *force* a save on a module by saving the project, but it won't ask you whether you want to save the changes once the module has been named and saved the first time. The VBE project environment isn't quite as aware as a VB project is, so the only way I know of to throw those changes away is exactly what you've been doing.

    On the other hand, you can always export a module to a file and then import the file after removing the existing module, so if you're making extensive changes, that might be the best insurance.
    Charlotte

Posting Permissions

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