VBA Script Editor Opening

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Ben
    #1

    VBA Script Editor Opening

    Hi!

    Just recently, I received complaints from users that every now and then the
    VBA script editor pops out for no reason. I made sure that the breakpoints
    have all been cleared before compacting the MDB application.

    I have tried to performing the linking of tables and compacting before I
    install them in the user's workstation. But they are still seeing the VBA
    script editor every now and then. Mostly, after the first occurence, it
    does not appear or open anymore.

    I do not have any clues on the cause of this issue.

    Any help is appreciated. Thanks.


    Tags: None
    • KLZA
      #2
      Re: VBA Script Editor Opening

      First track your errors. Remove the on error goto function and trap
      the error, next identify the error. after identifying your error,
      fix it. if you cannot fix it and can live with the error, make the
      error function goto end sub..
      ie...
      On Error GoTo
      End sub

      Ben wrote:
      Hi!
      >
      Just recently, I received complaints from users that every now and then the
      VBA script editor pops out for no reason. I made sure that the breakpoints
      have all been cleared before compacting the MDB application.
      >
      I have tried to performing the linking of tables and compacting before I
      install them in the user's workstation. But they are still seeing the VBA
      script editor every now and then. Mostly, after the first occurence, it
      does not appear or open anymore.
      >
      I do not have any clues on the cause of this issue.
      >
      Any help is appreciated. Thanks.

        Comment

        • Roger
          #3
          Re: VBA Script Editor Opening

          On Jun 19, 2:36 pm, KLZA <clawd...@gmail .comwrote:
          First track your errors.  Remove the on error goto function and trap
          the error,  next identify the error.  after identifying your error,
          fix it.  if you cannot fix it and can live with the error, make the
          error function goto end sub..
          ie...
          On Error GoTo
          End sub
          >
          >
          >
          Ben wrote:
          Hi!
          >
          Just recently, I received complaints from users that every now and thenthe
          VBA script editor pops out for no reason.  I made sure that the breakpoints
          have all been cleared before compacting the MDB application.
          >
          I have tried to performing the linking of tables and compacting before I
          install them in the user's workstation.  But they are still seeing the VBA
          script editor every now and then.  Mostly, after the first occurence,it
          does not appear or open anymore.
          >
          I do not have any clues on the cause of this issue.
          >
          Any help is appreciated.  Thanks.- Hide quoted text -
          >
          - Show quoted text -
          make a backup copy of the mdb
          then use the /decompile switch (google this group for more info) on
          your mdb

          I seen cases where it will stop during execution and open the VBA
          window at a line where I previously had a breakpoint... the above
          fixes this

            Comment

            • Ben
              #4
              Re: VBA Script Editor Opening

              I have decided to try the undocumented /decompile switch. I have backed up
              MDB app and have deployed to all workstations. I should know in a week how
              it goes.

              For forum sake, I will let this forum know how it goes.


              "Roger" <lesperancer@na tpro.comwrote in message
              news:99748f21-5140-4768-8297-8318457f4d53@f3 6g2000hsa.googl egroups.com...
              On Jun 19, 2:36 pm, KLZA <clawd...@gmail .comwrote:
              First track your errors. Remove the on error goto function and trap
              the error, next identify the error. after identifying your error,
              fix it. if you cannot fix it and can live with the error, make the
              error function goto end sub..
              ie...
              On Error GoTo
              End sub
              >
              >
              >
              Ben wrote:
              Hi!
              >
              Just recently, I received complaints from users that every now and then
              the
              VBA script editor pops out for no reason. I made sure that the
              breakpoints
              have all been cleared before compacting the MDB application. I will
              >
              I have tried to performing the linking of tables and compacting before I
              install them in the user's workstation. But they are still seeing the
              VBA
              script editor every now and then. Mostly, after the first occurence, it
              does not appear or open anymore.
              >
              I do not have any clues on the cause of this issue.
              >
              Any help is appreciated. Thanks.- Hide quoted text -
              >
              - Show quoted text -
              make a backup copy of the mdb
              then use the /decompile switch (google this group for more info) on
              your mdb

              I seen cases where it will stop during execution and open the VBA
              window at a line where I previously had a breakpoint... the above
              fixes this


                Comment

                • Ben
                  #5
                  Re: VBA Script Editor Opening

                  It seems that the /decompile switch worked in solving the erratic popping
                  out of the VBA editor during the app's execution.

                  Thanks to all.


                  "Ben" <pillars4@sbcgl obal.netwrote in message
                  news:UHx6k.2087 $LG4.761@nlpi06 5.nbdc.sbc.com. ..
                  Hi!
                  >
                  Just recently, I received complaints from users that every now and then
                  the VBA script editor pops out for no reason. I made sure that the
                  breakpoints have all been cleared before compacting the MDB application.
                  >
                  I have tried to performing the linking of tables and compacting before I
                  install them in the user's workstation. But they are still seeing the VBA
                  script editor every now and then. Mostly, after the first occurence, it
                  does not appear or open anymore.
                  >
                  I do not have any clues on the cause of this issue.
                  >
                  Any help is appreciated. Thanks.
                  >

                    Comment

                    Previous template Next
                    Working...