Agenda
April 10, 2007
Main Presentation
Topic: Calendars in Access" -- not just date-pickers, but using calendar - format forms and reports
Presenter: Cecilia Bogan
Cool Add-ins
Drag-n-dropper
Drag-N-Dropper is an MS Access module and form that you can add into
your Access application to provide drag and drop functionality between text-based Access controls.
Drag-N-Dropper allows text to be moved or copied (using "CTRL-Drag") between text-based MS Access
controls (text boxes, combo boxes, and single select list boxes) by clicking on the desired text,
dragging to the new control, and releasing the mouse button. While dragging, Drag-N-Dropper
actually displays the dragged text next to the mouse arrow as it is dragged around the screen!
Additionally, Drag-n-Dropper allows you to re-order list box rows with drag and drop. Just drag a
list box row to its new position, and release the mouse button. By using a special
field in the underlying table, Drag-n-Dropper can move the row, and maintain the new sort order.
It's easy to add into your new or existing applications. Just import the Drag-N-Dropper module and
form, add one line of
code to each form, then add three lines of code to each control that you will be dragging from.
Calendar Report
This Access 2000 sample shows how to create several different calendar style reports. There is a
doctor/patient schedule that displays a week-at-a-glance with dates across the top and times along
the left (sample). Each appointment is "drawn" with the proper size
and position. A similar report places multiple doctors across the top for a single day schedule.
A standard monthly calendar is also included
(sample). This report uses copies of the same subreport for each day. A
gantt type report (sample)
is included which displays time bars across longer periods of time.
|
