Gary Kjos
garykjos at gmail.com
Fri Jan 25 09:21:51 CST 2008
Does it HAVE TO be in the same database? How about a seperate database that links to the same tables in the original and then when you open that "Automail" database it runs and sends the reports and then exits. GK On 1/25/08, Rocky Smolin at Beach Access Software <rockysmolin at bchacc.com> wrote: > > 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 > -- Gary Kjos garykjos at gmail.com