Docmd.DoMenuItem

[Souris]

Does Docmd.DoMenuItem support to run Close command on File menu?
I tried to close MS Access application using VBA in the AutoExec macro.
Is it possible to do this?
Your information is great appreciated,

 

[Marshall Barton]

Does Docmd.DoMenuItem support to run Close command on File menu?
I tried to close MS Access application using VBA in the AutoExec macro.
Is it possible to do this?

Check VBA Help on the Quit action/method.

Note that DoMenuItem is an archaic holdover from way back in
Access 2. It has been superceded by other, better ways of
doing things and, if there is nothning else, the RunCommand
method.

 

[Souris]

Thanks for the message,

The Quit method quit the MS Access.
I have startup mian form automatically.
Acess still shows the auto main form before quit application.
Is it possible that MS Access quit without loading startup main form?

Thanks again,

 

[Marshall Barton]

If the form opens before the AutoExec macro performs the
Quit action, then don't make the form the start up form.
Instead put your startup code in a public Function in a
standard module.

Use the RunCode action in the AutoExec macro to call the
function. The function can then contain the code to decide
if it should quit and, if it should continue, open the form.

 

[Souris]

Thanks for the information,

If the form opens before the AutoExec macro performs the
Quit action, then don't make the form the start up form.
Instead put your startup code in a public Function in a
standard module.

Use the RunCode action in the AutoExec macro to call the
function. The function can then contain the code to decide
if it should quit and, if it should continue, open the form.
--
Marsh
MVP [MS Access]

The Quit method quit the MS Access.
I have startup mian form automatically.
Acess still shows the auto main form before quit application.
Is it possible that MS Access quit without loading startup main form?