DB Manager

3055 Downloads

Author: weAscend Technologies

 

Link to any MDB or MDE file and view/edit data in tables with an added search feature. (Access 97).

 

This show how to have a dynamic grid that adjust to the number of fields in the query

 

It can be updated to Newer vrsions.

 

Category: Example Forms
File Size:
File Type: application/zip
Hits: 8314 Hits
Download: 3055 times
Created Date: 08-31-2011
Last Updated Date: 08-31-2011

Related documents

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.

25 Cool Control Tricks
25 Cool Control Tricks

Author: database Creations

 

 

Schedule Grid - DesGrid
Schedule Grid - DesGrid

The company that originally deployed this product no longer supports it. The product has since given it to public domain  soley as an "as is" device. Their information has been stripped out of the attachments and manual. This tool is what it is and is considered "skilled" to "advanced" for level of developer skills to manipulate successfully.

Basically, you're on your own with this one. But it is an excellent portrayal of Access' capabitlies.

 

The download includes both  Access 97 and Access 2000 formats of these two files:

1) Orchid (the demo)

2) DesGrid (the un-altered components) 

Each contains a Month-Grid and an Hour-Grid. Also included is a PDF of the Manual.

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.

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/