Automatically "Restore Down" Access Window

Jan 6, 2005

Hi all - I have my DB on a large network with many pc's and I need to set it so it when users open the program, the DB window will automatically "Restore Down" to a height and width I specify. Is there a way to code this in the DB itself? Any ideas would be great. Thanks.

View Replies


ADVERTISEMENT

Restore Window Problem

Oct 27, 2006

Hi there, i have looked into this but can't find a real solution. I have decided to keep certain of my forms maximised. I have tried pop up, or just have it ordinary sized but this doesn't work for my purposes.

So, the problem is that when the form is maximised, no matter what you do, you can't get rid of the "Restore Window" button in the menu bar. I have tried to make a workaround by putting "DoCmd.Maximize" in the Resize event of the form. The strange thing is that the event does fire but the form doesn't get maximised. Any idea why this is happening and what I could do to solve this issue?

View 3 Replies View Related

Restore Window Size On Close

Jan 12, 2006

Hey guys,

I figured out to maximize a window when a report is opened, but now I want to restore the window sizes when this report is closed.

I think I kind of know what to do with the DoCmd.Restore and something about OnClose, but I'm lost in the syntax. If someone could help me out by giving me the syntax and where to put this code that would be fantastic :)

View 2 Replies View Related

Reports :: Remove Restore Window Icon On Report Menu Bar

May 2, 2013

I have created a custom menu used on my reports which contains all the icons I need and anchored them to the right side of the report. I have been able to remove the min, max and the close icons from the default report menu bar at the top right hand side as well as the "Ask A Question" dropdown. But I am not able to remove the "Restore window" button that comes with the report print preview.

How do I remove the "Restore Window" icon from the report's menu bar?

I'm using Access 2003...

View 3 Replies View Related

Forms :: Disable Or Hide Minimize / Restore And Close Window Buttons On A Form

Mar 9, 2014

I need to disable or hide the restore, minimize and close window buttons found in the top right hand corner of a form.

I navigation buttons that controls open, close etc already set up.

View 4 Replies View Related

Restore Menu When Removed Using ACCESS OPTIONS

Aug 9, 2011

Is there any way to restore menus/editibility when they have been removed using ACCESS OPTIONS > CURRENT DATABASE then uncheck 'allow full menus'? Database was created in Access 2007. I always keep a back up of the pre-menu-disable state of my databases, but this is someone elses for which I can't find a backup.

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

Automated Access Launch Causing Access Window To Fail To Hide

Jul 10, 2006

Hi,
I have been using "fSetAccessWindow (SW_HIDDEN)" in the open event of my
main switchboard to hide the grey Access screen from being visible behind
forms, reports, etc in this db. But when I started using a .vbs script file
to launch the db, the Access window stopped being hidden. (The reason I use
the script for launching is that it temporarily sets the db's security level
to 1 which stops the macro security warning from coming up.) Apparently MS
knows about this happening and released a technique to rectify the situation,
but I don't understand their instructions. It looks like they expect one to
have more understanding than I have. Could someone help me get this
impliemented? Here is the article:
http://support.microsoft.com/kb/167659/en-us
Thanks!

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

Help: Pass Argument From Child Window To Parent Window?

Feb 15, 2005

Hi,

I have a parent window which upon clicking on a button will pop-up a child window containing a listbox. The listbox recordsource is a subset of the parent window. I want the user to select a record from the listbox which will load the selected record onto the parent window.

How does one pass argument back from child window to parent window?

From parent window to child window, I used
docmd.openform ,,,,,,[argument] and me.openargs in the child window

thanks in advance.

View 4 Replies View Related

Open Access App With Access Window Minimized

Mar 29, 2007

I already have this working by means of:

doCmd.RunCommand acCmdAppMinimize in Form_Load (or Form_Open) events.

This works great to hide Access and only display the main form (like a standalone app).

But I have 2 issues:

1. The PopUp form (main or "switchboard" if you like) opens, then Access is minimized, but then the form looses focus. If there are other programs running, form will be behind them!

2. Access is first seen opening (for a moment) and THEN minimized (see 1.). Is there a way NOT TO SEE IT at all? :)

Thanks!

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

Restore DB

Feb 15, 2007

Hi there...

Can some one plz guide me how to do restroe access database?

thanks
Danny

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

Main Access Window/form

Dec 12, 2005

I need to have Access open with a form that does not take up the entire screen and I don't want to see the Access stuff behind it. How can I make just the start up form appear when I open the db?

Thanks for any help...

View 3 Replies View Related

Access Main Window Resize

Mar 10, 2006

I'm working on an MS Access app.

The clients use this app with their monitor resolution set to 800 x 600.
Whenever I edit a form I need to set my screen resolution to 800 x 600 to make sure the form is within bounds.:mad:

I wan't a fast way to set the Main Access Window's size too 800 x 600 pixels.

Application.DoCmd.MoveSize(,,800,600) is supposed to work but I get a syntax error.

Any ideas?:confused:

View 3 Replies View Related

Minimizing Access Program Window

Feb 1, 2007

I have a VBA program that I wrote in access. My question is this: Is there anyway to eliminate or minimize the main Microsoft Access program window so all the user would see is my forms and the desktop? Not that ugly gray back drop? Thank you in advance for your help.

-Rob

View 2 Replies View Related

Moving Form To Top Right Of Access Window

Feb 15, 2006

I have a form which I want to move OnLoad to the top-right of the Access window. Something like this:

Private Sub Form_Load()
Me.Move Right:=150, Top:=150
End Sub

But there isn't a Right:=, only Left:=. So maybe I could find out the width of the Access window? Is this possible?


Thanks for any advice.

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

Unable To Access Database Window.

Oct 2, 2004

I have a .mdb that opens up to a form (a splash screen I would assume). However, I can not access the form design view or even get the database window. I thought limiting access to design view was done with .mde, even then you have access to the database window. Any explanation on this or help??

Thanks

View 2 Replies View Related

Hide Access Background Window

Jan 31, 2013

I am using Access 2010 and trying to hide the background access window, so that only my forms are visible to the end users.

After researching, I found these VBA codes, but I always get an error. I have changed all my forms & reports to Pop-up and Modal. This is the code that I use on OnLoad of the Main (first form):

Private Sub Form_Load()
Const SW_HIDE = 0
Const SW_SHOWNORMAL = 1
Const SW_SHOWMINIMIZED = 2
Const SW_SHOWMAXIMIZED = 3

[Code] ....

When I open my the database- the mian window is still there and I get an error

"The espression On Load you entered as the even property setting produced the following error: Only comments may appear after End Sub, End Function or End Property.

*The expression may not result in the name of a macro, the name of a user-defined function, or [Even Procedure].
*There may have been an error evaluating the function, event or macro.

Do I have to change any thing in File-> Options?

View 3 Replies View Related

Restore My Menus

Apr 13, 2006

I have an application that hides all the normal Access menus, so that the user can only use the buttons that I have put on the screen forms. Now however, when I open up access, I cannot get to any of the Access menus. It shows the toolbar, but not the normal FILE/EDIT...TOOLS/HELP menu.

How do I toggle this back on? Everything I have been able to find so far tells me to go to the TOOLS menu ---- I cannot get to the TOOLS menu.

Thanks. BTW, I am not really as stupid as this post makes me sound.

Mike Redmond

View 6 Replies View Related

Restore Query

Jun 14, 2005

I have 2 queries that have been hidden from view by right clicking on them and selecting the hidden button. How do I restore them to view again????

cheers

EQ

View 2 Replies View Related

Open Word Window On Access Form

Sep 6, 2005

Hello,
I am a researcher creating critical editions of ancient texts by collating readings from several manuscripts (i.e. different mss all contain minor differences). I create my edition in Word and use footnotes to record the variant readings. I also have a database - created from the word file - in which I can add context to each variant e.g. decisions, history etc. So I have a word file containing the text and its variants uniquely identified with a footnote reference and a database with one table and a record per variant and where the variant records are also unique and share the same number as the footnote. I would very much like to be able to open a window on my variant form which displays the word file at the correct variant (i.e. footnote reference) location. This will make it easier for me to record my assessments of the variant in the dbase while looking at where the variant occurs in the text. Obviously I don't need to see the footnote window as I have this info in the dbase.
I haven't got a clue how to do this and would appreciate any pointers.
Many thanks in advance,
Tim

View 1 Replies View Related

Hide Access Window Task Bar And Reports

Nov 15, 2005

All,

I've been using Dev Avish's excellent code shown within the sample database section to hide access windows. I've taken his call fsetAccessWindow function and set it to 1 or normal in two separate databases. Both databases seem to work slightly differently. The idea is that opening the database produces one Visible instance of access on the taskbar which is the purple standard graphic (Access 2000 / Windows 2000). With the first database I have set up reports through the active x control as required when using dev's code and even when I hit the report button the user is only aware of one visible instance of access as the purple colour graphic.

I am trying to implement the same code in a second database and have copied the code from the previous database into this database. It works great for the forms however there is a slight glitch when report forms are accessed. Rather than remaining with the purple access part on the task bar the task bar section is split into two between the form and the report. In the previous database users would not notice that the report had been opened at all. (although technically it was still running in the backrground)

I have checked most of the properties between the two database forms and they would appear to be the same..

Has anyone got any ideas why the taskbar is behaving differently between these two databases there must be some difference between my set up but as yet cannot find it??

Thanks Mark

View 3 Replies View Related

Open MS Access Window In A Certain Position And Size

Nov 27, 2006

Hi,

I would like to open the MS Access Window in a certain position and size.

Somehow similar to open a form when using:
- to set the position and size:

Private Sub Form_Load()
Form.Move Left:=11500, Top:=6500, Width:=7000, Height:=6000
End Sub

I would like to open the MS Access Window within the screen area at a certain location, and having a certain size.
Is there any option in the Access Menu, or I can write some code, and where has to be written, so when I double click on the *.mdb file, the MS Access Window will open where I want and the size I want.

Thank you.

View 8 Replies View Related







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