• All interfaces are easy to integrate into your applications
• Tables are used extensively to drive the interfaces to make customization easy and flexible
• Totally open, includes all source code
• Year 2000 compliant

EZ Extensions contains the following components:

Digital Clock - The EZ Extensions Digital Clock is a stand alone form that shows the current system time. It's unique feature is it can be resized by grabbing the side borders of the form and making the form larger or smaller. The developer can change the appearance of the clock including font, colors, time formats, etc.

Pop-up Calendars - Several pop-up calendars are included. These are self-contained forms that can be opened by themselves or called by another form to fill a value in a control. There are buttons to move ahead or behind a month or year at a time. If you are dealing with time, you can set the time by pressing the button with a picture of a clock on it and a time clock will appear to make entry of time easy.

Single Month Pop-up Calendar

Pop-Up Calendars are used frequently to fill a form control with a date. Microsoft Access itself has an OCX or Active X calendar control. You can use the Pop-Up Calendar here instead of the Active X calendar control when you want the flexibility to modify the appearance and the functionality of the calendar. The calendars here provide the following features:

• standard alone form that can be opened to just view a monthly calendar
• pop-up form that will return to the calling form and control, the selected date and optionally time
• easy means to create a form with more than one calendar by using the monthly calendar as a subform
• sizable calendars
• calendars that can be changed in appearance (fonts, colors, control locations, sizes, etc)
• display pictures on each day
• developer control of the interface to the calendar
• all self contained with no global variables, modules, or external references
• completely written in Access Basic
• set starting day of week

Time Clock - This is a time selection pop-up form that you can use to enter a time. Easily choose the current time or press the buttons to enter the time you want. When you press OK, the form will return the time to the calling form.

Event Scheduler - There are times when you need to create records based on date and time. These could include task schedules, events, meetings, appointments, deadlines, deliveries, etc. You might also want to create a schedule to perform or execute queries, macros, procedures, or other programs. With the Event Scheduler wizard, you can easily create entries in a table based on user input. Your application could then use the table as appropriate for your specific needs.

The structure of the tables and wizards can be modified as necessary, but they could be used as is to provide a working system. The wizard can create one time, hourly, daily, weekly, or monthly events.

This is an example of the Wizard screen displaying daily occurance options. The options displayed may vary depending on the event and frequency the user selects. Click on the picture to view a larger version of the example.

Event Processor - The Event Processor interface is designed to process events at certain dates and times and execute specific instructions. These events could be simply to display a message, or actually run a query, macro, function, or any other program. This capability is useful to automate application and data maintenance, including batch processing, posting, backups, replication, compressing, tracking capacities, etc. The system also can record when an event occurred as well as the status or result. A sample table with holidays for the years 1999, 2000, and 2001 is included.

Calendar Reports – Based on a table of events, these redesigned reports can print daily, weekly, and monthly calendars. Each report can list the events to occur.

Containers – Simulate the Access Database container and modify the contents to be what you want your user’s to see. You can use these methods to create other user application interfaces.

To use EZ Extensions, you must know the basics of Microsoft Access. This includes knowing about Access objects and how they are used. You do not need to know how to program in VBA (Access Basic) but you must know how to add a simple button to a form and enter one or two lines of VBA code to the OnClick event of the button.

We provide several sample definitions and a sample table to learn how to use the EZ Extensions product.