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 Replies


ADVERTISEMENT

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

Shift Key Not Disabling AutoExec Macro

Feb 19, 2014

I have a DB with an AutoExec macro. I created the DB from scratch. When I open the DB from Windows Explorer with the shift key held down the AutoExec macro still runs. If I have people on other computers open the same way it doesn't run. If I open Access first then hold the shift key down it doesn't run. I couldn't find any references to a shift key issue like this. I'm looking for an answer as to why there would be a difference on my PC between opening in WE or directly in Access.

View 3 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 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

Forms :: Hiding Ribbon In Access 2007 - Variable Not Found Error

Apr 2, 2013

Code : DoCmd.ShowToolbar "Ribbon", acToolbarNo

Should hide the ribbon. Instead I get a 'Variable Not Found' error.

This should be simple.

View 13 Replies View Related

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

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 1 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 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 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

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

Calculating Shift Patterns/rosters In Access 2000

Jun 23, 2005

Hi,

I wonder if someone could point me in the right direction with this one....

I need to be able to check at any time which person is working a shift on a specific day, and whether they are working a day or night shift. In effect I have 4 engineers, who work on shifts A B C & D. All the engineers work a 4 on, 4 off shift pattern, so for example if engineer A is working day shift, engineer B will be working nightshift, C & D will be on rest days. The pattern rotates every 4 days, so in the case of engineer A:

1st - days
2nd - days
3rd - days
4th - days
5th - rest
6th - rest
7th - rest
8th - rest
9th - nights
10th - nights
11th - nights
12th - nights
13th - rest
14th - rest
15th - rest
16th - rest
...................and so on.

I need to be able to pull up a form that tells me which engineer is working which shift on a selected date -I hope I've explained myself properly. Can this be calculated 'on the fly' using VBA & a reference table or lookup? I'd prefer to do this by programming if possible.

Hope that someone can help.

Many thanks,

Mark

View 3 Replies View Related

General :: Create MDE With All Menus And Shift Key Access Disabled

Jul 18, 2014

How I can create an MDE with all options disabled including shift key bypass.

I want to remove all options in Tools>Startup except for the status bar.

I have tried using this code but am not getting anywhere with it

CurrentDb.Properties("AllowByPassKey") = 0

View 8 Replies View Related

Access 2007 Crashes On Excel 2007 Import

Mar 21, 2008

On trying to import an Excel 2007 file into Access 2007 I get the following:

1) Choose "External Data," Import, Exce
2) Select small file in MS Excel 2007 format.
3) Click on Import the source data into a new table ...
4) Choose OK

Immediately get "Microsoft Office Access has stopped working. Windows is checking for a solution to the problem..." This message never resolves, so I have to click 'Cancel'.

Then I get "Microsoft Office Access is trying to recover your information..." I have to click "Cancel" here as well and then kill MS Access in Task Manager.

Event Viewer gives following message, which is of no help:
"ID: 2, Application Name: Microsoft Office Access, Application Version: 12.0.6211.1000, Microsoft Office Version: 12.0.6215.1000. This session lasted 710 seconds with 120 seconds of active time. This session ended with a crash."

Trying to import a small Excel 2003 file leads the same result. The same happens with a CSV file.

I have uninstalled and reinstalled Office 2007 as well. I am using Vista Ultimate.

I have turned off DEP.

How can I get MS Access 2007 to import Excel?

Thanks

Ken

View 6 Replies View Related

Access 2007 Runtime Not Visible In Access 2007

Nov 26, 2007

I installed Office Enterprise 2007. Then I installed DEveloper Exrtensions, then Access Runtime 2007. All appear to have installed OK - they appear in Program and Features.
Instructions on runtime packaging tell me that a Developer option should appear in the resulting drop-down when I click the Office button (top-left round thing) when I have a d/b open in Access. It's not there! I have un-installed and re-installed the extensions and the runtime - still nothing!
Help!
I do have Runtime 2002 (XP) on the same PC, is that relevant?

View 10 Replies View Related

Disabling Access Minimize / Restore Down And Close Bar At Top Of Screen

May 26, 2015

How to hide, or disable the "Minimize", "Restore Down", and "Close" controls in the top bar (ribbon?) when previewing or viewing reports?

View 1 Replies View Related

Hiding Access

Apr 13, 2006

I'm trying to hide access(i.e. toolbars etc.), and only view a form. Is this possible?

View 5 Replies View Related

Hiding Access

Aug 26, 2006

Here's another one on this subject... But can't seem to find the answer in the "Search" Currently I am using the "Call fSetAccessWindow(0)" method.... Well, all works fine until I start getting into reports. I have read in some post of other methods to hide Access. But I have yet to find any examples of the "easier way"..... Can anyone direct me to a post or link??
Thanks
Curtis

View 4 Replies View Related

Hiding Access Environment

May 30, 2006

Hi guys, i read about this before but it did not work.

i am trying to hide the access environment but i couldnt.
i read in this forum that if i have a bmp with then same name than the db, the picture would replace the access environment. I have done this but the only thing that i achieved was to see the picter before access env. comes and then it desapears and the access env. shows up.

any suggestion?
thx max

View 4 Replies View Related

General :: Securing Frontend By Disabling Access To Linked Tables / Queries

Mar 24, 2014

I'd like to secure my frontend by disabling access to the linked tables, queries etc. I thought converting to .accde would do this but apparently not. Is there a way that this can be achieved?

I am aware that I can disbale the ribbons etc but they can all be turned back on using the options menu.

View 3 Replies View Related

Forms :: Disabling Fields In Access Based On Data Entered In A Previous Field

Sep 9, 2013

How to disable fields in Access based on data entered in a previous field? For example if "yes" is chosen from a drop down show "Date field" if "no" is chose hide "Date Field".

View 2 Replies View Related

Hiding Access ==> Must Be A Sort Of Normal Program

Feb 8, 2006

Hello All!

As in the topic stands that im looking for a code that hides Access and it starts up like a normal program. Ive searched several things on the forums and i actually did found something only he didnt gave the code ;(.

So first question:

How can i do this with a code?

Second question:

What do i need to change on my forms?

Etc etc :)

Thanks alot in advance!

View 6 Replies View Related

Hiding Access Toolbar In Form View

Aug 24, 2007

Hi.

I have a widely used application in Access 97.

Anyway, some staff are not using the forms' menu buttons but are playing around with the Access toolbar (file, edit, et cetera).
The administrator wants me to either disable that toolbar or hid eit from view. Any ideas?

Russ

View 1 Replies View Related







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