Рет қаралды 4,115
In this Microsoft Access tutorial, you will learn how to use the MoveSize command in VBA to program and control the coordinates of forms when opening them. You will explore properties like Left, Top, Width, and Height to read and set the desired location and size of forms. This tutorial is aimed at those with prior VBA knowledge who need to maintain consistent form placement in their Access projects.
Natalie from Carmel, Indiana (a Platinum Member) asks: How can I ensure that my Microsoft Access forms open in the exact location I want them to, even after making design changes? It seems like no matter what I do, Access opens the forms wherever it wants to. Is there a way to use VB code to program the form's coordinates so that it always opens in the specified location?
Silver Members & up get access to an Extended Cut of this video. Members will learn how to create user-defined functions for dynamic form positioning. Whenever you save a form, the position is saved. Open it up, the position is loaded. We'll use a system settings table to keep positions for all forms in the database.
MEMBERS-ONLY EXTENDED CUT VIDEO:
• Controlling Opening Fo...
BECOME A MEMBER:
KZbin: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
MoveSize: 599cd.com/Move...
PREREQUISITES:
Intro to VBA: 599cd.com/VBA
Status Box: 599cd.com/Status
LINKS:
Access Save Position Template: 599cd.com/SavePos
MEMBER LINKS:
Open Form Right: 599cd.com/Open...
System Defaults: 599cd.com/Syst...
System Settings: 599cd.com/Syst...
Form Positioning: 599cd.com/Form...
RECOMMENDED COURSES:
Access Developer 12: 599cd.com/ACD12
Access Developer Courses: 599cd.com/Deve...
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Mi...
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, MoveSize, WindowTop, WindowLeft, WindowHeight, WindowWidth, VBA command, form coordinates, form placement, consistent form placement, Microsoft Access tutorial, form location, form size, MoveSize in Access, form properties, Left property, Top property, Width property, Height property, reading window properties, setting form location, setting form size, control form opening, VBA programming, form design, design changes, Access form opening, programming form coordinates, Access form coordinates, Access form location, Access form size
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.