Automating an Access App launch

Re: Access 2003

I have an Access app that runs a boatload of processing using two
command buttons.
"Button A" connects to Oracle, and brings in data via SQL code and
populates a table.
"Button B" processes all of the imported data from Oracle and produces
an Excel export based on calculations, etc.

I have not launched Access apps from the command line, but will need
to so I can put it in Windows Scheduler to run daily while I am on
vacation.

I want to put an "If" statement at the beginning of button B that says
basically, "if this session was launched via a command line or Windows
Scheduler, to go ahead and run the logic in button B after button A is
completed.

If this app is launched via a command line, how do I go about
populating a variable in code to fire button B when the app is run
from a command line?

thnx...
.

Relevant Pages

  • Please Help - Command Buttons fail!!!
    ... I had an Access app which was saved in 2000 file format. ... I used the Tools menu to convert it to a 2002 file format. ... >command buttons for Find/Replace, Add New Record, Delete ... >database with new command buttons and still the same. ...
    (microsoft.public.access.forms)
  • Re: Quitting access...
    ... assumed that issuing the command application.quit whereever in code etc... ... it exits the entire Access app. ...
    (microsoft.public.access.formscoding)
  • Re: Automating an Access App launch
    ... I have an Access app that runs a boatload of processing using two ... "Button B" processes all of the imported data from Oracle and produces ... I have not launched Access apps from the command line, ...
    (comp.databases.ms-access)
  • Re: Packaging a secured access app
    ... I just did write entire command line. ... Security is working, without a password you ... >> I have an access app that requires the use of command line switches ... >> I'm trying to run the packaging wizard using the access 2003 developer ...
    (microsoft.public.access.devtoolkits)
  • SUMMARY: sudo version 1.6.7p5 : using -H -u options on Solaris 8
    ... Many thanks to those that responded, as expected all responses were helpful. ... This will allow you to do the thing that the user oracle requires while also ... designated in the sudoers file who requires to use the command, ... there is a CLASSPATH variable set which, as the oracle user I can see by ...
    (SunManagers)