Shell.exe Command

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

    Shell.exe Command

    Using Access2002

    Using the shell.exe call to call a MYOB application and export some data.

    What is bugging me is the flickering of the screen as the shell function
    goes into MYOB to do it's thing. I have tried changing the windowstyles to
    all the different types (including the Hide), to no avail.

    I would really like to be able carry out the shell command without losing
    the focus from my Access app. Is there a way using the shell command, or
    another way??

    TIA
    Michelle


    Tags: None
    • Adrian Jansen
      #2
      Re: Shell.exe Command

      Once the other process ( MYOB ) takes over from the Shell command, then it
      controls the screen however it wants. If MYOB exposes its objects to OLE
      Automation, then maybe you can do it through that.

      --
      Regards,

      Adrian Jansen
      J & K MicroSystems
      Microcomputer solutions for industrial control
      "-Michelle-" <milkyswirl@yah oo.com> wrote in message
      news:bnurao$2hd f$1@otis.netspa ce.net.au...[color=blue]
      > Using Access2002
      >
      > Using the shell.exe call to call a MYOB application and export some data.
      >
      > What is bugging me is the flickering of the screen as the shell function
      > goes into MYOB to do it's thing. I have tried changing the windowstyles[/color]
      to[color=blue]
      > all the different types (including the Hide), to no avail.
      >
      > I would really like to be able carry out the shell command without losing
      > the focus from my Access app. Is there a way using the shell command, or
      > another way??
      >
      > TIA
      > Michelle
      >
      >[/color]


        Comment

        • Pieter Linden
          #3
          Re: Shell.exe Command

          What if you do something like

          'turn off screen repainting
          Application.Ech o False

          'Shell here
          'use Shell and Wait from
          'http://www.mvps.org/access/api/api0004.htm

          Application.Ech o True

            Comment

            • Adrian Jansen
              #4
              Re: Shell.exe Command

              I havent tried it, but I doubt it will work. The application you are
              freezing is the current application, not the one spawned by the Shell
              process.

              --
              Regards,

              Adrian Jansen
              J & K MicroSystems
              Microcomputer solutions for industrial control
              "Pieter Linden" <pietlinden@hot mail.com> wrote in message
              news:bf31e41b.0 310312029.a4d5c 3b@posting.goog le.com...[color=blue]
              > What if you do something like
              >
              > 'turn off screen repainting
              > Application.Ech o False
              >
              > 'Shell here
              > 'use Shell and Wait from
              > 'http://www.mvps.org/access/api/api0004.htm
              >
              > Application.Ech o True[/color]


                Comment

                • -Michelle-
                  #5
                  Re: Shell.exe Command

                  Thanks so much for all your comments.
                  Michelle


                    Comment

                    Previous template Next
                    Working...