Access startup window

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Quick question...

When I execute a macro from the command line is there a way from the Access
windows not to be displayed?

ex: c:....\access.exe /Nostartup /x macro1
in the above I'd like to see the macro executed without the access
environment windows to come up.

Any help appreciated!

Jeff
 
That I'm not a VBA expert... where would this be added and how then would I
use it? Thanks for the direction... it's being challenging me for a while!

Thanks,
Jeff
 
Copy the code on that webpage and paste into a new module. Give the module a
name like, say:

basWindowManipulation

Instead of calling a macro in your shortcut, call it from a Startup form
(which can be hidden if you like) In the Startup form's Load or Open event,
add the code:

Call fSetAccessWindow(SW_HIDE)

That's it. Try to learn some VBA coding. It's orders of magnitude more
versatile than macros.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
 
Back
Top