03-10-2008, 08:25 PM
create a new macro
action="OpenTable"
hit F6
pic one your table names
do that two more times.
name that macro "autoexec"
and it'll do it each time.
if you dont want it to do that every time, name it something else and call the macro from the command line.
action="OpenTable"
hit F6
pic one your table names
do that two more times.
name that macro "autoexec"
and it'll do it each time.
if you dont want it to do that every time, name it something else and call the macro from the command line.
Quote:/x macro Starts Access and runs the specified macro. Another way to run a macro when you open a database is to use an AutoExec macro.[/quote]
Caution Macros can contain viruses, so you must be careful about running them. Take the following precautions: run up-to-date antivirus software on your computer; set your macro security level to high; use digital signatures; maintain a list of trusted sources of macros.