Solved

set an Access 2010 Form to open in a specific location

Posted on 2013-06-21
6
692 Views
Last Modified: 2013-08-08
Hello experts,
I would like an Access 2010 form to always open in a specific location on the screen. How do I accomplish this?
0
Comment
Question by:JoanneSB
[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
6 Comments
 
LVL 48

Expert Comment

by:Dale Fye (Access MVP)
ID: 39266443
Consult the help on the "move" method of the form.
0
 

Author Comment

by:JoanneSB
ID: 39266930
On Load? On Current? On Open?
0
 
LVL 48

Accepted Solution

by:
Dale Fye (Access MVP) earned 250 total points
ID: 39267058
I like to use the Load event. Only fires once for each form, but you could use the Open event as well.

Private Sub Form_Load()

    Me.Move 1440, 1440, 7500, 7500
   
End Sub
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.

 
LVL 30

Assisted Solution

by:hnasr
hnasr earned 250 total points
ID: 39267856
You may incorporate a settings table for forms.
In Load /Open event search for the forms record and use the respective values in Move statement.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 39287798
Not that some techniques to do this will place the form on the screen based on the users monitor resolution...
So the form may not appear in the *exact* same location on each users computer, ...but may remain in the same "relative" position...
0
 
LVL 48

Expert Comment

by:Dale Fye (Access MVP)
ID: 39394617
You could also store it in a table: tbl_User_Form_Pref:

UserID
FormName
FormLeft
FormTop
FormWidth
FormHeight

I rarely see a need for this level of detail, but I do use a similar technique with datasheets, because everyone likes to see their datasheets formatted a little differently.
0

Featured Post

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

705 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