Access startup window

[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

 

[Arvin Meyer [MVP]]

You'll need to write some VBA code:

http://www.mvps.org/access/api/api0019.htm

 

[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

 

[Arvin Meyer [MVP]]

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