application minimization is not working

[joshynaresh]

Hello Sir,
i am using
code

DoCmd.RunCommand acCmdAppMinimize

for minimize application.
It works properly when my form open in normal mode but in dialog mode it is not working.
Thanks in Advance

[drunkenneo]

Hello Sir,
i am using
code

DoCmd.RunCommand acCmdAppMinimize

for minimize application.
It works properly when my form open in normal mode but in dialog mode it is not working.
Thanks in Advance

It should work, And probably the properites>other>Modal is yes, it should be no.

[joshynaresh]

Properites>Other>Modal is no. but not working.

[drunkenneo]

If u send me the mdb then i can do somthing, remove all confodential

[joshynaresh]

i'm sending sample database for analysis.
SampleDB.zip

[joshynaresh]

Hello sir, Plz help me. I have already sent Sample Database for analysis.
Thank You.

[drunkenneo]

Sorry mate, i was too busy in my own new project. I have seen the situation and couldnt b able to resolve the same...it have a strange behaviour...hope someone knows it

[June7]

When I first opened the db the minimize code would not work.

I closed and reopened and got an error about broken reference to MSCAL.OCX. I think that is something to do with a calendar. I just OK and the minimize code works.

I removed the VBA reference and now the minimize code not working. I opened the form from navigation pane and minimize code works.

The AutoExec macro opens form as popup (dialog mode) if the db is not trusted. The popup seems to be cause of issue. Why should trusted or not trusted determine how form opens?

[joshynaresh]

it's only my sample database. in my orignal database when it is not trusted msg displayed for making trusted. after db become trusted everyfunction works properly except minimizing application. I want, it should work in trusted db on dialog mode (It works properly in normal mode). Is it possible?

[June7]

Apparently not. I just tested it with VBA opening form in Dialog and it also fails. Maybe has something to do with fact Dialog suspends code execution in the calling procedure.

[joshynaresh]

What Should I have to do on VBA Code.
Thank You

[June7]

It doesn't work when form is opened in dialog mode. Period.

[joshynaresh]

Do you know any causes of this behavior?

[June7]

I presume it is how Access is programmed. Have to ask Bill Gates why.