Open Access file without access window

Anonymous
2019-04-11T18:52:47+00:00

I want to have my completed forms open so the user only see that form and not the Access window (nav pane, ribbon and all). I have the form selected to open on load (File>Options>Current Database>Display Forms: CompanyF) but the Access window still loads behind it. 

I've tried several different ways found through searching online, but cant get exactly what I need. I added to the CompanyF open event:

Private Sub Form_Open(Cancel As Integer)

    DoCmd.ShowToolbar "Ribbon", acToolbarNo

End Subc

This just hides the Ribbon...

I've unchecked Display Navigation Pane, but that just hides that... 

Basically, it opens like this: 

and i want it to open like this, but still be able to have a way for me(and only me) to access the Windowpane to make system edits to tables: 

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes

7 answers

Sort by: Most helpful
  1. Anonymous
    2019-04-11T20:59:32+00:00

    Thanks! Ill check those over and see what I can figure out. 

    Appreciate your assistance! :)

    0 comments No comments
  2. DBG 11,531 Reputation points Volunteer Moderator
    2019-04-11T21:25:50+00:00

    Hi. You're welcome. Good luck. Please let us know how it goes...

    0 comments No comments