Access Treeview Example - Organization

13204 Downloads

Displaying Hierarcharical Data. This example uses Employees and the people under them with multiple levels.
Category: Example Forms
File Size: 141.2 KB
File Type: application/zip
Hits: 43120 Hits
Download: 13204 times
Created Date: 03-12-2016
Last Updated Date: 03-12-2016

Related documents

Peter Hibbs' Flex Grid Demo
Peter Hibbs' Flex Grid Demo

This demonstration database shows various methods of using the Flex Grid
ActiveX control in an Access 2000 (or later) database. Flex Grid controls can be
used to show data from a table or query on a form in a format which is not possible
using standard Access controls.

Wipe/Move/Resize Effects for Forms
Wipe/Move/Resize Effects for Forms

By Candace Tripp (utter:angel) Access 2000 format

 

This demo shows how to create nice "wipe" effects on a form event (such as form_close) using the Win APIs MoveWindow and GetWindowRect. Effects include: resizing, wipe up/down left/right, shrink/move, and shiver.

Wizard Form template
Wizard Form template

** Updated 1/9/2010 to handle an issue with Access 2010.

 

Document Links 2
Document Links 2

This is an update to the 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.

***** Because it doesn't use the hyperlink data type, this new version stores the path in a way that allows the folder to be easily moved. 

Universal Search on many text with details
Universal Search on many text with details

This is a revision of the Universal Search demo that shows how to search for a list of string values in ALL non-system tables in ALL fields for the current database.

To search for more than one string, enter the values in the text box in comma-delimited format.

These matching records are displayed in a list box. Double click an item in the list box brings up the detail view of the first 11 fields of that table.

 Author: Candace Tripp  http://www.utterangel.com/

Audit Trail
Audit Trail

By Candace Trip (utter:angel) - Access 2000 format

 

This db demonstrates how to set up an audit trail of changes to the data including ID, Field Name, the field value before it was changed, the field valueafter it was changed, the user who did the change, and the date/time the changewas made.