• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 734
  • Last Modified:

set an Access 2010 Form to open in a specific location

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
Joanne Bailey
Asked:
Joanne Bailey
2 Solutions
 
Dale FyeCommented:
Consult the help on the "move" method of the form.
0
 
Joanne BaileyDatabase AdministratorAuthor Commented:
On Load? On Current? On Open?
0
 
Dale FyeCommented:
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
hnasrCommented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
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
 
Dale FyeCommented:
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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now