Hiding the Application When a Form is Opened

[PKW57]

Greetings,



The last time I had to design a database using Access was back in 1997 and I now have Access 2013. Needles to say, a lot has changed.

I have an AutoExec macro to open the form for the end user when the application is opened but I can't figure out how to hide the application itself. I've Googled this and found several supposed solutions, none of which I can get to work. One was done via a Macro, the other via VBA. The macro solution looked easiest but it seems the DoMenuItem command has been removed from Access 2013.

I'm familiar with VBA in Excel but my understanding is that it works a little different in Access and I wasn't able to get the VBA solution I found on the web to work.

My database file name is "Issue Tracking" and I have 5 tables related as shown below.



As I said, I have an AutoExec macro to open a form named OpenIssuesForm which contains a sub-form called IssueActionSubForm. The data source for these is a query named OpenIssuesQuery.

So there is my background information. Can anyone help explain to me how I can hide the application on opening?

And Moderators, please forgive me if I'm in the wrong section but I don't know if I'm asking a macro question or a programming question. Feel free to move this thread to a more appropriate location.

Thanks in advance for any help that is offered.

~ Phil

[June7]

For a start review https://www.accessforums.net/access/...ers-48543.html

Fairly common topic. Search forum and probably find more.

[PKW57]

Thank you!