Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Fri Jan 25 08:52:30 CST 2008
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