Form only displayed when database start up

[akhlaq768]

When my database is opened, I want the form to be displayed in the middle of the screen and I want the tables, query, macro section hidden from view, but can only be accessed, if F11 is pressed….

How do I do this?

 

[gadjet]

When my database is opened, I want the form to be displayed in the middle of the screen and I want the tables, query, macro section hidden from view, but can only be accessed, if F11 is pressed….

How do I do this?

I can only partly answer this, you can define the startup form within Access and get that to autocenter on opening but I don't think you can hide the other stuff, I would make a startup form that was maximised on open but looked like it was a smaller form in the middle.

or startup with a blank maximised form and auto start another form, from that form code, a modal popup form with auto centre enabled.

Maybe a macro can give you the f11 function or VBA.

but I'm not that experienced with Access

Gadjet

 

[BarryMK]

Open the database. Select Tools Startup. Uncheck "Display Database Window" Select the Opening form from the dropdown "Display Form".

In form properties make your form pop up and select Auto centre.

 

[mahdinoori]

ok i'll send you other field