Peter Hibbs' Flex Grid Demo

749 Downloads

For example, you can show a group of records where each field background or text
colour can be different for each record. You can shows 'continuous' records with
the field heights altered to match the amount of text in the field. You can show
a switchboard form using a Flex Grid control to give access to dozens of forms or
reports with just two button clicks. You can use the Flex Grid to show a simple bar
graph and so on.

You can change the layout of the Flex Grid to suit the type of data being displayed.
You can set the font, font sizes, field alignment, etc for each individual field as
well as displaying graphic images in any cell.

The demo program shows all these techniques as well as a method to edit text in a Flex Grid cell.
Two MS Word documents are also included which give more information and full
installation instructions.

Just unzip the Flex Grid Demo.zip file to a folder on your hard drive and then
read the enclosed documents.

Category: Example Forms
File Type: application/zip
Hits: 30145 Hits
Download: 749 times
Created Date: 06-18-2017
Last Updated Date: 06-18-2017

Related documents

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.
ComboBox trick like on web pages
ComboBox trick like on web pages

Here is an example of how to make a combo box display text like "Find a Customer" and then when you click the drop down arrow, the text goes away. This is similar to what you see on web pages.

The attached is in 2000 format.  

 

Document Links
Document Links

This is a basic example of how to store the path to  a file and also be able to view the file. You can browse using the standards windows common dialog to select the file. You can view the file using the application defined with the Windows File Associations. It uses the ShelExec API to open the file. It does not use the .Followhyperlink  method.

This example is a continuous form that could easily be used as a sub form to attach multiple documents to a record.

25 Cool Control Tricks
25 Cool Control Tricks

Author: database Creations

 

 

Document Text stored in tables
Document Text stored in tables

This example shows how to use tables to store the all the parts of a document.  An  exmaple web be for  creating contracts.

This example also shows how to use cascading sub forms. This is where two sub forms on hte parent for are linked. The first sub form shows records related to the Parent form's current record.. The second sub fom (on the parent form) shows related records to the current record in the other sub form.

Access Treeview Example - Organization
Access Treeview Example - Organization
Displaying Hierarcharical Data. This example uses Employees and the people under them with multiple levels.