Autoexec but not a macro ??

M

mscertified

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.
 
E

Ed Metcalfe

mscertified said:
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.
Click to expand...

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.
 
J

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()
 
G

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)
 
Top