autoexec macro

[Tanya]

Hi
I have an assignment whereby I need to open my database automatically by
creating an AUTOEXEC macro?
Can someone give me a hint as to how to accomplish this please?
Regards
Tanya

 

[bob]

1. a macro within Access ONLY works when Access is open already...if you
create a macro called autoexec within Access it will run any time Access is
open.

2. a batch file can be set to open Access (and THEN run an AUTOEXEC
macro)..the batch file needs to contain the full path to the Access mdb.

Bob

 

[tina]

maybe you need to get some clarification on the requirements of your
assignment. an AutoExec macro, by definition, is a macro that runs
automatically when the database opens. you might be able to use an AutoExec
macro in one database to run code that opens another database - but i can't
see the purpose of that, since you still have to open the first database
yourself.

hth

 

[Tanya]

Reading both your posts together has clarified this for me. I had some
understanding that an AutoExec Macro was a macro had could only run once the
db was opened and would initiate at startup and because of the wording of the
task was not sure.
I have since taken the instruction to mean that they want the form created
in the previous step to open automatically on startup and to use an autoexec
macro to accomplish this rather than going though tools>startup.
Kind Regards
Tanya

 

[tina]

you're welcome, glad the comments helped you figure it out.