Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    jojowhite's Avatar
    jojowhite is offline Competent Performer
    Windows 11 Access 2021
    Join Date
    Jan 2025
    Posts
    430

    to reset the VBE window everytime you open the db.

    1. change the public sub in post #2 to a public function.
    2. create a macro (name it Autoexec), that do a RunCode of the Public Function in 1.

  2. #17
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    You can also add an autokeys macro entry to close all open VBE windows on demand

    See my article Close All VBE Windows
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Query Editor, Form Explorer, Rowsource editor
    By davegri in forum Sample Databases
    Replies: 24
    Last Post: 04-25-2023, 08:09 AM
  2. Replies: 3
    Last Post: 09-17-2022, 06:00 PM
  3. Replies: 9
    Last Post: 01-29-2019, 05:28 PM
  4. Replies: 2
    Last Post: 11-09-2016, 10:41 AM
  5. Replies: 3
    Last Post: 12-02-2014, 09:38 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