Scheduler to Automate Email Code?

[Liam.M]

I currently HAVE a form...a "Summary List" it could be called...which
is
a contineous form...AND on this form are "Four fields" from EVERY
record (each on their own line) so to seak...like a running summary of
ALL the Records in the Database!

NOW upon clicking "one" of these lines...it then opens that specific
Record in the Database...which is linked through and by a "Record ID"!
The "four fields" that are exhibited in this contineous form, and
linked by the Record ID...are":
1.Vessel Name,
2.Description,
3.Date of Issue, and;
4.Due Date!

This contineous form is powered (obviously)....by a Query (titled
QryShipsInformation)...to extract the informaiton from the database and
display it on this form! (SummaryList)

Within the Summary List or Summary form...I have created a COmmand
Button which executes a CODE that Queries the database...NOT AN ACTUAL
QUERY itself...to see if any of the DUEDATES fall within the NEXT TWO
MONTHS....if they do...then it executes an Email to ME........NOW....I
have already completed the code for the date criteria and also the
email code...and this all work...when u click the command button...all
I need help on is to somehow
Automate this Command Button to Run the Code, say for example... Once a
Week...I have
already downloaded a Scheduler...thats easy....commanded it to run the
database on a certain day and time each week...all I need to know is
how would I automate code to when the scheduler executes the
programme....the easiest option would probably be to just place on the
Form's "On Load Event" or "On
Open" event I assume.......?
Any sugesstions?
Regards
Liam.

[pietlinden]

create a macro that runs the code you want, name it AutoExec and it
will run every time the database opens. Otherwise, use command line
arguments to do it...

From the HELP file...

To run a Visual Basic for Applications procedure when you open a
database, use the RunCode action in the AutoExec macro or in the macro
that you run by using the command-line option /x. You can also run a
Visual Basic procedure when you open a database by creating a form with
a Visual Basic procedure defined for its OnOpen event. Designate this
form as the startup form by right-clicking the Database window,
clicking Startup, and then entering that form in the Display Form/Page
box.
To specify a forward slash (/) or semicolon (;) on the command line,
type the character twice. For example, to specify the password ;mjs/md
on the command line, type ;;mjs//md following the /pwd command-line
option.

What's with all the caps? Do you think we somehow don't understand
English or something? I understand it just fine... I can even read the
help file... try it sometime.