Access
Developer 12 continues our focus on learning how to program the
Visual Basic for Applications programming language (VBA) in
Microsoft Access.
Topics include:
 |
-
Universal Dialog Box, Parts 2 & 3
- Add OK,
Cancel Buttons - DoEvents in Timer Loops -
Global Variables, While Loops
- Custom Form Positioning - Move, Resize Form
Windows in VBA -
Twips, InsideHeight, InsideWidth
- External String Manager -
Dynamic Labels on Forms and Reports - Lots more |

Order Now |
If you would like a preview of what's covered in this class,
click here to watch the first
and last lessons of
this course (free of charge), or scroll down for more information.


|
This class continues our look at programming in Visual Basic for
Applications in Microsoft Access (VBA, or Access VB). We're
continuing on with the Test Taker database and the
Universal Dialog Box that we
started in Developer 11. First, we'll add OK and
Cancel buttons to the uDialog and see how we can return a value
to the code that called the box. We'll learn about global
variables, while
loops, and the DoEvents command.

Next we'll study custom
form positioning. We'll learn about the different types
of form window dimenstions: Height, Width, InsideHeight, InsideWidth,
WindowTop, WindowLeft, and so on. We'll learn what Twips
are and how they relate to pixels and screen inches. We'll see how to
resize and move form windows using the
Me.Move and MoveSize commands. We'll use the OnResize event, and see how
we can use a timer to check if a form is moved. We'll
learn how to center a window on the screen.

Moving back to the uDialog
box, we'll learn how to resize the individual controls
on the form, such as the prompt label. We'll have to use a little math
to calculate the dimensions of the form window and the
size of the command buttons to move
and resize the OK and Cancel buttons
correctly, but it can be done.

Finally, we'll build an
External String Manager. If you have ever had to
support multiple copies of a database for different types of users, such
as users who speak different languages, then this
concept will be perfect for you. Instead of keeping two or more separate
front-end forms, or even whole databases, you can use a table to store
the strings in them (such as "First Name") and then pull those in based
on the language preference of your user. This will be a collection of
events, a few support tables, a DLOOKUP or two, and
we'll make our own custom GetString function.

This is the 12th class in the Access Developer series. If you're
serious about building quality databases with Access, and you want to
learn how to automate your database with VBA Programming then don't miss out on
this course. Of
course, if you have any questions about whether or not this class is
for you, please contact me.

Complete Outline - Access Developer Level 12

|
Keywords:
Access VBA, Visual Basic for Applications, microsoft access tutorial, microsoft access tutorial, microsoft access training, universal dialog box, external strings manager, form positioning, while loops, DoEvents, return function value twips, insideheight, insidewidth, me.move, movesize |