Macro - Run App

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an AutoExec macro that fires when my database is opened. I have a
command line that uses the "Run App" command. The program that I am starting
needs to be minimized to the taskbar once started. Is there any way to add a
command to this command in my macro that will automatically minimize the app
instead of having the user minimize it?
 
I have an AutoExec macro that fires when my database is opened. I have a
command line that uses the "Run App" command. The program that I am starting
needs to be minimized to the taskbar once started. Is there any way to add a
command to this command in my macro that will automatically minimize the app
instead of having the user minimize it?
Click to expand...

DoCmd.Minimize
 
That minimizes my access database. I need to just minimzie the program I'm
firing from my macro, not the access database.
 
If you use the shell function instead of runapp, you can provide it with a
parameter controlling the size of the App
ie
shell("notepad.exe",6)

HtH

Pieter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

switch focus to query through VBA 3
Stopping or Restarting an Access App From Command Line 2
Can I tell whether Access was opened by Word? 7
Access Automatically Send a notification email once a record is added 0
Switchboard Minimized 4
Windows 8 (cross-post from w2k forum) Running .bat files minimized from scheduler - in windows 8 (x64) ?? 0
AutoExec? 8
running access 2007 in batch file 1

Back
Top