Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Fri Jan 25 09:32:57 CST 2008
Dan: They'll be using (I assume) Windows scheduler to start it up, send the emails, and close. When the app opens I need to know if its for use by a user, or to run the emails and close. I figure a command line option is just the ticket. But I need to be able to retrieve the command line that started the app to those options, if they're there. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Friday, January 25, 2008 7:13 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Retrieve command line arguments Rocky, I use a startup form (hidden). In the Open event for that form, I have a long list of Calls to other procedures and functions, which do a myriad of things - including send out reminder emails if this is the first time the db has been opened for the day. This has been a straightforward and reliable method so far! HTH! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Friday, January 25, 2008 8:53 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Retrieve command line arguments Dear List: 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? The automated email sender has to be part of the larger app - originally it was split off for development purposes, but now, it's part of the design that it should be integrated into the application. MTIA Rocky -- 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 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