[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

set an Access 2010 Form to open in a specific location

Posted on 2013-06-21
6
Medium Priority
?
718 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
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 earned 1000 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
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
LVL 31

Assisted Solution

by:hnasr
hnasr earned 1000 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
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

656 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