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.

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.

Picture in Database

By Candace Tripp (utter:angel) Access 2000 format

 

Demonstrates a method of displaying a picture/image file in a database/formwithout storing the image in a table.

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.

Dynamic Shortcut Menus

This is a demo of how to create shortcut menu bars from table data.

Unlike the shortcuts on normal shortcut menu bars all the shortcuts in the demo are driven by VBA. This allows altering the normal behaviour of the shortcut or creating your own.

In this demo the shortcut menu bar is generated in the On Current even of a continious sub-form. The shortcut menu bar could also be generated in the On Open event but the On Current event would allow modifing the shortcuts on the fly depending on current data in the record.

The shortcut data in the table can be flagged as required or not on a Form by Form basis.

Some of the examples given are: -
Spell check.
Sort ascending.
Sort descending.
Filter by selection.
Remove filter.
Call a public function with control data.
Call a public function with the primary key.
Export the current Sort/Filter selection to Excel, Word, etc.
Call public functions.
Execute hyperlinks.

Basically what this means is that if we can write code to do something then that code can be called from a shortcut.

The attached demo, in Access 2003, has been tested with many regional settings and requires no references.

DB Manager

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.