Results 1 to 3 of 3
  1. #1
    TVJohn56 is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    May 2021
    Posts
    1

    Can I save the state of the VBA Editor window

    Hi


    I've inherited an Access .adp project from someone. The issue I have is that when I go to open the VBA editor it's loading something like 400 code windows, which obviously takes an appreciable time. Is there some way I can prevent this happening?

    Thanks

    John

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I don't believe there is anything you can do about that. You are loading the whole code project when you open the editor.
    That's a whole lot of modules.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    You can close all modules using code. See Close All VBE Windows - Mendip Data Systems
    If you do that just before closing your database, next time it will open FAR faster
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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

Similar Threads

  1. Replies: 10
    Last Post: 12-05-2017, 01:14 AM
  2. Cant open VB editor window for a form
    By JmMrhw in forum Programming
    Replies: 5
    Last Post: 10-18-2017, 12:34 PM
  3. Replies: 2
    Last Post: 11-09-2016, 10:41 AM
  4. How to disable save/close window in form
    By Kivan in forum Access
    Replies: 2
    Last Post: 08-16-2012, 02:52 AM
  5. Save As Window
    By Coffee in forum Programming
    Replies: 8
    Last Post: 08-18-2011, 06:25 PM

Tags for this Thread

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