Solved

set an Access 2010 Form to open in a specific location

Posted on 2013-06-21
6
662 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
6 Comments
 
LVL 47

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 47

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 47

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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.

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now