how only the form or report or table of access opens and nothing else such as window of access

Actually you do this in 2007:  Manually you would add the Hide command to the QAT.  Clicking the button hides the database window.  Pressing F11 brings it back into view.  If you want this to occur automatically occure when you open a database:

1. Open the database
2. Choose Office Button, Access Options, Current Database, Navigation and uncheck Display Navigation Pane.
3. Close the database and reopen it.

If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire

dear Albert D.kallal 

thank u for your response. But i am a learner of vb progrimming in access. So  plz plz post a detailed step wise procedure to write a startup code.

i am waiting for your kind response.........

On Sat, 29 May 2010 10:15:01 +0000, Albert D. Kallal wrote:

You are right. I didn't consider Tabbed forms - I don't use that mode

ever.

-Tom.

Microsoft Access MVP

>

>

>Sure this is easy and can be done with one line of code.

>

>

>

>Just make sure you set Access to be in tabbed windows mode as opposed to overlapping windows mode. (this way you never see or be able to get to the access background behind forms and reports).

>

>

>

>Uncheck the option to display the nav pane at startup.

>

>

>

>Now, in your startup code execute the following ONE LINE of code:

>

>

>

>DoCmd.ShowToolbar "Ribbon", acToolbarNo

>

>

>

>The above will hide the office button, ribbon and even the QAT. The only thing you see is the actual form.

>

>

>

>Here is a screen shot:

>

>

>

>

>

>It really easy and simple to do the above. You can even un-check the option to display the status bar below the form. Here is the same form again:

>

>

>

>

>

>So, you can much accomplish this with one line of code in your startup code. The trick here is to ensure you use Tabbed windows mode as then the access background behind can never been seen or used. So with Access 2007 and later, this is very easy.

>

>

>

>Albert D. Kallal (Access MVP)

>

>Edmonton, Alberta Canada

>

>*** Email address is removed for privacy ***

-Tom. Microsoft Access MVP

Sure this is easy and can be done with one line of code.

Just make sure you set Access to be in tabbed windows mode as opposed to overlapping windows mode. (this way you never see or be able to get to the access background behind forms and reports).

Uncheck the option to display the nav pane at startup.

Now, in your startup code execute the following ONE LINE of code:

DoCmd.ShowToolbar "Ribbon", acToolbarNo

The above will hide the office button, ribbon and even the QAT. The only thing you see is the actual form.

Here is a screen shot:

It really easy and simple to do the above. You can even un-check the option to display the status bar below the form. Here is the same form again:

So, you can much accomplish this with one line of code in your startup code. The trick here is to ensure you use Tabbed windows mode as then the access background behind can never been seen or used. So with Access 2007 and later, this is very easy.

Albert D. Kallal (Access MVP)

Edmonton, Alberta Canada

*** Email address is removed for privacy ***

On Fri, 28 May 2010 23:48:07 +0000, Amarjeet Anand wrote:

That is not possible. The closest you can get is to use a Popup window

and resize the Access window behind it, and keep it there while the

user may move the popup window. Frankly, that's a lot of difficult

work - you may be better off using a different tool.

-Tom.

Microsoft Access MVP

>i want that when user cilcks on the shortcuts, only the form or report or table of access opens, and nothing else such as window of access. i want that it opens as we open application forms opens in vb from bin where only forms executes.

-Tom. Microsoft Access MVP