[AccessD] Copy and execute from Access

As I understood it, JC wanted to open his CopyExecute via a Shortcut and not have the 
CopyExecute flash up on screen.  My solution does that.


On 24 Dec 2011 at 7:39, William Benson (VBACreations. wrote:

> But that shortcut... how do you execute it from code, which I think was the
> original plan?? 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
> Sent: Saturday, December 24, 2011 4:46 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Copy and execute from Access
> 
> You need two steps:
> 
> 1. Hide on Startup. You can call the following function from an Autoexec
> macro:
> Option Compare Database
> Option Explicit
> Const SW_HIDE = 0
> Const SW_NORMAL = 1
> Const SW_MINIMIZED = 2
> Const SW_MAXIMIZED = 3
> 
> Private Declare Function ShowWindow Lib "user32" _
>   (ByVal hwnd As Long, ByVal nCmdShow As Long) As Long
> 
> Function Startup() As Long
>    Call ShowWindow(hWndAccessApp, SW_HIDE)
> End Function
> 
> By itself, that shows a flash of Access as it opens.  Tou get rid of that
> flash, create a shortcut 
> to the Access application, set it's "Run:" property to Minimized.    Open
> your application via 
> the shortcut and you  shouldn't  see a thing.
> 
> -- 
> Stuart
> 
> 
> On 23 Dec 2011 at 3:18, jwcolby wrote:
> 
> > I have written a small app that allows me to define an access application
> and the file(s) that make 
> > it up, and a destination directory to copy it to.  A shortcut opens the
> access CopyAndExecute.mdb 
> > and passes in a command line argument which is looked up in a table.  The
> recordset opened then 
> > defines what files to copy, the source and destination, the FE to execute,
> and then opens that app.
> > 
> > It all is working now however I would like CopyAndExecute to open
> invisible.  ATM it opens as a 
> > normal Access application which can be seen until the target FE is up and
> running and CopyAndExecute 
> > closes.
> > 
> > Is there a way to cause Access to open invisible?
> > 
> > -- 
> > John W. Colby
> > Colby Consulting
> > 
> > Reality is what refuses to go away
> > when you do not believe in it
> > 
> > -- 
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> > 
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>