Solved

Access 2013 - Forms

Posted on 2015-02-19
12
105 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
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

803 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