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 that we
started in Developer 9. We're going to hide the "begin test" button when
the test starts, we're going to show "question 1 of X", we're going to
learn how to determine if another form is open, and if so, make changes
to it, close it if a parent form closes (for example, if we close the
Test form, the Question form will close). Lots of new
tips and tricks in this lesson.
Next we're going to add
some timers to the test form. We're going to track the
start and end time for the whole test,
and for each question. This way you can see how long it took the student
to complete the test, and which questions took the longest/shortest
amount of time to answer. And we'll set a maximum time
that they have to complete the whole test. If they're not done in time,
the form will close.
In Lesson 3 we're starting
a new project. We're going to make a Universal Dialog Box.
This is a box that is basically like a Message Box (msgbox) on steroids.
You'll be able to change colors, fonts, buttons, etc. eventually. We're
going to begin building it in this lesson.
This is the 11th 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 11