MS Access VBA closes with the database when I debug and stop the debuger

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • GDC1970
    New Member
    • Oct 2014
    • 17

    MS Access VBA closes with the database when I debug and stop the debuger

    Anyone know why it does this or how to make that stop. Also It will not list properties and methods why typing.
  • twinnyfo
    Recognized Expert Moderator Specialist
    • Nov 2011
    • 3662

    #2
    GDC,

    Please explain a little better what you mean. I'm not sure I follow your questions.

    Comment

    • GDC1970
      New Member
      • Oct 2014
      • 17

      #3
      When I run code with an error, it gives me the option to debug. Once I click the reset buttom, VBA and my database closes.
      Also when typing code, it is suppose to show you Properties and Methods, SUch as
      Code:
      Me.TxtBox

      Comment

      • twinnyfo
        Recognized Expert Moderator Specialist
        • Nov 2011
        • 3662

        #4
        Try opening the DB fresh, then go to the VBA editor directly (Alt-F11). On the Debug Menu, click Compile. Fix any errors before trying to run your DB.

        If the DB still crashes, you may have to create a new DB, and copy all objects into your new DB and compile from there.

        Comment

        • GDC1970
          New Member
          • Oct 2014
          • 17

          #5
          Okay great thank you

          Comment

          Working...