Dan Waters
dwaters at usinternet.com
Fri Jan 25 09:13:12 CST 2008
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