Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Access 2007
#1
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
pi
#2
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]
An old blog on QM coding and automation.

The Macro Hook
#3
nice.
and my macro is arranging the windows Smile
pi
#4
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.
pi
#5
i dont know. but you can try this as a starting place.

SELECT MSysIMEXColumns.*
FROM MSysIMEXColumns;
An old blog on QM coding and automation.

The Macro Hook
#6
how do i export the macro ?
pi
#7
i dont think you can. you just have to call it via command-line param.
An old blog on QM coding and automation.

The Macro Hook


Forum Jump:


Users browsing this thread: 1 Guest(s)