Results 1 to 6 of 6
  1. #1
    Cotswold is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Dec 2020
    Location
    Cotswolds, England
    Posts
    1

    No save option for modules

    Hi, I'm using Access2010. If I create or amend a module I do not get the [Yes] [No] [Cancel] popup window.


    I have to close the database to save any changes.

    Is there a way around this, so I can save without closing?

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    2,923
    Select Save, under File

    Alternatively you could use Ctrl+S
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    781
    I have a OCDish habit of hitting ctrl s about every 10 seconds when I'm doing just about anything on a computer, and especially when I'm developing or working in an m$ office app.

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    8,737
    I think you will find that it's normal behaviour for the vb editor to save any changes when you close it and I don't think there's any option around that. AFAIK, there is no such thing as 'undoing' by not saving before closing - at least with Access 365. I do save periodically too because I wouldn't rely on an auto save thing to save any code changes after a crash. BTW, you don't have to close the db to experience this; just the editor.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

  5. #5
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    781
    Doesn't it have to save before it'll compile or run code anyway? I could be way off base here...

  6. #6
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    8,737
    I don't know since I don't rely on closing to save. It's always been my impression that a compile wouldn't save so I've always saved first then compiled just in case there was a crash when I compiled. Since closing seems to save anyway, I'd say there's no way to know.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    Iím telling everyone it's good to eat dried grapes. Itís all about raisin awareness.

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

Similar Threads

  1. Closing Form Save Option
    By dweekley in forum Access
    Replies: 2
    Last Post: 05-08-2017, 03:25 PM
  2. Option Buttons & Save Values
    By Bentley in forum Forms
    Replies: 4
    Last Post: 09-29-2016, 01:46 AM
  3. When to use standard modules vs. class modules
    By Access_Novice in forum Programming
    Replies: 7
    Last Post: 01-03-2016, 10:47 PM
  4. Can't see my modules as option run in a Macro
    By Meteo in forum Programming
    Replies: 4
    Last Post: 10-26-2012, 02:43 PM
  5. Print,save as and export option in report?
    By sunny in forum Reports
    Replies: 1
    Last Post: 07-27-2010, 09:55 AM

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 - Senior Forums