Get The Database Window Back After Hiding It.

Aug 31, 2005

Hi,

I have a question;

If I hide the Database window and uncheck the Allow Full Menu checkbox from Tools--> Startup


The next time I open the application how can I get them back?

Any help will be very appreciated,
Thanks,
CS.

View Replies


ADVERTISEMENT

Hiding The Database Window.

Jun 20, 2006

Think I've seen this posted on here recently but cant find it.

Is there a way to hide the database window so that only a form is visible?

Then if you need to view the database window you can press F11 to make it appear?

View 1 Replies View Related

Hiding Database Window And Menu Bar For Users

Jun 1, 2004

Hy,I 've develop access database with several forms.I want to make my database window invisible behind forms.Also i want to make menu bar(shows file,edit,view....etc) invisible for one reason,all operation user need to do he can do on form.Thanks for help!

View 14 Replies View Related

Hiding Access Window

Apr 15, 2008

Back in 2004 a user (sbaxter) on this forum was offering to interrested members his utility for hiding Access window. Does anyone still have a copy of this utility handy that is willing to share? Thanks in advance. See reference post

http://forums.aspfree.com/microsoft-access-help-18/hiding-database-window-and-menu-bar-for-users-29928.html?&highlight=task

Never mind, I found the code I was looking for....

View 3 Replies View Related

Hiding The Access Background Window

Mar 20, 2006

Hi,

Ok i am using the following code to hide the access window but when i do it, it also hides it from the taskbar aswell.

Is there any modifications to the code that will hide the background window but also keep it on the taskbar.

thanks
k0r54

Module: -

Option Compare Database

Private Declare Function IsWindowVisible Lib "user32" (ByVal hWnd As Long) As Long
Dim dwReturn As Long

Const SW_HIDE = 0
Const SW_SHOWNORMAL = 1
Const SW_SHOWMINIMIZED = 2
Const SW_SHOWMAXIMIZED = 3

Private Declare Function ShowWindow Lib "user32" (ByVal hWnd As Long, _
ByVal nCmdShow As Long) As Long

Public Function fAccessWindow(Optional Procedure As String, Optional SwitchStatus As Boolean, Optional StatusCheck As Boolean) As Boolean

If Procedure = "Hide" Then
dwReturn = ShowWindow(Application.hWndAccessApp, SW_HIDE)
End If
If Procedure = "Show" Then
dwReturn = ShowWindow(Application.hWndAccessApp, SW_SHOWMAXIMIZED)
End If
If Procedure = "Minimize" Then
dwReturn = ShowWindow(Application.hWndAccessApp, SW_SHOWMINIMIZED)
End If
If SwitchStatus = True Then
If IsWindowVisible(hWndAccessApp) = 1 Then
dwReturn = ShowWindow(Application.hWndAccessApp, SW_HIDE)
Else
dwReturn = ShowWindow(Application.hWndAccessApp, SW_SHOWMAXIMIZED)
End If
End If

If StatusCheck = True Then
If IsWindowVisible(hWndAccessApp) = 0 Then
fAccessWindow = False
End If
If IsWindowVisible(hWndAccessApp) = 1 Then
fAccessWindow = True
End If
End If
End Function


To call it: -

HideForm = fAccessWindow("Hide", False, False)

View 14 Replies View Related

Hiding Menu Bar And Table Overview Window

Jul 4, 2006

Dear friends,
Can someone tell me how to hide menu bar and table overview window in MS Access 2000? I tried to do it but was unable to implement it.Looking forward for your answers.
Thanks

View 2 Replies View Related

Hiding Access Window And Opening Report Preview

Nov 22, 2005

Hi,

I successfully made this work, but when opening a report to preview it (using a button click) . it doesn't show up, is there a workaround with this? Thanks in advance.

Kind Reagrds.
Nelson

View 11 Replies View Related

Hiding Access Window With DoCmd.runCommand AcCmdAppMinimize

Mar 28, 2007

Ok, I finally have it working the way I like. It's really slick - the main form (set to "PopUP" and with docmd.runcommand accmdappminimize line in the On_Open event) opens with customized icon (in titlebar and in windows taskbar) and behaves like a standalone program (you only see Access the first few seconds during opening before it's minimized).

The form can be minimized to windows taskbar and clicked to restore it (form's maximize button is disabled, for appearance sake). it can also be accessed via the alt-tab windows menu, where it also appears with a custom icon. so it's really slick, it behaves just like a standalone app. read on for the ", but..."

I also wrote 2 functions to handle reports.

1st (fnOpen, I also use it for forms, etc. via arguments, but only the reports have the following logic). This one closes my main form, maximizes Access (which has all menus/toolbars disabled, so it doesn't really look like Access, looks like a report viewer). This function is placed into all report buttons' On_Click event with report name as argument and object type (3 for report, because 0=table, 1=query, 2=form, 3=report in my fnOpen).

2nd. (fnCloseReport) is placed into all reports' On_Close event. This function opens my main form again on the tab from which report was called. It works, but herein lies the problem: after the form reopens, it no longer has the whole application's custom icon, but the Access "form" icon. And after this, if minimized to windows taskbar it actually minimizes as resized mini-window above the Start button (as has been described by others, just as it would within Access it it were visible) and Access appears minimized in the windows taskbar, so somehow the whole cool "standaloneness" is turned off.

I wonder if anyone has some suggestions for this. I spent some time researching and testing this and really like the functionality. When the form is displayed without Access, it cannot be right-clicked (at all), which is very useful (although I know there are other ways of protection).

BTW, all my other windows (all popup/modal) appear on top of the main form with no problems. I have "File Open" and "Save As" windows common dialogs that my app calls (via API) and I also have a custom form acting as dialog box (I use the acDialog intrinsic constant when I open it from code). so mutliple windows are not an issue as some have suggested.

Thanks in advance!

View 3 Replies View Related

Access 2007 - Disabling Shift Key And Hiding DB Window

Jan 1, 2008

Hi,

I have a couple of databases set up with shift key bypass and DB window hide and a couple of menu bar commands hidden (All code taken from this great forum :) ). Recently my company decided to upgrade Access 2000 to Access 2007 and they have given me a test environment and a time frame to convert / test all my applications.
I found this concept of ribbon and office links very different and shocking.
Is there a way of hidding somethings that you can do with the office links (like compact and repair) and a way of hiding some clusters in the ribbon (like export and import data, have a dtaasheet view of any form? etc) Any help or link along these lines would be helpful..
Thanks,
Priya

View 7 Replies View Related

Hiding Close Button When Form Window Maximised

May 8, 2006

Hi,
Anyone know in microsoft access 97 is it possible to remove the close button (top right hand corner) when a form is maximised?
Thanks.

View 1 Replies View Related

Access 2013 - Hiding And Showing Access Window

Apr 6, 2015

I am trying to Hide or Show the Access Window by using two buttons on a Form. Running Access 2013 in Windows 7 64bit.

I have used code from the Internet as below but added the PtrSafe item to the Function Declaration as below:-

Option Compare Database
'Hide Access desktop screen and float Forms on pc desktop
Private Declare PtrSafe Function IsWindowVisible Lib "user32" (ByVal hwnd As Long) As Long

Dim dwReturn As Long
Const SW_HIDE = 0

[Code] ....

I then have two buttons on a form coded as below:-

Option Compare Database
Private Sub cmd_Hide_dbw_Click()
Call fSetAccessWindow("Minimize", False, False)
DoCmd.OpenForm "frm_Test", acNormal
End Sub

[Code] .....

I have attached a Test Database which demonstrates the problem I am experiencing.

Do the following sequence...............

Open the Test Database. DO NOT ENABLE CONTENT
The Access 'Ribbon'Test_Database.accdb is active and usable
Open frm_Test in Design View in order to inspect, all should be as shown above.
Now click the Enable Content warning
Switch frm_Test to Form View

Click button Hide dbw. Closes the Access Window
Click button Show dbw. Opens the Access Window...HOWEVER....

Attachment 20252The Access Ribbon is locked and usable !!!

I cannot find a way to re-activate the Ribbon

View 2 Replies View Related

Hiding The "import" Window

Apr 12, 2006

Below are my codes to display bitmaps in a MS Access form by just inserting the path to the image.

[Code].....

The output is attached in the jpeg file. However, as u can see from the jpeg, when i move from 1 record to another, the importing picture from "path name" keeps appearing when loading and disappears after the record is loaded.. How can i prevent tat window from appearing?

View 3 Replies View Related

General :: Locked Database - Hiding Navigation Pane

Sep 3, 2013

I've got a database that is locked down for all users with forms so they can navigate the system and the navigation pane is hidden. On a couple of the forms there are buttons to print the form and when that button is clicked it unhides the navigation pane...???

View 2 Replies View Related

Database Window Help

Mar 12, 2006

hi

ive been disabling the database window from the startup tab in MS access, just now when ive tryed to show it on startup it appears but its stuck in the top left hand corner and i cant move it! so i cant access the tables

help any1 pleassse

View 1 Replies View Related

Database Window

Mar 13, 2007

I've imported somebody's access db which hides the database window by default. When I click the db window button in the toolbar, the db window pops up high up and is somewhat hidden by the toolbar. I can't pull it back down as the top is hidden and when I try to move the toolbar,the db window simple moves up so I can't grab it and move it. Any suggestions?

scratch

View 1 Replies View Related

Database Window?

Apr 14, 2008

This may seem silly and I've seen no mention of it in this forum yet but the "Database Window" from previous versions of Access is now called the "Object Browser"? I had code to hide the database window on startup but can't seem to find a way to hide the object browser on startup. Any ideas? Also, is there another way to view my objects in ACC07 because this way is slowing me down tremendously! It's much more difficult to find the objects I'm trying to work on and visually see where I left off. Any help would greatly be appreciated! Thanks in advance.

View 6 Replies View Related

How Unhide Database Window

Sep 13, 2006

Dear Friends I made my a stupid mistake and I don't know how to rectify it.

There is a inventory software built in access xp. In order to protect database I've cleared all the options from that is

a) Display Startup form
b) Display status bar
c) Allow Full menus(Changed with Custome Menu)
d) Allow Default shortcut keys
e) and foolish thing cleared Use special key also

I've given a task to modify program where I may have to add New form. I don't know how to unhide database window. pls suggest me what to do....

View 2 Replies View Related

Database Window Not Opening

Dec 13, 2006

I have a weird problem with one of my databases. Out of a sudden, when I wanted to open that database the databse window did not show up anymore. With this I can not access my forms, tables etc. any longer. However, when I click on View->Databaseobjects and choose e.g Forms than I can click on the code icon and I can access my code as well as the corresponing form in the design view. I can not access the tables but when I click on the "show fields" in the design view the list of fileds is showing for the corresponding form.

I tried that database on 3 different PC's with the same effect.

Does anybody have an idea what could have caused that the database window is not showing anymore and/or how could I bring that window back.

Thanks for any help and advice

Josef

View 2 Replies View Related

Hide Database Window

May 9, 2006

I need to find a way to not allow users to access the backend by using the database window. Is there a way I can password protect this?

Thanks

View 5 Replies View Related

Database Window Missing

Mar 29, 2006

Hi,

Can anyone tell me how to display the database window that shows all the forms, queries, tables etc in a database?

I have an Access database with startup restrictions and startup login screen. I can open the database by holding down the SHIFT key to bypass the startup options but when Access opens there appears to be no Database Window. I can create new objects in the database ok its just that there is no main database window from where I can browse objects. This is driving me mad - i know it's probably something simple but I rarely work with access

thanks
Maracatu

View 5 Replies View Related

Hide Database Window

Feb 23, 2007

I am looking to minimize the access window when my database is opened. I already set it to do that from the startup menu, but all that did was open my specified form on open. I want it to actually only show my form w/ acces on the startup tray. Any suggestions?

View 14 Replies View Related

Password Protect Database Window??

Sep 6, 2005

Hi,

How can I hide the Database window with password protection?

For example, if someone attempts to access the Database Window, they would be promted to enter the password before they can see the tables and queries...


Thanks for your help

View 1 Replies View Related

Preventing Access To Database Window

Oct 13, 2005

I have an Access FE app with an Access BE.

I need urgent suggestions as to how to prevent access to the database window even when the SHIFT key is pressed when loading the app.

This is very important so as to increase data security and prevent unauthorised data change by users.

Thanks for the expected response.

Peter
Nigeria

View 2 Replies View Related

Start Up Database Window Problem

Jan 18, 2006

I recently created a database to be posted on a network. In order to eliminate users prying into the mechanics of the database, I unclicked some menus on start up. The database is also password protected. I did such a good job that now I can't get into the database window myself. I used shift while opening the database, which used to work, but now I get the password box which brings me to the switchboard form. F11 doesn't work either.

Does anyone know how I can reverse this process so I can get into my database window and get full menus again?

View 3 Replies View Related

Please Help, How To Stop Database Window Poping Up

Mar 22, 2006

Hi
We have recently upgraded our computers and therefore reinstalled Office on the new machines. The opreating system is Win XP + patch 2. The version of MS Access is 2002

For all our databases I have chosen to hide the database window, so other user don't accedentally change tables and queries etc. Now the problem is, with the new computers, whenever I minize the database and then open it, the database weindow pops up right on top of every thing else automatically.

I have no idea why this happens and how to stop it. Could any one please shed some light. Your help would be apprecialted.

Regards

Airdesign

View 3 Replies View Related

Database Window Not Coming To Front

Sep 15, 2006

This is I think a very simple query.

with a number of forms/ queries etc open and you click on at the back it is not coming to the front for amendment.

It is probably an indicator somewhere but I just can't find it

any help appreciated

Ta

humph

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved