Prevent Access Window from launching after a form is maximized and more

Question

Fellow Accessors.

I have a form that is working fine. We are using the ShowWindow API. When the form is launched we are not showing any access objects to the user. When I minimize, the custom Icon we have also shows in the tool bar. When we maximize the application, it still works fine BUT IF WE HIT THE custome ICON, it brings back he application plus all of the access objects.

It makes no difference if we use Popup Yes and Modal Yes or popup Yes and Modal No.

All we want to do is make this work like a real app - no presentation of anything from access.

Any suggestions would be appreciated.

Thanks

MG

Answer 1

You may be fighting the windmills to some extent, but there is a promising technique you could investigate: hiding the Access window behind your Popup form:

http://stackoverflow.com/questions/12012978/access-2010-hiding-the-access-window

http://www.tek-tips.com/faqs.cfm?fid=2562

---

-Tom. Microsoft Access MVP

Answer 2

Hi mg30,

According to your description, I have reproduced this issue, this workaround is

To show the database window, run

    Docmd.SelectObject acTable, , True

To Hide the database window, run

    Docmd.SelectObject acTable, , True
    Docmd.RunCommand acCmdWindowHide

In addition you could submit any feedback to Access UserVoice:

https://access .uservoice.com/

Thanks for your understanding. 

Answer 3

Hi David,

Thx for the info but we were trying to hide the entire Access window that is in the background.

We never really got anything to work correctly so we took a different approach.

MG

Answer 4

Hi mg30,

According to your description, I think that Access Com Object has no feature to support to hide the entire Access window, so you use ShowWindow API. I have found some sample code use ShowWindow API to hide the entire Access window, but they are failure after I tested. I am not able to find any good solution to overcome this issue, this issue is Access design issue.

So I suggest you to submit any feedback to Access UserVoice:

https://access .uservoice.com/

Thanks for your understanding.

Answer 5

Hi David,

Yes. We agree with your findings as well. thanks for sharing.

MG

Answer 6

Hiding the Access window is getting harder with each new version. I suggest you not try to hide it and just hide the Ribbon and fill in the Application Title property in the database properties. The result will be a main title bar with the Application Title and nothing else.

Further VBA programming can make sure the Navigation pane and native tabs stay hidden.

---

Bill Mosca
www.thatlldoit.com
http://tech.groups.yahoo.com/group/MS_Access_Professionals

Answer 7

Thanks  Bill

Answer 8

Thanks  Bill

You're welcome, MG. Post back if you need some code examples.

---

Bill Mosca
www.thatlldoit.com
http://tech.groups.yahoo.com/group/MS_Access_Professionals