Posts: 1,271
Threads: 399
Joined: Mar 2003
do you know a trick how to open a mdb with lets say 3 tables opened.
its annoying to perform the same clicks every time.
i tried acc, but that is very slow (can't be my cpu - quadcore)
thanks
Posts: 1,769
Threads: 410
Joined: Feb 2003
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.
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.
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.
[/quote]
Posts: 1,271
Threads: 399
Joined: Mar 2003
nice.
and my macro is arranging the windows
Posts: 1,271
Threads: 399
Joined: Mar 2003
ken, do you know a more informative tool for mdb files ?
where you can see data and field types in a time.
in access i always have to switch between views.
Posts: 1,769
Threads: 410
Joined: Feb 2003
i dont know. but you can try this as a starting place.
SELECT MSysIMEXColumns.*
FROM MSysIMEXColumns;
Posts: 1,271
Threads: 399
Joined: Mar 2003
how do i export the macro ?
Posts: 1,769
Threads: 410
Joined: Feb 2003
i dont think you can. you just have to call it via command-line param.