Solved

Access 2013 - Forms

Posted on 2015-02-19
12
108 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
  • 3
12 Comments
 
LVL 48

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 48

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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

Author Comment

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

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 48

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 48

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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

696 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