|
This
seminar has two main goals. You will learn how to:
1.
Build a calendar form to edit appointments
2.
Create a printable monthly calendar report
You will begin
by creating a basic table
to store our appointment data. We'll also make a simple form to edit and
add new records.
Next we'll build an
appointment list form, where we can see all of our
appointments. Double-click on an appointment to open and edit it. We'll
also make a checkbox to allow us to see open vs. closed appointments
(close it when you're done with it). You'll also learn about
triple-state checkboxes where you can see open, closed, and ALL
records.
In the next lessons we'll build a form to pick a date using a built-in
Microsoft Access ActiveX Calendar control. Using this
date, we'll generate our own form that looks like a full-sized monthly
calendar, complete with all of our appointments on it.
One of the things we're going to learn how to do is make the first day
on our calendar form figure out what the first Sunday
on or before the start of the month is, then build the rest of the
calendar accordingly, greying out any days that are before or after the
selected month. We'll tackle that with a little bit of VBA programming.
Of course, you'll be able to double-click on any
appointment on the calendar to open up a popup form to edit that
appointment.
Then, once the form is completed, we'll create the printable
monthly calendar report. We'll actually make two versions -
I'll show you how to lay it out portrait and landscape.
This
seminar is perfect for anyone who wants to do any kind of
scheduling in Microsoft Access. You can store your appointments, edit
them easily, and print out professional-looking monthly calendar reports
- all from within Access.
This
seminar is long (almost two hours) but it's broken up into
easily managed lessons of about 10 minutes each. You can sit down,
watch a lesson, review the material, test the code out yourself, and
experiment. Do a little bit each day. It's long, but it's comprehensive
- you won't miss a single step as I've recorded everything from
start to finish.
All
of the sample database files are available on my Web site
(instructions on where to download them are in the course videos). They
are available in Access 2007 and 2000 formats.
This
seminar is available to view online in the Amicron Theater.
You can
click here to watch the first two lessons absolutely free.
NEW: If you would
like to download a copy of the database we build in this class so you
can look it over and see if it will meet your needs, then click on one
of these links:
-
Access 2007
-
Access 2010/2013
The sample databases are only available for
Access 2007 and 2010/13, however we do cover Access 2000 and 2003 in the
class.
Of
course, if you have any questions about whether or not this seminar is
for you, please contact me.
Access Calendar Seminar Outline
00. Intro (7:35)
Topics Covered
Pre-Requisites
01. Create Database (7:02)
Turn on Overlapping Windows
Create Database File
Create Calendar Table
Create Calendar Form
02. Appointment List 1 (13:56)
Form to List Appointments
ApptListF
Double-Click to Open Appt
OnDblClick Event
Show Closed Items
Checkbox
03. Appointment List 2 (7:54)
Triple State
Checkbox
Show Closed, Open, All Appts
Create Dynamic SQL Rowsource
Refresh Button
List.Requery
Change Form Caption in VBA
04.
Monthly View Form 1 (11:39)
CalendarQ With Short Time
DatePickerF
Enter a Date
Start Monthly Form
05. Monthly View Form 2
(10:23)
Day 2 of our Calendar Form
Text Boxes to Show Dates
Make 7 Boxes for the Week
06. Monthly View Form 3 (11:30)
Calendar Control
Calculate First Day of Month
First Sunday on or Before
1st
07. Monthly View Form 4 (10:51)
Grey Out Days of
Diff Months
Forms!Form("FieldName") Notation
&HFFFFFF Color Notation
08. Monthly View Form 5 (10:26)
Shrink Text
Get Rid
of Horizontal Scrollbars
DblClick Event to Open Appointments
Use Excel to
Generate VBA Code
09. Calendar Report 1 (9:40)
Design
Printable Monthly Report
10. Calendar Report 2 (12:14)
VBA Code Rewrite for Reports
Using the Detail Build Event
11.
Review (3:39)
|
