Solved

Access 2013 - Forms

Posted on 2015-02-19
12
106 Views
Last Modified: 2015-02-23
My OS is win 7 prof 64 bit and i use Access 2013.  I have a small app, and when the Form is opened when the App is loaded, the Form is maximized in that I am unable to hit the X button to close it.  Is there a way to load the Form by code, so that it occupies about 95% of the screen, so that I can  click on the task bars to move it around.  Thank u for your suggestion.
0
Comment
Question by:jegajothy
  • 5
  • 4
  • 3
12 Comments
 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 500 total points
ID: 40619987
You should be able to use the Forms Move method, which lets you position the form and size it all in one.

Private Sub Form_Open

    me.Move 1440, 1440,  9*1440, 9*1440

End Sub

This should make the form 9"x9" and offset it 1" from the bottom of the ribbon and 1" from the right margin of the navpane
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 40619989
Assumes that you have the forms configured for overlapping windows, not tabs, which is the default in later versions of Access.
0
 
LVL 75
ID: 40620008
Noting that 1440 Twips = one inch, and the parameters for move are in Twips.
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

Author Comment

by:jegajothy
ID: 40620163
In response to Date Eye, thank u for the code  solution,  it works.   Gracias
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 40620217
You're welcome.

BTW, that's "Fye", not "Eye"
0
 
LVL 75
ID: 40620223
I thought it was Fried ... humm
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 40620229
Yeah, Joe, there has been a lot of that lately too.  One of these days, I'll find some time to finish the CommandBarTool.
0
 
LVL 75
ID: 40620237
It's really close ...
If you could just fix that last minor issue .. about no equals sign in front of - what would be a Macro name - in the Parameter property
0
 

Author Comment

by:jegajothy
ID: 40621083
in response to DatabaseMX, I am not sure I understand what u are trying to convey, hope u could please give in solution form.  Thank u for your participation.
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 40621124
jegajothy,

Sorry, that was just a discussion between MX and me.
0
 
LVL 75
ID: 40621785
Sorry ...
0
 

Author Closing Comment

by:jegajothy
ID: 40626151
thank u.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question