[AccessD] Retrieve command line arguments

Gustav:

Thanks.  Just what was needed.  Three hours of research.  Four minutes of
implementation. 

Best,

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Friday, January 25, 2008 8:19 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Retrieve command line arguments

Hi Rocky

Forget the macro thing.

Use the command line switch /cmd to feed a parameter to the Access app.
Use the function Command() to read the parameter(s), if any, passed at
launch.

Use Command Line Parameters under Settings, Advanced to simulate that a
command line parameter was given when you open the mdb.

/gustav

> I want to run a function in an application (emails out reports) 
> automatically.  I see that one way to do this is to use the /x switch 
> on startup to run a macro which will run a module which could have 
> Application.Quit at the end of it.  But I can't seem to get this to work.
> And besides, I'm under the impression that macros are not PC anymore.
>
> Anyway, if I can 'see' the startup switches on the command line that 
> calls access and starts the app,  I suppose I could intercept al the 
> startup housekeeping, run the reports, send the emails and exit.
>
> Is there a way to see what the command was that started an app , IOW 
> retrieve the command line arguments ?  Or is there a better way to do
this?



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.516 / Virus Database: 269.19.11/1242 - Release Date: 1/24/2008
8:32 PM