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

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@yahoo.com> wrote in message
news:bnurao$2hdf$1@otis.netspace.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]

re: Shell.exe Command

What if you do something like

'turn off screen repainting
Application.Echo False

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

Application.Echo True

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@hotmail.com> wrote in message
news:bf31e41b.0310312029.a4d5c3b@posting.google.co m...[color=blue]
> What if you do something like
>
> 'turn off screen repainting
> Application.Echo False
>
> 'Shell here
> 'use Shell and Wait from
> 'http://www.mvps.org/access/api/api0004.htm
>
> Application.Echo True[/color]

re: Shell.exe Command

Thanks so much for all your comments.
Michelle