Open the Form Directly (1 Viewer)

[Pinkoto]

Hello, im trying to make my form open directly when i open my access file.accdb. When i double click on my .accdb can it be done to open directly and only my form. I found a way to open my form but it opens the access program in the background.

 

[Eljefegeneo]

Not sure if this is what you are looking for, but I use it for users of my db that I do not want them to see the tool bar or navigation pane. Of course, you will have to have a way of "unhiding" both of them.

'Hides the navigation pane for users who get this as the startup screen
DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.RunCommand acCmdWindowHide
'hide the tool bar too
DoCmd.ShowToolbar "Ribbon", acToolbarNo

 

[Pinkoto]

where do i write this code

 

[smig]

I'm not familiar enough with Access 2010 and up.
Create an AutoExec macro from there run the code you want.

Ypu can't hide the access window, you can only hide the window that hold all the access objects

 

[Eljefegeneo]

I have the code in the On Current event. I am not sure if that is the optimal event to use, but it works for me.

 

[Pinkoto]

i want the form to be the only thing that opens when i open my access file, not when i open my form. how can i do that?

 

[Eljefegeneo]

I am not sure exactly what you mean or why you want this, but if you set the form to be opened on start of the Access program, then it will be the only thing that appears. Go to Options, Current Db, set the display form as the form you want to open. Then with the code I gave you, it will open and no other forms will be displayed.

If this is not what you want, then it is beyond my area of expertise.

 

[smig]

You can't hide the access window