Open MyForm and Hide application make only Form Visible, is this possible like in excel?

[pedie]

Hi, can I make vba open MyForm and Hide application...
Make only Form Visible, is this possible like in excel?
If yes what is the event i need to use and how to code in access?


Please help. Thanks in advance.

It is quite easy in Excel

[/FONT]
[FONT=Courier New]Option Explicit[/FONT]
[FONT=Courier New]Private Sub Workbook_Open()
 Userform1.Show
 Application.Visible = False
End Sub

 

[xenou]

Generally, no. You can hide objects such as tables and show only forms. You can also hide the navigation pane. This doesn't hide the entire application though.
ξ

 

[alansidman]

You can also disable almost all of the Ribbon.

Alan

 

[pedie]

Hi Xen, hi Alan, thansk for letting me know that.
How do I set it to hide ribbon and show only form then?
And if user closes the form the whole application connected also closes.

Thanks again.
If explaining may take a longtime then a link of site would also be really great!!!

 

[xenou]

hiding the navigation pane:
http://office.microsoft.com/en-us/access-help/show-or-hide-the-navigation-pane-HA010235717.aspx

This removes objects from view - as noted in the link, you will then have to provide navigation aids for your user (such as a switchboard). This is often done by a form that opens automatically at startup, with buttons to open other forms. Or for a very simple application, perhaps the user only needs to see a single form or table when the database opens, and that is what you show at startup.

startup forms:
http://office.microsoft.com/en-us/a...-data-access-page-at-startup-HP005188501.aspx
http://www.techonthenet.com/access/forms/startup.php

 

[pedie]

Xen, exactly what I was looking for thanks alot! I didnt know at all how access works then. I was relating to excel [Norie once told me not to but can't help when there is no idea at all how to proceed...]

Thanks again.

Hmmm, I have seen someone do this but not sure how to completely hide/not show the back part of access/table..just the form...

Is there a link for that too?

Thanks again

 

[alansidman]

As Xenou indicated, if you hide navigation, then the objects are not available to the user. To hide the ribbon, click on the Office Button in 2007 and I think File in 2010. Then go to Options and This database. From there are option buttons to turn on and off certain features in Access.

Alan

 

[pedie]

As Xenou indicated, if you hide navigation, then the objects are not available to the user. To hide the ribbon, click on the Office Button in 2007 and I think File in 2010. Then go to Options and This database. From there are option buttons to turn on and off certain features in Access.

Alan

Thanks again. Almost everything...but home tab wont go...when i minimize tab looks better but want to hide home tab too.
And one more thing. I want the form to pop up but it opens as a page, how can i make it pop up?

 

[alansidman]

I don't know how to make the Home tab go away. I have not been able to do that. I did read about customizing ribbons awhile ago. I will search for that link and add to this thread. Found this: http://www.access-programmers.co.uk/forums/showthread.php?t=151711

In the same section that you removed the ribbon, there is an option to show the objects as Tabs, uncheck that box.

Alan

 

[pedie]

Thanks again so much Alan. Trying it agian