Autoexec but not a macro ??

[Guest]

Is there a way to get a function to run automatically when a database opens
without using a macro or having any form?
Database will be opened and closed via Windows Task Scheduler, so it can't
display any message or form that needs any input or a response.

Thanks.

 

[Ed Metcalfe]

Is there a way to get a function to run automatically when a database
opens
without using a macro or having any form?
Database will be opened and closed via Windows Task Scheduler, so it can't
display any message or form that needs any input or a response.

Thanks.

Nope, don't think so, but other than the standard Access security warnings
what response would you need to give to an AutoExec or startup form?

You can specify a starpup macro in the command-line using the /x switch. I'm
sure there's a similar method for forms, but can't remember what it is off
the top of my head!

Ed Metcalfe.

 

[jahoobob via AccessMonster.com]

In the Autoexec macro select RunCode and in the Function space place the name
of your function with parameters in parenthesis if there are any or not, e.g:
FunctionName(1) or
FunctionName()

 

[Guest]

sure there's a similar method for forms, but can't remember

Anything you can do using DDE, you can do at
the command line. It's not documented, but take
a look at the file created if you create a desktop
shortcut to a form.

(david)