PDA

View Full Version : Macro to run access commands



f9073341
05-18-2009, 01:57 AM
Hi guys,

Is it possible to create a macro which, when executed, allows me to invoke the Access Import Wizard screen?

Many Thanks.

OBP
05-18-2009, 03:35 AM
It is actually easier to write the VBA code to Import something, it can include a Browser to find the "something" to Import if you need it.
What exactly do you need it to do?

f9073341
05-18-2009, 03:39 AM
I just wanted to invoke the wizard to import an access file. The logic being to get rid of as many options in the application as possible - so I can remove the menus etc.

OBP
05-18-2009, 03:48 AM
If it is the same Access file then you can set up a Command Button to do the Import for you.
Is that what you want to do?