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 Replies


ADVERTISEMENT

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

Modules & VBA :: How To Minimize Access Window And Open The Form On Top

Nov 16, 2014

Who can tell me how to minimize Access window while it's form is on top of other open windows (e.g. other applications which are maximized like Excel). By using acCmdAppMinimize command, only the Access window is minimized and if other applications are maxmized, they will be on top. So is there any vba solution to do what I explained?

View 4 Replies View Related

General :: How To Set Size For PDF File To Open Through Access

Apr 3, 2014

when I open a pdf through access weather it is by hyperlink or attachment it always opens the full size of my monitor, if I open a pdf outside access then they open ok , how do I set the size that access opens the pdf the size I want.

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

Reports :: Possible To Open A Report With Access Main Window Hidden?

Jul 18, 2014

I'm working on a database that produces employee contracts. To make it look as professional as possible I hide the Access main window when the splash screen loads using the ShowWindow function. The various forms to check and enter details all pop up without any problem, but when I get to the last stage where I use a report to produce the contract and then open it in PrintPreview mode, it won't display (unless I show the main window again , which looks very untidy!). Is it actually possible to display a report with the main Access window hidden?

View 6 Replies View Related

Size Of Viewing Window?

Mar 4, 2007

Hi All,

users can opening a file (either .doc, exe or .pdf) with additional data to the record they're looking at by clicking on a icon on a form. The icon has code behind it that opens the document (Application.FollowHyperlink NameDocTo Open). That opens the doc OK, no problem, but what is a problem is that the window for this document is exactly the same size as the window of the access form from which the second doc is opened.

The size of the access window is defined. I'd like to get the word or excel or pdf to be maximized. The weird thing is that I use the same code in another database and there the 'secondary doc' opens in a new window and of large enough size. How can the same code generate 2 outcomes? And how can I fix the issue described?

Thanks guys.

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

Controlling The Application Window Size

Jan 25, 2007

Can i set the physical dimensions of the MS Access main window from code, like when I open my first form?

My main development computer has a massive big screen, but I mainly program for 1024x768 screen. When the database appears on my screen I'd like to resize it bigger as I see fit, but have my code open it to a 1024x768 sized screen when it opens on someone else's computer.

View 2 Replies View Related

Change Font Size Of Sql Edit Window?

Nov 15, 2006

I'm running MS Access 2003. My SQL editing window has a really small font size. How do I change this window's default font size? Is it in tools or options?

Help!!!!!!! I'm going blind!!!!!!:confused:

Thank you for taking the time to read this and for being willing to help out!!

View 3 Replies View Related

Force Switchboard To Maintain Window Size

Nov 16, 2006

Is there any way to force the switchboard to maintain its pop up window size? Whenever I open an item from it that is maximised and then return to the switchboard it too has maximised.

Thanks

Russell

View 4 Replies View Related

General :: How To Make Form Controls Change Size / Position As Form Is Resized

Jul 24, 2013

how to make my form controls change size / position as my form is resized / loaded on a computer with a different resolution. Several of the tutorials out there suggest putting code on the "on resize" property of the form. When I looked at the Northwind database to try to mimic their code however, it looks like they must be doing something different as there is no on resize code under the form properties and I was unable to find the code they do use.

View 4 Replies View Related

Forms Are Opening In Same Window / How To Open Forms In Different Window

Oct 21, 2013

My application is developed in Access 2003 version. Recently we moved from Access 2003 to Access 2010. Now users are facing usability issues like - in Access 2003 all the forms are opening in different windows and they can move to forms easily. But in Access 2010 all the Forms are opening in same window, if they want to move to different forms then they need to close the current window or press ctrl+F6. How can I enable/open forms multiple window in Access 2010.

View 3 Replies View Related

Open A Form In A Small Window

Dec 7, 2006

Hello I have a database that opens in maximized form.
I also have another form that opens when a button is clicked.

What I want is for the second form to open small and not maximized like the main form.

Can this be done?

Thanks

View 2 Replies View Related

Open 2nd Form In Minimized Window

Apr 12, 2005

Hi all,

I have a main form which is open in a maximized window (which i want to leave as it is), i have a command button which opens a form, now i want the form to open up as the size of a box i have created in the form, without altering the size of the first form. Also is it possible to move the 2nd form to the bottom left hand corner of my screem.

This is code i have so far does minimize window to what i want it to but also restores first form, which i want t leave maximized:
Code: Me.InsideHeight = Me.Box15.HeightMe.InsideWidth = Me.Box15.WidthDoCmd.Restore
Thanks in advance for any help,
M-.

View 2 Replies View Related

MDB Size Limit - Will Not Open. HELP!

Jul 17, 2006

Hi - I have searched this board and cannot find anything that has worked. I'm hoping someone can help and maybe I've just missed it somewhere on this board. Here's the thing:

I worked for 3 months on a MDB and got it working the way I needed. I then ran it for the date range I needed and apparently hit a file size limit. I got the "invalid arguement" error and immediately stopped the query and did a "compact and repair". It looked like the compact and repair worked but then the mdb did not come back up as it usually does. I closed Access and tried to re-open the mdb. Nothing happens! No error - no nothing. It just plain will not open. I then tried to compact and repair again but that will not work even when I select it as the mdb to compact and repair. I even tried to open a new, blank mdb and link to the mdb that won't open..no go.

Does anyone have any suggestions on other things to try to get this to open again? Are the tables stored somewhere outside of the mdb that I can delete to make it smaller and open?? I'm grasping here..I know it..but i'm desperate to get this thing to open for me.

any help would be appreciated.

Caitlin

View 1 Replies View Related

Open Form On Close Of RelationShip Window

Aug 12, 2005

Folks,
i open my relationship window from a form and i after hide its visibility using the code below.
DoCmd.RunCommand acCmdRelationships
Forms![frmRelations].Visible = False
I need to open the hidden form after clicking on the close(x) button of the relationship window.
Are there any ideas please.

View 2 Replies View Related

Button To Open Windows Explorer Window

Jan 28, 2006

Hello everybody, it's been a while since i wrote on the forums and yet again I am in the need to ask for the help of this wonderful community.
I have a form on which is a button that I want when pressed to open a Windows Explorer window displaying the contents of a directory.
The exact way that I want this thing to work is like this : The user is browsing a form of lets say client details and on the form lies the button that when pressed will take the client's name and apply it to the path in order to open that Windows Explorer window and create a path like C:program filesclient name and display the contents of that window.
I would like if possible someone who can point me as to how I can construct this button to work cause I cant see to get it done.
Many thanks for your time :)

View 3 Replies View Related

Modules & VBA :: Open The Export To Excel Window?

Aug 21, 2013

Is there a command that I can use to export a spreadsheet to Excel...

I could use docmd.transferspreadsheet

however that would also mean i would need an input window where users would need to manually put in the location they wish to save to...

Instead, could i not get a "SaveAs" command window or a file browser at least for them to search that way?
Alternatively, If it was possible to use VBA to pop up the "Export - Excel Spreadsheet" window, that would be just as good.

View 2 Replies View Related

Modules & VBA :: OnClick To Open The Image In A Window

Jun 7, 2013

I am new to VBA for access. I am working on a form as a user interface. I have added an picture to the form and it will change, according to the selection in the combobox. It looks small, and not clear because of the size, and each image has different size. I would like to know if there is a VBA code that will allow me to click on it, and then it will open in another window so it is bigger with the right sizes.

View 6 Replies View Related

General :: Setting Open New Window Value To True

Jan 16, 2013

I was reading how to make a a button open a webpage. I found out how to and what to type in the Visual Basics. It worked but like another user said, when ever he clicks the button, the window opens for the website but the window is not maximized. He said "I set the open new window value to True".

View 1 Replies View Related

General :: Database Window Becomes Inactive And Cannot Open Another Form / Report

Aug 17, 2014

I have just noticed when I open one of my forms . the database window becomes inactive and I cannot open another , form , report etc.

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

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







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