Audit Trail

2218 Downloads

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.

Category: Example Forms
File Size: 32.22 KB
File Type: application/zip
Hits: 35254 Hits
Download: 2218 times
Created Date: 03-12-2016
Last Updated Date: 03-12-2016

Related documents

Centering a form in the Access window
Centering a form in the Access window

Author:  Peter Schroeder

This  example (A2K format) contains a module that can be used to reliably center (both horizontally and vertically) a form in the Access Window. There is a very simple demo of how it works, as well. The module itself uses Windows API calls to determine the Access application client area and the dimensions of the form in question, and calculates what the TOP and LEFT settings of the form should be to be centered in the Access window.

 

To use, simply insert the entire modCenterForm into your own database. It is called as follows:


Code:


 

Call gfncCenterForm([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 = ""

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.

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.


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.

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