25 Cool Control Tricks

10415 Downloads

Author: database Creations

 

 

Category: Example Forms
File Size: 520.04 KB
File Type: application/zip
Hits: 40054 Hits
Download: 10415 times
Created Date: 03-12-2016
Last Updated Date: 03-12-2016
License

Information on this Web site is provided to you "as is" for your personal use and at your own risk. HiTechCoach.com  makes no warranties or indemnities, expressed or implied, and assumes no liability in connection with the use of any information from this Web site.  Your download and use of this Content is solely at your own risk. HiTechCoach.com shall not be liable for any claims or losses of any nature, arising directly or indirectly, from the use or application of the Content provided.

Related documents

Exit with button only
Exit with button only

This example shows how to prevent a form from closing except by using a command button. The example is the main menu/switchboard form. Note that this technique can be easily used on any form.

Fancy Sort in Continuous Forms
Fancy Sort in Continuous Forms

Here's an interesting method of sorting columns in a continuous form. In this case, a subform is used, but the same can be applied to a main form. All the code is behind the form, so there is no need for a regular module.

In the attached Access 97 demo, all this code is in the "sfrmVST" form (a subform).

The first thing to do is to set up each column's title label with a consistant naming convention; "lblxxxxx". Then, each label has a "Tag" property value that contains the name of the 'field' it represents.

There is also another label that is set far to the left of the form. This particular label is special in a couple of ways. First, it's font is set to Marlett and it's visible property is set to "No". The caption of this label is the number "5". It is also important that the label be named: "lblSortIndicator". The "OnClick" event of this label should contain the following code:


Me.lblSortIndicator.Visible = False
Me.OrderBy = ""

Access Treeview Example - Organization
Access Treeview Example - Organization
Displaying Hierarcharical Data. This example uses Employees and the people under them with multiple levels.
Pop ups - Calendar, Calculator, Zoom box
Pop ups - Calendar, Calculator, Zoom box

Authior: Unknown

I have been using this code since 1993 with Access 2.0. The download file includes the Access 2.0 version,. I have also included the upgraded versions for Access 97, Access 2000, and Access 2007. 

 

It has a Zoom Box, Calendar and Calculator created with just native Access controls. The pop up forms can be used to edit the data in as many  text box controls as needed. The controls can be on the same form or multiple forms.


Orders.mdb and Solutions.mdb
Orders.mdb and Solutions.mdb

The Orders and Developer Solutions sample databases that are included with earlier versions of Microsoft Access were not included with Access 2000.

The Orders and Developer Solutions sample databases for Access 2000 are now available

Orders   The Orders sample application is a sample order entry and invoicing system. Its features include the ShowEvents form, which helps you see the order in which events occur when you are working with forms and controls, and custom data filtering capabilities that you can use in addition to the filtering functionality provided by Access. The initial chapters of Microsoft Access 2000: Building Applications with Forms and Reports explain how to build the features shown in the sample application.

Developer Solutions   The Developer Solutions sample application contains examples of the forms, reports, and interface elements you most commonly use to create applications. From changing a form’s toolbars in response to events to creating a crosstab report with dynamic column headings, the objects in Developer Solutions illustrate the main areas of application design. This sample application also includes procedures that you might find useful as you develop your own applications—for example, you will find procedures that link tables at startup, close all objects when the user exits the application, and capitalize the first letter of every word in a field.

For more details see: Microsoft Access 2000: Building Applications with Forms and Reports

 

Spreadsheet-like Entry Data Form Demo
Spreadsheet-like Entry Data Form Demo
**** Disclaimer ***

If you are new to database modeling or looking for a way to make Access act like Excel, this demo may not be for you. This demo represents a special case of data entry and is in no way a substitution for proper normalization, single form presentation among other things and in all probability will have limited use, if any, for several business models out there.

This database demonstrate how to create a entry form that provides a spreadsheet-like view and live form that can be updated real-time using a bound datasheet form. While this form uses checkboxes, there is no reason why it can't use textboxes or comboboxes, as long as this is a matrix of where each combination of a given row and a given column can only have exactly one value. In other words, no aggregating are actually done. This is useful for users who want to have a 'bird's eye view' and editing multiple records in a junction table representing a many-many relationship in a single form.

The demo is a class attendance record where it is assumed that new classes are created, and attendees registered for a given class are done in a separate forms (not included). The default form will display a selected class with attendees within the registration roster and dates specified for class meetings. All checkboxes are updateable, and new columns can be added for additional sessions. Attendee names are locked and the form will not allow additions, as per the assumptions.