Solved

Access 2013 - Forms

Posted on 2015-02-19
12
107 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 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
EXCEL Name Matching 13 44
pull a field from a programme into Excel 4 17
Outlook 2016 10 43
Malwarebyte error running MsOffice 2010 5 19
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
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 …

733 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